TSQL

When you look at the Extended Events in the SSMS, is it a local time or server time? Let’s find out.

In previous blog post I’ve shown you how to cheat. This time we’ll learn how to play and score our guesses using TSQL.

Your Twitter feed is probably already full of Wordle posts, so I thought, why not add one more? I’m starting the series with one goal - find the optimal way to play.

How can 15 be less than 13? Let’s have a look at this unexpected, but fully documented behaviour.

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.