A developer creating a table in SSMS got a pop-up: You are not logged on as the database owner or system administrator. Here is what the message means.
SQL SERVER – XML Document Could Not be Created Because Server Memory is Low. Use sp_xml_removedocument to release XML documents
XML document could not be created, error 6624, on a server with 300 GB free. What OPENXML really costs, measured, and why XQuery is the fix.
SQL SERVER – Reporting Services Not Starting After Maintenance Window
Reporting Services not starting after maintenance? On my lab server every SQL service came back except SSRS. Here is what the log showed.
PREEMPTIVE_OS_DEVICEIOCONTROL: DBCC CHECKDB Will Not Stop
A DBCC CHECKDB session waiting on PREEMPTIVE_OS_DEVICEIOCONTROL did not end, even after a stop job and a kill. The wait is outside SQL Server’s control, so nothing inside SQL Server could clear it. Restarting SQL Server removed the session.
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 – 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.