Skip to main content
Under the kover of business intelligence

Under the kover of business intelligence

  • Home
  • Copyright
  • About

New Stars of Data – SQL Bad Practices caught in the Wild

May 11, 2023May 12, 2023 Koen Verbeeck Leave a comment

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 […]

Read More

Change the Default Git Branch for a dbt Cloud Project

April 24, 2023April 24, 2023 Koen Verbeeck Leave a comment

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 […]

Read More

Get your Query History in Redshift

April 20, 2023April 21, 2023 Koen Verbeeck 1 Comment

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 […]

Read More

Star Schema Merchandising Available

April 6, 2023April 6, 2023 Koen Verbeeck Leave a comment

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 […]

Read More

Book Review – SQL Query Design Patterns and Best Practices

March 5, 2023March 5, 2023 Koen Verbeeck 1 Comment

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 […]

Read More

Reading AFAS REST API Data with Azure Logic Apps

February 26, 2023February 26, 2023 Koen Verbeeck Leave a comment

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 […]

Read More

Speaking at Data Saturday Rheinland – Migrating SSIS to ADF

February 24, 2023February 24, 2023 Koen Verbeeck Leave a comment

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 this post, the schedule isn’t online yet, but I assume it will be up shortly. The abstract for my session: Integration Services is the new Cobol. […]

Read More

Speaking at Techorama 2023

February 14, 2023February 14, 2023 Koen Verbeeck Leave a comment

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 a pleasure to be there. It’s organization is amazing and there are tons of interesting sessions. The first batch of sessions has just been announced, so […]

Read More

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

February 13, 2023February 20, 2023 Koen Verbeeck 4 Comments

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 shout “STAR SCHEMA ALL THE THINGS” anywhere I can, because a star schema is the most optimal way to design your model in Power BI. We […]

Read More

Why Managed Identities are Awesome

February 1, 2023February 1, 2023 Koen Verbeeck 4 Comments

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 Server users etc. and all of these are tied into the ETL process of a data warehouse. Some are used to connect to source data, others […]

Read More

Posts pagination

Newer posts 1 … 5 6 7 … 33 Older posts

Feed

RSS

Social

  • Twitter
  • LinkedIn

MVP

Microsoft Data Platform MVP

star schema all the things
Get your star schema merchandise

Author of the Year 2014/2020/2023

Support this blog and buy me a beer

Recent Posts

  • Execute Fabric Data Pipeline from Azure Data Factory
  • Azure Data Factory Pipeline Debugging Fails with BadRequest
  • Call a Fabric REST API from Azure Data Factory
  • Cool Stuff in Snowflake – Part 14: Asynchronous Execution of SQL Statements
  • How I passed the DP-700 Exam

Categories

  • Azure (25)
  • Azure Data Factory (25)
  • Azure Devops (4)
  • Book Review (26)
  • Business Intelligence (29)
  • Events (56)
  • Fabric (19)
  • Power BI (41)
  • Professional Development (9)
  • Snowflake (14)
  • SQL Server (112)
    • MDS (8)
    • SSAS (12)
    • SSIS (46)
    • SSRS (13)
    • TSQL (9)
  • Varia (37)
  • Twitter
  • LinkedIn
  • Home
  • Copyright
  • About
Under the kover of business intelligence All rights reserved. Theme by Colorlib Powered by WordPress