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

4 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

4 years ago

To get data out of the REST API of Exact Online, we first need to authenticate ourselves. With APIs, typically…

Azure Data Factory and the Exact Online REST API – Introduction

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 years ago

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