Get your Query History in Redshift

2 years ago

Because my Windows machine apparently decides to install updates over night (and thus reboot my machine), it has happened that…

Star Schema Merchandising Available

2 years ago

Those of you who follow me on social media (twitter | LinkedIn | mastadon) or who read my blog here,…

Book Review – SQL Query Design Patterns and Best Practices

2 years ago

Disclaimer: The publisher - Packt - sent me a free copy of the book for the intended purpose of a…

Reading AFAS REST API Data with Azure Logic Apps

2 years ago

Recently I had to read some REST API data using an Azure Logic App. The data itself comes from AFAS,…

Speaking at Data Saturday Rheinland – Migrating SSIS to ADF

2 years ago

I'm pleased to announce that I'll be talking about how you can migrate your SSIS skills to Azure Data Factory…

Speaking at Techorama 2023

2 years ago

I'm excited to announce I've been selected again as a speaker for Techorama 2023. Techorama is one of the biggest…

Build Once – Add Metadata (the importance of metadata-driven frameworks)

2 years ago

When working in business intelligence, data engineering or data in general, there are some "mantras" that are being adopted by…

Why Managed Identities are Awesome

2 years ago

For the first workdays of this new year, I had the pleasurable task of resetting a bunch of passwords. The…

CONCAT_WS Function Truncates Text

2 years ago

I was writing some dynamic SQL that generates some SQL statements to load my facts and dimensions into a data…

Allow a user to only trigger pipelines in Azure Data Factory

2 years ago

Typically you have a bunch of pipelines that are started by one or more triggers. Sometimes, a pipeline needs to…