Before I dropped an unused index, my client’s CEO wanted proof. Here is how to find queries using an index from the SQL Server plan cache.
SQL SERVER – How to Change Authentication Mode Using T-SQL Query
A software vendor shipped SQL Express with Windows-only login by mistake. Here is how to change the authentication mode to mixed mode with a T-SQL query.
SQL SERVER – Always On AG – HADRAG: Did not Find the Instance to Connect in SqlInstToNodeMap Key
After unexpected failovers, an availability group would not come online: Did not find the instance to connect in SqlInstToNodeMap key. This is how we solved it.
SQL SERVER – Timeout Occurred While Waiting for Latch: Class FGCB_ADD_REMOVE
Latch FGCB_ADD_REMOVE timeouts mean a data file is growing slowly. Measured on SQL Server 2025: 4 GB of data in 98 ms, 4 GB of log in 2.3 seconds.
Comparing Old and New Values in a Trigger With inserted and deleted
Build a small audit trigger that joins inserted and deleted, handles NULL changes correctly and ignores saves that change nothing.
SQL SERVER – SQL Server Management Studio Crash While Using Backup to URL or Connecting to Storage
During an urgent restore, SSMS crashed each time my client picked URL to restore from Azure Blob Storage. Here is how to fix the crash when connecting to storage.
SQL SERVER – Event ID: 2004 – Resource Exhaustion Diagnosis Events
A client with SQL Server memory issues saw Event ID 2004, Resource Exhaustion Diagnosis Events, naming sqlservr.exe for low virtual memory. Here is what it means.