A reader wanted a script to remove spaces from every column name in all tables. Here it is, with a warning first: renaming columns can break your application.
SQL SERVER – Getting to understand SQL Server Activity Monitor in SSMS
My notes on the lesser used parts of Activity Monitor in SSMS, like Resource Waits, and how the tool builds them from sys.dm_os_wait_stats at each refresh.
Offloading Backups to a Secondary Replica: Notes from the Field #108
Offloading backups to a secondary replica takes work off the primary server. In Notes from the Field #108, Eduardo Castro explains backup priority and read-only routing for AlwaysOn availability groups.
SQL SERVER – Unable to drop login – Msg 15170, Level 16, State 1
Cleaning up my demo server, I could not drop login danny because of Msg 15170: the login owns a job. Here is how to find what a login owns and remove it.
SQL SERVER – Error and Fix for Msg 1907 Cannot recreate index The new index definition does not match the constraint being enforced by the existing index
Moving to a Clustered ColumnStore Index can throw Msg 1907: cannot recreate index, as the new definition does not match the constraint. Here is why and the fix.
SQL SERVER 2016 – New T-SQL Functions – COMPRESS – DECOMPRESS
SQL Server 2016 adds two new string functions, COMPRESS – DECOMPRESS. Here is how they work, with examples, and the error you get on older versions.
Free Tools Worth Knowing for SQL Server Work
Free tools for SQL Server work include Microsoft editors, built-in diagnostics, and community scripts; learn the job each handles and its limits.