How To Create Multi-Object JSON Arrays in SQL Server

Recently I was discussing with Peter Saverman whether it would be possible to take some database tables that look like this:

And output them so that the Cars and Toys...

How To Create Multi-Object JSON Arrays in SQL Server

Recently I was discussing with Peter Saverman whether it would be possible to take some database tables that look like...

How to Update @@SERVERNAME to Actual Machine Name?

The @@SERVERNAME Global Variable
The system global variable @@SERVERNAMEcan be used to return the name of the machine the SQL Server...

Key Sets, or Inverted Keys - defining a key as a set of tuples

TL;DR:
I have been doing a lot of thinking about data models for the last couple of weeks. I have, just...

Mapping SQL Trace to Extended Events

Since I started actively participating in SQL community, I found it is very common that people will approach to seek...

Moving to an Azure SQL Database via Command Line

I have moved many databases to Azure via different methods but I recently came across a new way. Well technically...

Power BI Custom Visuals Class (Module 82 – Text Filter)

In this module you will learn how to use the Text Filter Custom Visual. This visual allows you to filter...

Recovering the PsGallery Repository behind a Corporate Proxy

While getting a new workstation is usually nice, reinstalling all your softwares and settings is definitely not the most pleasant...

Start/Stop Group of Azure RM VM's

For testlab purposes, I often have a group of Azure VMs to manually spin up/spin down at once. I've had...

What The Doctor Ordered

I recently went to our local pharmacy to pick up some prescriptions. There was one for my boy and one...