Mar 22

SQL SERVER: Shrink Log File of all databases in one script

The script will create a SQL command from a select of sys.master_files and then will create a cursor for that to execute each SQL command alone after. The script is written in Transact SQL, and this is the Format of the script : This is the code : DECLARE @sqlcommand…

Sql Server

1 min read

SQL SERVER: Shrink Log File of all databases in one script

The script will create a SQL command from a select of sys.master_files and then will create a cursor for that to execute each SQL command alone after.

The script is written in Transact SQL, and this is the Format of the script :

This is the code :

DECLARE @sqlcommand…

Dec 20, 2021

JAVA: Understanding Hibernate

Hibernate is an open source ORM (Object Relational Mapping) type solution which facilitates the development of the persistence layer of an application. Hibernate therefore allows you to represent a database in Java objects and vice versa. What is ORM ? Object-Relational Mapping (ORM) is a technique that lets you query and manipulate data from…

Java

2 min read

Dec 19, 2021

Build & Deploy Using Azure DevOps from AWS ECR to Kubernetes On premises

Some Clarifications of the variables : imageRepository: the Name of the repo in AWS ECR containerRegistry: the url of the AWS ECR service, in your account tag: the tag of the image imagePullSecret: the name of the kubernetes secret awsServiceAccount: the service connection name to your aws account vmImageName: the build machine os type awsRegion: the aws region for your ecr. kubeSvcConfig: kubernetes…

K 8 S

2 min read

Build & Deploy Using Azure DevOps from AWS ECR to Kubernetes On premises

Mar 8, 2021

Automate your SQL Server backups into S3 bucket

Code PowerShell of Backup Databases from SQL Server to S3 bucket files Here is the code, read it carefuly it’s much simple ################################## Preparing Env New-Item -Path “C:\” -Name “tempSqlBackup” -ItemType “directory” -Force New-Item -Path “C:\” -Name “tempSqlZip” -ItemType “directory” -Force $SqlBackup = “C:\tempSqlBackup\” $SqlZip = “C:\tempSqlZip\” ################################## Backup DBs except tempdb, master Import-Module SQLPS

Powershell Script

4 min read

Automate your SQL Server backups into S3 bucket

Sep 10, 2020

Brief of Diabetes

The hormone insulin secreted into the blood by cells in the pancreas called Langerhans Islands “the name after the scientist Paul Langerhans who discovered it.” …

Medecine

3 min read

Published in The Startup

·May 13, 2020

Understanding Hadoop Hive

Hive is a data warehouse system which is used for querying and analysing large datasets stored in HDFS. It process structured and semi-structured data in Hadoop. Hive Architecture

Hive

5 min read

May 12, 2020

Understanding Hadoop Yarn

YARN — Yet Another Resource Negotiator, is a part of Hadoop 2 version, is one of the two major components of Apache Hadoop (with HDFS). It plans the use of cluster resources as well as the treatments applied to the data. Architecture

Big Data

4 min read

Published in Analytics Vidhya

·Apr 10, 2020

Understanding Hadoop HDFS

HDFS (Hadoop Distributed File System) is a distributed file system for storing and retrieving large files with streaming data in record time. It is one of the basic components of the Hadoop Apache framework, and more precisely its storage system. HDFS Hadoop is one of Apache’s top level projects. Architecture

Hadoop

4 min read

Apr 9, 2020

Understanding Hadoop MapReduce

MapReduce is a clustered data processing framework. Composed of Map and Reduce functions, it distributes data processing tasks between different computers, then reduces the results in a single summary. How MapReduce works

Hadoop

4 min read

Mar 6, 2020

Build your search engine with ElasticSearch (Part 1)

we will use in this article ElasticSearch which is a flexible and powerful open-source, distributed real-time search and analytics engine. Using a simple set of APIs, it provides the ability for full-text search. Elastic search is freely available under the Apache 2 license, which provides the most flexibility. How ElasticSearch works : The ElasticSearch…

Elasticsearch

3 min read