Extended Events

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.

When you look at the Extended Events in the SSMS, is it a local time or server time? Let’s find out.

I’ve come up with an efficient way to monitor only specific data changes in a table.

I was investigating a mysterious Intent Shared lock in a deadlock report. Especially confusing, since the database was using an Optimistic Concurrency.