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…

Happy 2022

3 years ago

Or is it April 2020? Not sure. Anyway, I'd like to extend my best wishes for the upcoming year. I…

New Argument for STRING_SPLIT Function

3 years ago

A new (optional) argument has been added to STRING_SPLIT: enable_ordinal. Setting it to 1 will add an output column with…

T-SQL Tuesday #143 – Short code examples

3 years ago

It's this time of the month again! T-SQL Tuesday is a monthly blogging party on the second Tuesday. This month's…

Speaking at PASS Data Community Summit

4 years ago

I'm delighted to announce that I've been selected to speak at the (revamped) PASS Data Community Summit. Alas, PASS is…