SQL

Azure Data Studio – 14

October 4th, 2020

Managing and Maintaining a SQL Server environment is nothing new to most of you. You are probably used to managing..

Read More

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
Blog

Hi, I'm Warwick Rudd, I am a Microsoft Data Platform MVP as well as a Microsoft Certified Master working as the Principal Consultant here at SQL Masters Consulting.
In my blog I will look at all things SQL Server as well as some things outside of the SQL Server relm but hopefully you will find them helpful and interesting.

Search