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

1 year 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

1 year 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

1 year 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

1 year ago

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

Logic App errors out when using variables in a SharePoint Action

1 year ago

I have a Logic App that reads out a SharePoint library and stores all the documents found into Azure Blob…

Speaking at Data Community Austria Day 2023

1 year ago

Let me start by wishing everyone the best for the year 2023! We're going to kick off the new year…

Book Review – Designing Data-Intensive Applications

1 year ago

The book Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems by Martin Kleppmann was recommended to me…

How to Specify the Format of the Request Body of an Azure Function

1 year ago

This is a bit of a niche blog post, because you don't actually need this to make your Azure Function…

Book Review – SQL Server Query Tuning and Optimization (2nd Edition)

1 year ago

The nice people from Packt Publishing sent me a digital copy of Benjamin Nevarez new book to review: SQL Server…

User Group Meeting – Migrate your SSIS skills to ADF & More

1 year ago

This Monday (the 5th of December 2022), my employer AE hosts a user group meeting for dataminds. There will be…