The redo queue kept growing on an Always On secondary replica, and the ERRORLOG said version store is full. Here is what I found and why it happened.
SQL SERVER – Azure Key Vault Deletion Error – Vault ‘ProdRecoveryVault’ Cannot be Deleted as There are Existing Resources Within the Vault
Not an Azure Key Vault after all: a Recovery Services vault that would not delete. The AzureRM script is retired, and soft delete waits 14 days.
SQL SERVER – Configuration Manager Error: The Server Threw an Exception [0x80010105]
SQL Server Configuration Manager failed with: the server threw an exception [0x80010105]. The usual KB did not apply to Windows Server 2008. Here is the fix.
How to Find Queries Using an Index From SQL Server Plan Cache? – Interview Question of the Week #195
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.