Msg 15170: this login is the owner of 1 job(s) and cannot be dropped. Here is how to find those jobs and reassign them first.
Magic Numbers in Code: Replacing Status Codes With a Lookup Table
Nobody remembers what the 3 means. Give each status code an approved name, let the database enforce it, and leave your data alone.
SQL SERVER – Upgrade Failure – The Cluster Resource is Not Online. Bring the Analysis Services Server Online Before Starting the Upgrade Process
Upgrade and one need to evaluate them before making a final choice. Let us see an error related to Upgrade Failure. Let us learn today.
SQL SERVER – Previewing Old Azure Backup Blobs Before Removal with PowerShell
Backup Files From Azure Storage need a retention review before removal. I list the candidates before approving any cleanup.
How to Write Case Statement in WHERE Clause? – Interview Question of the Week #127
How to write CASE statement in WHERE clause? First, CASE is an expression, not a statement. Here is how to use it for optional search conditions.
Reverting a Failed Deployment With a Database Snapshot
A snapshot can undo a bad release in minutes. See what comes back, what is lost for good, and why your log backups need a fresh start.
Domain Controller – Startup Issue – Unable to Use Domain Account as Service Account When Read Only Domain Controller (RODC) is Involved
SQL Server would not start under a domain account when a Read Only Domain Controller (RODC) was involved. Here is what fixed it.