I’m going to give a lightning talk at the online (free) Future Data Driven Summit. The subject is How I saved 80% on my Azure Data Factory Costs. The abstract: Azure Data Factory (ADF) is the tool in the Azure cloud for creating your data pipelines. It allows you to move and transform data from […]
Author: Koen Verbeeck
Koen Verbeeck is a Microsoft Business Intelligence consultant at AE, helping clients to get insight in their data. Koen has a comprehensive knowledge of the SQL Server BI stack, with a particular love for Integration Services. He's also a speaker at various conferences.
Book Review – Scalable Data Analytics with Azure Data Explorer
I recently finished the book Scalable Data Analytics with Azure Data Explorer (Modern ways to query, analyze, and perform real-time data analysis on large volumes of data), written by Jason Myerscough. I got the ebook for a mere $5 at a Packt sale, but luckily the price is no indication of the quality. In fact, […]
Analyzing Azure Cosmos DB Data with Azure Synapse Link – YouTube Live Stream
At Tuesday 6th of June 2023, I’m giving an online version of my session “Analyzing Azure Cosmos DB Data with Azure Synapse Link” (which I presented at Techorama). It’s a YouTube live stream for the Azure Cosmos DB global user group (and also Microsoft Reactor). The event starts at 1PM ET, which is 10AM PT, […]
New Stars of Data – SQL Bad Practices caught in the Wild
At the 12th of May 2023, a new edition of New Stars of Data takes place. If you’re not familiar with the concept, it’s a free virtual event focusing on the Microsoft Data Platform, organized by the fine folks of DataGrillen. The twist is that only new speakers are allowed; people who have never spoken […]
Change the Default Git Branch for a dbt Cloud Project
In dbt, you can link your project to a github account, which is obviously the right thing to do. By default, the project uses the main branch. But what if you have two dbt projects; one for dev and one for prd? And in the dev project, you want to change the default branch to […]
Get your Query History in Redshift
Because my Windows machine apparently decides to install updates over night (and thus reboot my machine), it has happened that I lost the query that I was writing for Redshift in the tool DBeaver. When you work with SQL Server Management Studio (SSMS), you typically don’t have this issue as a temporary copy is always […]
Star Schema Merchandising Available
Those of you who follow me on social media (twitter | LinkedIn | mastadon) or who read my blog here, might be familiar with my catchphrase “STAR SCHEMA ALL THE THINGS”. This slogan originated a couple of years ago when I had to convince some people that the star schema (aka the dimensional model) should […]
Book Review – SQL Query Design Patterns and Best Practices
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 yet to be released (the date is set at the 22nd of March 2023). The book SQL Query Design Patterns and Best Practices: A practical guide […]
Reading AFAS REST API Data with Azure Logic Apps
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 is mostly the same as reading the data with Azure Data Factory (check out this blog post to learn more): There’s a minor difference in how […]