Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Query Store Entering Error State
Extremely rarely Query Store can end up in ERROR state because of internal errors or due to race...
Date: 06/27/2018
Query Store Best Practices for Mission Critical or Busy SQL Server
Query Store feature helping lot of SQL Admin in isolating top resource consuming queries quickly and...
Date: 10/20/2017
Query Data Store Forced Plan behavior on AlwaysOn Readable Secondary
We are getting following questions repeatedly from many customers so thought of writing a quick blog...
Date: 10/13/2017
Log Reader Agent Fail on Always On availability Groups configured on Multi-subnet
Recently I was working with one of Microsoft Partner on following issue wherein customer was...
Date: 08/09/2017
SQL SERVER Transactional and Merge Replication internal and work flow explained
Recently Sravani and I delivered session on SQL SERVER Transactional and Merge Replication and...
Date: 05/30/2017
Troubleshoot 586 error message id with state 5 - The prepared statement handle 1 is not valid in this
Recently I worked with one of customer where in jTDS application getting an error 586 and in...
Date: 03/31/2017
Utility Control Point reporting incorrect CPU utilization when Server has more than 40 logical processor
Recently I have worked with one of customer wherein Utility Control Point (UCP) reporting incorrect...
Date: 03/22/2017
Msg 13575 OR Msg 13542 error message while adding period columns
You may see following error message while trying to enable system-versioned temporal table and...
Date: 11/29/2016
SQL SERVER 2016 installation failing due to MSVCR120 missing Update (EXCEPTION_ILLEGAL_INSTRUCTION)
I was working on one of SQL SETUP issue with my colleague Shaurabh Thapa where in SQL SERVER 2016...
Date: 11/23/2016
SSMS behaviour if you have Cluster Shared Volume and C drive repeating while choosing ___location for backup\restore\database attach
Consider this scenario, when you try to attach, restore or taking database backup using SQL SERVER...
Date: 11/23/2016
“Backup and Restore Events” standard database report do not show all backup failure events
While investigating backup failure related issue on SQL SERVER 2008 R2 I was trying to pull the...
Date: 06/26/2015
How to track inactive logins in SQL SERVER
Many customer asked me if there is any easy way to find the list of logins which are inactive and...
Date: 07/31/2014