Koen Verbeeck

Book Review – SQL Query Design Patterns and Best Practices

• by Koen Verbeeck

• Koen Verbeeck

Disclaimer: The publisher – Packt – sent me a free copy of the book for the intended purpose of a review. At the time of writing, the book is...

2023-03-05

1 reads

Reading AFAS REST API Data with Azure Logic Apps

• by Koen Verbeeck

• Koen Verbeeck

Recently I had to read some REST API data using an Azure Logic App. The data itself comes from AFAS, a Dutch SaaS ERP company. In general, the process...

2023-02-26

Speaking at Data Saturday Rheinland – Migrating SSIS to ADF

• by Koen Verbeeck

• Koen Verbeeck

I’m pleased to announce that I’ll be talking about how you can migrate your SSIS skills to Azure Data Factory at Data Saturday Rheinland. At the time of writing...

2023-02-24

1 reads

Speaking at Techorama 2023

• by Koen Verbeeck

• Koen Verbeeck

I’m excited to announce I’ve been selected again as a speaker for Techorama 2023. Techorama is one of the biggest Microsoft-focused events in the European mainland, and it’s always...

2023-02-14

Build Once – Add Metadata

• by Koen Verbeeck

• Koen Verbeeck

When working in business intelligence, data engineering or data in general, there are some “mantras” that are being adopted by the larger community as “best practices”. For example, I...

2023-02-14 (first published: 2023-02-13)

8 reads

Why Managed Identities are Awesome

• by Koen Verbeeck

• Koen Verbeeck

For the first workdays of this new year, I had the pleasurable task of resetting a bunch of passwords. The passwords belong to Azure AD users, service principals, SQL...

2023-02-01

CONCAT_WS Function Truncates Text

• by Koen Verbeeck

• Koen Verbeeck

I was writing some dynamic SQL that generates some SQL statements to load my facts and dimensions into a data warehouse. Some of those SQL statements can become very...

2023-02-01 (first published: 2023-01-31)

1 reads

Allow a user to only trigger pipelines in Azure Data Factory

• by Koen Verbeeck

• Koen Verbeeck

Typically you have a bunch of pipelines that are started by one or more triggers. Sometimes, a pipeline needs to be manually triggered. For example, when the finance department...

2023-01-25

Logic App errors out when using variables in a SharePoint Action

• by Koen Verbeeck

• Koen Verbeeck

I have a Logic App that reads out a SharePoint library and stores all the documents found into Azure Blob Storage (ADF only supports Lists). I was trying to...

2023-01-18

1 reads

Speaking at Data Community Austria Day 2023

• by Koen Verbeeck

• Koen Verbeeck

Let me start by wishing everyone the best for the year 2023! We’re going to kick off the new year with a virtual conference: the Data Community Austria Day...

2023-01-09