New Extended Events in SQL Server 2022

SQL Server 2022 CTP is here
It has been announced today (2022-05-24) during the MS Build event. The blog post includes a download link. Unfortunately, the Docker container is...

Efficient Cheating at Lego Video Games

Foreword
I’ve started to play Lego Video games with my daughter, and since it’s one of her first games, it can be a little frustrating.
Even though there are no high...

Cross DB Access With Module Signing

Foreword
I’ve recently had to revisit this topic and spent a lot of time recalling the details. So I’m writing this blog post mainly as a reminder for myself.
The most...

Why my way of writing SQL is superior

⚠️ It’s hard to convey sarcasm over the text. I’m putting this disclaimer at the top so I don’t come off egoistic. This post is meant as hyperbole, and...

Query Hash and Query Plan Hash Mapping

The problem
As a fan of Dynamic Management Objects (DMOs), Query Store and Extended Events, I often work with the Query Hash and Query Plan Hash (I’ll refer to them...

KEEP PLAN Demystified

Foreword
I was always wondering what the KEEP PLAN hint does. The documentation isn’t very specific (emphasis mine):

Forces the Query Optimizer to relax the estimated recompile threshold for a query.

In...