Articles by Martin Catherall

OPENJSON and CROSS APPLY

June 10th, 2020

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

Read More

OPENJSON and an Alias

June 9th, 2020

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

Read More

OPENJSON : Getting to the data, and the PATH – PART I

June 8th, 2020

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

Read More

Hypothetical Indexes – Part 1

September 23rd, 2019

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

Read More

SQL Server Service Broker – Part 3

September 16th, 2019

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

Read More

SQL Server Service Broker – Part 2

August 27th, 2019

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

Read More

SQL Server Service Broker–Part 1

August 21st, 2019

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

Read More
Warwick

Hi, I'm Martin Catherall, I am a Microsoft Data Platform MVP and Data Platform consultant for SQL Masters Consulting. In my blog posts I will look at all things Microsoft Data Platform to assist your professional development.

Search