Azure Data Factory and the Exact Online REST API – Fetching your first refresh/access tokens

5 years ago

UPDATE 1: the layout seems to have been updated, but at the time of writing (Feb 2026), you can still…

Azure Data Factory and the Exact Online REST API – Introduction

5 years ago

I'm going to do a small blog post series on how to extract data from a REST API using Azure…

Techorama 2021 – Session Materials

5 years ago

You can find the slides and the scripts used at Github. Hopefully we'll see each other next year at an…

The GREATEST new T-SQL Function

5 years ago

If the title isn't obvious enough, this blog post is about the new function GREATEST, and it's sibling LEAST. But…

Speaking about Snowflake at Techorama 2021

5 years ago

I'm delighted to announce I'm selected to give an introduction to Snowflake on Azure at the virtual Techorama event. You…

Book review: Calling Bullshit – The Art of Skepticism in a Data-Driven World

5 years ago

I recently finished the book Calling Bullshit - The Art of Skepticism in a Data-Driven World by Carl T. Bergstrom…

#TSQL2sday 136 – Your Favorite Data Type

5 years ago

It's T-SQL Tuesday time again, and this month's honor to host the blog party goes to Brent Ozar. The topic…

SSIS and the “ORA-00907: missing right parenthesis” error

5 years ago

I had the extreme pleasure recently to extract some data out of an Oracle database. I wrote the source query…

STAR SCHEMA ALL THE THINGS

5 years ago

The title says it all, but I'll explain it anyway. When building a data model that will be used for…

Small Multiples in Power BI

5 years ago

In the December 2020 release of Power BI Desktop, a long-awaited feature was added as a preview: small multiples (also…