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.
SQL SERVER – Event ID: 10028 – SQL Server Distributed Replay Client – DCOM was Unable to Communicate with the Computer
Event ID 10028 from the SQL Server Distributed Replay Client flooded a client’s event log and buried the data we needed. Here is how to stop the noise.
SQL SERVER – SSIS – Package Error: “ODBC Source” Failed Validation and Returned Validation Status “VS_NEEDSNEWMETADATA”
A client’s SSIS package failed: “ODBC Source” failed validation and returned validation status “VS_NEEDSNEWMETADATA”. I explain which metadata and the fix.