How do you find the row count of every table in a database without a cursor? An interview question, answered with a fast query instead of a loop.
SQL SERVER- Error: 18204, Severity: 16 – Backup Failure – Operating System Error 1240 (The Account is not Authorized to Log in From This Station)
A client’s backups to a file share failed at random with error 18204 and OS error 1240. The error message pointed to the real cause of this Backup Failure.
SQL SERVER – How to Change Database Compatibility Level?
Compatibility Level controls selected query behavior within a database. I baseline the workload before changing it.
SQL SERVER – Configuration Manager – Cannot Connect to WMI Provider. You Do Not Have Permission or The Server is Unreachable
SQL Server Configuration Manager said: cannot connect to WMI provider, you do not have permission or the server is unreachable. Here is the fix.
SQL SERVER – Login Failed – Server is in Script Upgrade Mode – Deleting Collection Set “Utility Information”
Script upgrade mode stopped at a collection-set cleanup in this client case. Inspect progress and history metadata before considering any maintenance.
SQL SERVER – FIX: Msg 35250, Level 16, State 7 – The Connection to the Primary Replica is Not Active. The Command Cannot be Processed
Joining a database to an availability group failed with Msg 35250: the connection to the Primary Replica is not active. Here is why and how to fix it.
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.