SQL Server setup failed with an error generating the XML document. The real cause was DPAPI and a read-only domain controller, found in Summary.txt.
SQL SERVER – Error 33222, Level 16 – Audit ‘MyAudit’ Failed to Start
Error 33222 says only that the audit failed to start. Reproduced on SQL Server 2025: where the real reason hides, and why CREATE succeeded.
Grouping by query_hash to Find Cheap Queries That Cost the Most
Group cached statements by query_hash to find high total CPU and reads, compare plan hashes, and account for missing cache history.
SQL SERVER – Express and SQL Server Agent – Free Alternative
Small Express database, big performance problems? Here is a free alternative that fills the gap between SQL Server Express and SQL Server Agent jobs.
SQL SERVER – Huge Size of Table catalog.execution_component_phases in SSISDB
SSISDB was huge, and the biggest table was catalog.execution_component_phases. Here is what fills it, like retention period and logging level.
SQL SERVER – The Lease between Availability Group ‘PRODAG’ and the Windows Server Failover Cluster has Expired
The lease between availability group and the Windows Server Failover Cluster has expired: a common error. Here is what each ERRORLOG line means.
What is the Difference between SUSPECT and RECOVERY PENDING? – Interview Question of the Week #114
What is the difference between SUSPECT and RECOVERY PENDING? A reader moved databases to a new drive and they went into recovery pending. Here is why.