A client had slow performance out of nowhere. The cause was TDE effects on TempDB after someone tested encryption on production. Here is what I learned.
SQL SERVER – How to get historical deadlock Information from System Health Extended Events?
Let me start off by asking a simple question. How many of you have seen this error about historical deadlock information earlier?
How to Get Random Records from Table? – Interview Question of the Week #105
How do you get random records from a table? This interview question never gets old. Here is the ORDER BY method I use because its syntax is easy to remember.
SQL SERVER – Database Mirroring Login Attempt Failed with Error ‘Connection Handshake Failed’
A friend using certificates on workgroup machines hit a database mirroring error: Connection Handshake Failed. Here is how I tracked it down in the ERRORLOG.
SQL SERVER – SSMS – Script Out Multiple Objects
Do you script objects one at a time in SSMS out of habit? There is a quicker way to script out multiple objects in one go, and here is how.
SQL SERVER – Fix Error Msg 13603 working with JSON documents
Msg 13603 appeared when I used a custom path with FOR JSON PATH, because the column alias had an invalid character. Here is how to fix it.
SQL SERVER Puzzle – Conversion with Date Data Types
Converting values with CAST can round in ways you don’t expect. A puzzle on Date Data Types: guess the output of each query before you run it.