Investigation
What is causing my constraint to be untrusted?
A CHECK or FOREIGN KEY constraint keeps reverting to untrusted overnight. Here is how to catch the BULK INSERT or bcp process doing it, with Extended Events.
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
Investigating Errors With Extended Events
Production errors are hard to reproduce. Here's my go-to Extended Events session that captures errors with their full TSQL calling stack.
Out with the old…
WordPress was making me hate blogging. Moving to Hugo, GitHub, and Azure Static Web Apps fixed that.
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.