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.