Script upgrade mode can reject logins for a while after a SQL Server update, and in this 2017 client case the startup log stopped at a collection set cleanup. This post shows how to read error 18401, check whether the upgrade still moves and size the msdb logging tables with tested queries.
SQL SERVER – Ransomware Protection and Recoverable Offline Backups
Ransomware recovery depends on protected backups and controlled access. I test whether those recovery copies survive the loss of normal systems.
How to Change Owner of Database in SQL SERVER? – Interview Question of the Week #117
How do you change owner of a database in SQL Server? Three ways, including ALTER AUTHORIZATION, which I prefer, and the deprecated sp_changedbowner.






