A full-text index can block the redo thread of a readable Always On secondary. This post shows the three clues to read in sys.dm_exec_requests, how to find the internal table and how to check change tracking. It ends with the fix: manual tracking and a scheduled population.
DBCC PAGE Alternative: Read Page Headers with T-SQL
The best DBCC PAGE alternative is the function sys.dm_db_page_info. This post builds a demo table, lists all of its pages with the allocation view, and compares one page with DBCC PAGE. It also explains the two modes and the page wait use.
Always On Listener Creation Fails: Attempt to Locate a Writable Domain Controller Failed
Always On listener creation can fail because the cluster cannot finish its directory work. In a 2018 client case, the same failure hit three clusters. This post shows how to read the cluster event, check DNS and directory permissions, prestage the listener object and verify the result.
Always On Redo Queue Grows: Version Store Is Full on the Secondary Replica
An Always On redo queue that keeps growing means a secondary has log records waiting to be applied. In one client case the cause was a full version store in tempdb. The tests here show how a long read builds the version store on SQL Server 2025 and which queries find it.
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.
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.