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.
Query Store default settings Tom 2021-09-23 3 minutes Query store is a great tool and comes with a set of default settings. But what are the values exactly?
Investigating Errors With Extended Events Tom 2021-09-06 4 minutes This is my go-to technique to capture errors which I can debug later.