Vikas Rana
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