TSQL

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.

This month’s invitation is from Brent Ozar. In this post, I’ll share my (surprising) choice of a favourite data type and not surprising choice of least favourite one as well.

Believe it or not, there is a wrong and correct way when it comes to generating XML documents in SQL.