Azure Storage Account

This blog post aims to provide an overview of Azure Storage Accounts. It will explain how to create them and use them effectively. Azure Storage Account Azure Storage Account...

Create First Azure Data Factory Pipeline

In my previous post, we explored the basics of creating First Azure Data Factory. Today, I want to delve deeper into the process of creating and configuring pipelines within...

What Is Azure Data Factory?

What Is Azure Data Factory? Azure Data Factory (ADF) is a cloud-based PaaS data integration solution that provides a fully managed, serverless environment for ingesting, preparing, and transforming your...

Azure Resource Group

What is Azure Resource Group? Azure Resource Group is a powerful feature that enables effective organization and management of resources in the Azure cloud. A Resource Group is a...

Creating Your First Azure SQL Database

Azure SQL Database is a cloud-based database service that offers scalability and flexibility to handle large workloads. It’s based on Microsoft SQL Server Database Engine and provides a managed...

Best way to monitor high worker thread on SQL Server

It is common to see high worker count issue on the production server and it can have a range of negative impacts on SQL Server performance and stability, potentially...

Track SQL Server Database Recovery Progress – ErrorLog

This question has come up many times how to capture the SQL Server Database Recovery Progress or Total time take to recover a database. It will help to plan...

Only one Log Reader Agent can connect to a database at a time error – Transaction Replication/CDC

An interesting issue regarding SQL Server Transaction Replication/CDC log reader agent job can’t be started with the following error:

Msg 18752, Level...

Powershell Error – Import-Module AzureRm

I was playing with SQL Azure on my brand new Surface pro device.  I open the Windows Powershell ISE as administrator to...

Snapshot Agent Acquires schema modification (SCH-M) lock on all the articles of a publication

As the business requirement, It is very common to see a request for adding a new article or subscription to...