SQL Server Blog

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

Pass Summit 2019

November 14th, 2019

Pass Summit 2019 was once again on in Seattle Washington, USA from Monday 04 November – Friday 8 November. This..

Read More

Data Privacy, Security and Ethics for the Data-Driven Professional

November 14th, 2019

In this day and age of data explosion as a Data Professional we need to take this very seriously. When..

Read More

Pass Summit 2019

November 6th, 2019

Pass Summit 2019 starts today in Seattle. Day 1 Keynote brings us a lot of news for all things in..

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

SQLSaturday #894 – Perth (Azure Data Studio)

August 29th, 2019

SQLSaturday #894 Perth, Australia is back on Saturday 07 September, 2019 and if you have not yet registered there is..

Read More

SQLSaturday #894 – Perth (Cosmos DB)

August 29th, 2019

SQLSaturday #894 Perth, Australia is back on Saturday 07 September, 2019 and if you have not yet registered there is..

Read More

Azure Data Studio–4

August 27th, 2019

Azure Data Studio gives you the ability to configure various options to meet your requirements on how you work. This..

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
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