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.
Sometimes the quickest help you can get is to help yourself. I’ve compiled a list of common problems when I’m helping out in the SQL community.
This month’s invitation is from John McCormack. I’m sharing few handy short snippets that I use on regular basis.
I’m using this trick to find potential problems with a new feature I’m considering.
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.