CONCAT_WS Function Truncates Text

3 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

3 years 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

3 years 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

3 years 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

3 years 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

3 years 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)

3 years 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

3 years ago

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

How to Install Integration Services 2022

3 years ago

The title of this blog post is a bit misleading, because what we actually want to do is to install…

Read data from Azure Synapse Serverless SQL Pools with Azure Data Factory

3 years ago

We have some data we can query using the serverless SQL pools in Azure Synapse Analytics. For this blog post,…