SQL Server Blog

Azure Data Studio – 7

July 23rd, 2020

With the creation and utilisation of Notebooks in Azure Data Studio, there are already a number of kernels that you..

Read More

Azure Data Studio – 6

July 16th, 2020

One of the beauties of Azure Data Studio as a tool for Data Professionals, is it’s flexibility for you to..

Read More

Azure Data Studio – 5

July 9th, 2020

As Azure Data Studio continues to grow and bring new features allowing us to be more productive in our day-to-day..

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

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