The Curious Engineer

All blogs / Databases

Vikas Rana

learn.microsoft.com/en-us/archive/blogs/vikas_rana

DatabasesMicrosoft blogsMSDN archive

’15’20’25
Posts
12 from 31 Jul 2014 to 27 Jun 2018
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/vikas_rana/feed.xml

2018 1

  1. Query Store Entering Error State

2017 6

  1. Query Store Best Practices for Mission Critical or Busy SQL Server
  2. Query Data Store Forced Plan behavior on AlwaysOn Readable Secondary
  3. Log Reader Agent Fail on Always On availability Groups configured on Multi-subnet
  4. SQL SERVER Transactional and Merge Replication internal and work flow explained
  5. Troubleshoot 586 error message id with state 5 - The prepared statement handle 1 is not valid in this
  6. Utility Control Point reporting incorrect CPU utilization when Server has more than 40 logical processor

2016 3

  1. Msg 13575 OR Msg 13542 error message while adding period columns
  2. SQL SERVER 2016 installation failing due to MSVCR120 missing Update (EXCEPTION_ILLEGAL_INSTRUCTION)
  3. SSMS behaviour if you have Cluster Shared Volume and C drive repeating while choosing location for backup\restore\database attach

2015 1

  1. “Backup and Restore Events” standard database report do not show all backup failure events

2014 1

  1. How to track inactive logins in SQL SERVER