Azure Data Factory and the Exact Online REST API – Retrieving Data from an Endpoint

5 years ago

Finally we've come to the core of this blog post series: extracting data from a REST API endpoint. Just to…

Azure Data Factory and the Exact Online REST API – Retrieving the Divisions

5 years ago

In many ERP software you have the concept of "companies" or "divisions", a way of logically dividing resources and assets.…

Azure Data Factory and the Exact Online REST API – Getting a new access token from ADF

5 years ago

Before we create pipelines to fetch data from the REST API, we need to create a helper pipeline that will…

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…