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

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

Disable or Turn-off SQL Server Telemetry Service

With SQL Server 2016, Microsoft is installing SQL Server Telemetry or CEIP (Customer Experience Improvement Program) Services by default. It...

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

Save the Connection String Parameters in SSMS – AlwaysOn

In the SQL Server AlwaysOn setup, whenever you are using a listener to connect to a secondary node, you have...

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