Extended Events Timezones Tom 2022-03-21Helping out 3 minutes When you look at the Extended Events in the SSMS, is it a local time or server time? Let’s find out.
Expecting Subvertations Tom 2021-12-08Helping out 5 minutes How can 15 be less than 13? Let’s have a look at this unexpected, but fully documented behaviour.
How to audit data modifications with surgical precision Tom 2021-12-04Helping out 7 minutes I’ve come up with an efficient way to monitor only specific data changes in a table.
IS Lock in RCSI Enabled Database Tom 2021-11-22Helping out 5 minutes I was investigating a mysterious Intent Shared lock in a deadlock report. Especially confusing, since the database was using an Optimistic Concurrency.