Your SPID shows KILLED/ROLLBACK and never seems to finish. Here is what that state means, why SQL Server sometimes cannot undo the work and what to do next.
Test Data That Looks Like Production
Test data that looks like production matches distributions, relationships, and volume without copying sensitive values into development.
SQL SERVER – FIX – Server principal ‘Login Name’ has granted one or more permission(s). Revoke the permission(s) before dropping the server principal
DROP LOGIN failed with Msg 15173 because the login had granted one or more permission(s) after an AlwaysOn cleanup. Here is how to find and revoke them.
SQL SERVER – Secure by Default – The Mantra
At SQLSaturday Sri Lanka an attendee asked me about security practices for SQL Server. This post shares my thoughts around the secure by default mantra.
SQL Server – 2016 – New Feature: Dynamic Data Masking
Would you want your credit card number shown in clear text? Dynamic Data Masking, new in SQL Server 2016, hides sensitive data right in the database.
SQL SERVER – Login failed for User ‘NT AUTHORITY\ANONYMOUS LOGON’ – ERRORLOG
A reader’s event log and ERRORLOG filled up with Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’. Here is why it happens and how SPN errors are involved.
SQL SERVER – Basic Statistics Maintenance – Notes from the Field #083
Statistics help the SQL Server engine pick an optimal plan. This Notes from the Field episode covers the basics of statistics maintenance every DBA should know.