CPU Usage History helps me establish when a reported problem began. It gives a timeline rather than identifying the responsible query.
Encrypt PII Data in SQL Server 2016: Notes from the Field #132
To encrypt PII data in SQL Server, first decide where each value must stay readable. Mike Lawell’s guest lesson is kept, and tested examples now show what masking hides, what cell-level encryption protects, and why Always Encrypted rejects plaintext sent from a query window.
SQL SERVER 2016 – Developer Edition Does Not Expire Like Evaluation Edition
Developer Edition is not the 180-day Evaluation Edition. I check the edition before treating a calculated date as an expiration.
The Row Version Tag: Page Splits After Turning On RCSI
Turn on RCSI and every row you update gets a little bigger. On packed pages that means page splits, and I show the numbers on a small demo table.
How to Send Execution Plan in Email? – Interview Question of the Week #079
After answering over 2000 performance emails, I saw that many users do not know how to send execution plan in email. Here is the easy way to do it.
SQL SERVER – Detected a DTC/KTM in-doubt Transaction with UOW
A client database went SUSPECT after a cluster failure and DTC reinstall. The ERRORLOG showed a DTC/KTM in-doubt Transaction with UOW. How we fixed it.
SQL SERVER – Fix Error Msg 13602 working with JSON documents
Working with JSON documents in SQL Server 2016? You can’t use FOR JSON inside an UPDATE statement, and trying gives Msg 13602. Here is how to work around it.