SQL Puzzle 5: Prime Magic

Quite a few of you have read or attempted the previous puzzle SQL Puzzle 1: Magic Squares
As a quick reminder, when...

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

A Basic Bot using Azure Bot Services

I wanted to break out my comfort levels and do something different from Azure SQL Database or straight SQL Server....

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

Do You Really Need Real-Time?

It wasn’t so long ago that the first day of the month was the most common trigger event for updating...

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

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