Articles by Martin Catherall

OPENJSON is pretty central to manipulating JSON documents in T-SQL. As we’ve seen, we can use a default schema that..

Using Aliases in T-SQL is very common. We can alias both Tables (FROM clause) and Columns (SELECT clause) and some..

Recently we reviewed FOR JSON PATH. That was used for shaping tabular data (data that comes directly from a SQL..

I recently came across a production SQL Server with a large amount of hypothetical indexes – nearly 1000. I’d occasionally..

In Part I we looked at some general Service Broker concepts, and then in Part II we wrote some code..

In part one we looked at some general Service Broker concepts, so now its time to get our hands dirty..

There’s several ‘hidden gems’ in SQL Server, and some of these have been in the product for quite some time..