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.

This month’s invitation is from Mala Mahadevan. I’ll be covering several of my favourite code standards.

The SQL Server 2022 CTP has dropped, and I took a look at the new Extended Events that are available.

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.

I’m reminding myself how to set up secure CrossDB access. This blog post includes a nifty diagram and follow-along example.

Aaron Bertrand has thrown a gauntlet on Twitter. Instead of commenting on how you do stuff differently, blog about it yourself. Well, challenge accepted!

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.