Extended Events

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?

This is my go-to technique to capture errors which I can debug later.