Backup Files From Azure Storage need a retention review before removal. I list the candidates before approving any cleanup.
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.
SQL SERVER – Msg 15137, Level 16 – Error Related to sp_xp_cmdshell_proxy_account
A client using a proxy account to run xp_cmdshell hit Msg 15137 with sp_xp_cmdshell_proxy_account. Here is what causes the error and how I fixed it.
Join Duplicates: Stop Hiding Extra Rows With SELECT DISTINCT
Diagnose join duplicates before using DISTINCT, verify order and payment totals, and choose aggregation or EXISTS for the required result.
FORMAT Function in SQL Server: Dates, Numbers and Speed
The FORMAT function turns a date or a number into text with one pattern, and it needs SQL Server 2012 or later. This post shows the patterns for dates and numbers, the culture argument, and the lower case mm that silently returns minutes instead of the month. It also measures FORMAT against CONVERT over 200,000 rows, so you know when to use which.
SQL SERVER – Not Able to Kill SPID with KILL WITH STATUSONLY
Can’t kill SPID with KILL WITH STATUSONLY? It reports a rollback, it does not start one. Why KILLED ROLLBACK lasts, and why to wait.