Extended Events

I haven’t had a rant post in a while. There is a saying: “Anything before the word ‘but’ is ignored”. I love Extended Events, but … reading the extended event file is so much pain.

This month’s invitation is from Grant Fritchey, inviting us to talk about one of my favourite tools in SQL Server - the Extended Events.

This blog post will show you how to find and affect the default Extended event file target’s path.

Have you ever encountered a situation where you mark the constraint as trusted, but the next day, it’s back to untrusted again? This blog post will help you find the cause.

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

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.

Have you ever wondered what the purpose of the KEEP PLAN hint is? The documentation doesn’t help this time. Look no further than here to find out.