Parsing JSON in SQL Server with OPENJSON

3 years ago

Recently I had a piece of JSON of which I needed to extract data from to put into a table…

Book Review – Mastering Snowflake Solutions: Supporting Analytics and Data Sharing

3 years ago

Disclaimer: Apress gave me a free copy of the book to review. People that know me, also know I always…

Execute SQL Scripts on Snowflake using Azure Data Factory

3 years ago

Azure Data Factory has a new activity introduced this week (around the 10th of March 2022 for you future readers):…

Extracting Data from the AFAS REST API with Azure Data Factory

3 years ago

AFAS is a Dutch business software company, proving companies with ERP and HR software-as-a-service. You can extract data from the…

Dynamically Map JSON to SQL in Azure Data Factory

3 years ago

We're reading in some JSON files in Azure Data Factory (ADF), for example for a REST API. We're storing the…

T-SQL Linting in an Azure Devops Build Pipeline

3 years ago

Linting is a process where a code analyzer is run to find programmatic errors, bugs, "stylistic constructs" or anti-patterns. For…

DirectQuery to Power BI Datasets

3 years ago

A new feature has been added to the Power BI Desktop toolset and it's a very nice one. The official…

Speaking at Techorama 2022

3 years ago

I've received some good news: Techorama is back with an in-person conference! I'm selected as a speaker and I'll be…

Convert Local Datetime to UTC (pre-SQL Server 2016)

3 years ago

Recently I was working with a client who was still on SQL Server 2012. Support issues aside, there are some…

Speaking at SQLBits 2022

3 years ago

I'm delighted to announce I'll be speaking at the SQLBits conference in March 2022! I'm not delivering one session, but…