Scary Scalar Functions - Part One: Parallelism
Consultants hate me for this one weird trick. Because I’ll be uncovering all the mess Scalar functions can cause in a series of articles.
Posts
Coding Standards (T-SQL Tuesday #151)
This month’s invitation is from Mala Mahadevan. I’ll be covering several of my favourite code standards.
New Extended Events in SQL Server 2022
The SQL Server 2022 CTP has dropped, and I took a look at the new Extended Events that are available.
Efficient Cheating at Lego Video Games
Entering cheats in Lego Video games is incredibly time-consuming. So I’ve used the power of SQL to save a few keystrokes and optimize my cheating experience.
Cross DB Access With Module Signing
I’m reminding myself how to set up secure CrossDB access. This blog post includes a nifty diagram and follow-along example.
Why my way of writing SQL is superior
Aaron Bertrand has thrown a gauntlet on Twitter. Instead of commenting on how you do stuff differently, blog about it yourself. Well, challenge accepted!
Query Hash and Query Plan Hash Mapping
If you ever had a problem mapping the binary hash from DMVs to the numeric one in Extended Events - this is the blog post for you.