SQL Server Blog

Being able to quickly and easily connect to our Azure subscriptions definitely makes our lives easier as a data professional…

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

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

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

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

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

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

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

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