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.
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.
SQL SERVER – Could Not Use View or Function ‘msdb.dbo.sysdac_instances’ Because of Binding Errors
SQL SERVER – Could Not Use View or Function ‘msdb.dbo.sysdac_instances’ Because of Binding Errors. Let us learn how to fix the error.
SQL SERVER – Jump in Identity Column After Restart
A change in SQL Server 2012 can cause a jump in identity column values after a restart. Here are the steps to reproduce it and what you can do about it.