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

Author: Vikas Rana 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...

Author: Vikas Rana 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...

Author: Vikas Rana 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...

Author: Vikas Rana 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...

Author: Vikas Rana 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...

Author: Vikas Rana 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...

Author: Vikas Rana 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...

Author: Vikas Rana 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...

Author: Vikas Rana 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...

Author: Vikas Rana 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...

Author: Vikas Rana 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...

Author: Vikas Rana Date: 07/31/2014