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

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

Converting a Datarow to a JSON object with PowerShell

This is just a quick post. As is frequent with these they are as much for me to refer to...

T-SQL Tuesday #097: Learning Plans

If you are not progressing, you are regressing. In the same vein, if you are not learning, you are regressing.
Related Posts:

T-SQL Tuesday #102: Giving Back May 8, 2018

T-SQL...

T-SQL Tuesday #097: Learning Plans

Stylishly Late
I am fabulously late and therefor breaking the guiding rules that make up TSQLTuesday. Where’s the ruler to slap...

Azure ARM template function internals

I have been working with azure arm functions for quite a while and they are exceptionally useful but also quite...

Azure ARM template function internals

I have been working with azure arm functions for quite a while and they are exceptionally useful but also quite a pain to work with, visualizing what it is...