A script to audit login and role member changes in SQL Server, tested end to end, including the failed attempts most people never think to capture.
SQL SERVER – Msg 3136, Level 16 – This Differential Backup Cannot be Restored Because the Database has not Been Restored to the Correct Earlier State
I was trying to teach copy-only backups to my students and encountered below error related to differential backup.
How to Find Median in SQL Server? – Interview Question of the Week #116
There is no MEDIAN function in T-SQL. Here is an easy way to find median values in SQL Server 2012 and later, plus what median really means.
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 – 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 – 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.