How to
Query Hash and Query Plan Hash Mapping
DMVs and Query Store store the query hash as binary(8), but Extended Events shows a number, and the two refuse to match. Here's how to map between them.
Notes from a TSQL trench
Database stuff,
with a side of memes.
Long-form notes on TSQL performance, Extended Events, Query Store and the tooling around them. Written from the trenches, not the slide deck.
Featured
Latest posts
Work Life Balance (T-SQL Tuesday #141)
Work-life balance has been my focus for the past year and I've already made some changes to my lifestyle. Now it's time to take a look back and evaluate.
Containers and Me (T-SQL Tuesday #140)
It took three tries before containers clicked for me. Each time I learned a bit more, but it wasn't until I had my own project that it all came together.
My Favourite Data Type (T-SQL Tuesday #136)
Brent Ozar asked the SQL community about their favourite data type. My answer surprised even me - sql_variant. Here's why, plus the data type I can't stand.
My Experience Doing the Online Proctored Exam
My impressions right after taking an online proctored exam. There were a couple of problems I ran into. Hopefully, this article will help you prepare.
Generate XML documents efficiently
Believe it or not, there is a wrong and correct way when it comes to generating XML documents in SQL.