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.
Query store is a great tool and comes with a set of default settings. But what are the values exactly?