Webinar – Improve SQL Server Data Quality in SSIS

4 years ago

On the 5th of October 2021 I'll be giving a webinar about improving data quality of contact data (names, addresses,…

Cool Stuff in Snowflake – Part 13: Row-Pattern Recognition

4 years ago

I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight…

Speaking at dataMinds Connect 2021

4 years ago

In October I'll be speaking at the dataMinds Connect conference. This event is very dear to me, because it's a…

Upcoming Webinar – Intro to SSIS – Advanced Topics

4 years ago

On July the 22th at 9PM CET I will give the second part of the "Introduction to SSIS" webinar series…

Dynamic Datasets in Azure Data Factory

4 years ago

With "dynamic datasets" I mean the following: a dataset that doesn't have any schema or properties defined, but rather only…

dataMinds Saturday Recording Available

4 years ago

I did a session on data visualization best practices on the past dataMinds Saturday virtual conference. The recording has now…

Azure Data Factory and the Exact Online REST API – Getting around the 10 Minute Limit

4 years ago

This is the final blog post of this series on how to extract data from the Exact Online REST API…

Azure Data Factory and the Exact Online REST API – Dealing with Pagination

4 years ago

Some endpoints don't have that much data, both others certainly will, for example financial transactions. The REST API limits the…

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

4 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

4 years ago

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