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...

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...

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...

AlwaysOn Data Synchronization in Synchronous and Asynchronous Mode

When you are working on the AlwaysOn feature, it is crucial to understand how the AlwaysOn commit process works. This...

Fastest Way to Find Row Count of All Tables From All Databases in SQL Server

There are many times you as DBA or Developer needs to get all row count from all tables or row...

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...

SQL Server Enterprise Edition-Core VS Server+CAL – Demo on differences

In this blog, I am NOT going to discuss the SQL Server licensing model. If you are looking for that...

How to Change SQL Server License or Product Key?

Yesterday, I was doing SQL Server Database stress and benchmarking testing on the client side. When I started ramping-up more...

Have you ever wonder why Log Send Rate doesn’t show against Primary Replica on the AlwaysOn Dashboard?

Recently, I was working on the AlwaysOn Availability group issue where the log records were not moving from primary to...

Failed to join local availability replica to Availability Group – SQL Server error 41106 and 41158

When you configure SQL Server AlwaysOn Availability Group from management studio, it may fail with below error while joining secondary...