Who dropped table or database objects on your server? I show how the default trace, which runs in every SQL Server install, can answer these who questions.
SQL SERVER – Transparent Data Encryption and Frequently Asked Questions
A banking DBA quizzed me about TDE on SQL Server 2008 R2. Here are the Transparent Data Encryption questions and answers from that 30 minute chat.
SQL SERVER – SPID is KILLED/ROLLBACK state. What to Do Next?
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.