Skip to main content
Under the kover of business intelligence
  • Home
  • Copyright
  • About

Category: Azure

Secure Logic Apps with OAuth Authorization

September 17, 2025September 17, 2025 Koen Verbeeck Leave a comment

I’ve used Logic Apps a couple of times over the past years for simple workflows, like sending an email (still not supported in ADF, booooo), reading a SharePoint List or copying some files from A to B (cheaper than the Copy Data Activity in ADF). When you create a Logic App with an HTTP trigger […]

Read More

Bad Request Error when Running PowerShell Command in Azure Devops

July 9, 2025July 9, 2025 Koen Verbeeck Leave a comment

I needed to run a PowerShell cmdlet in an Azure Devops pipeline. The cmdlet in question was New-AzRoleAssignment, but the cmdlet itself isn’t important. What is important is that I needed to pass the object ID of a service principal to the command. Even though I was pretty sure the syntax and everything was correct, […]

Read More

Free Webinar – Build a data warehouse on Azure Data Platform for $150

June 11, 2025June 11, 2025 Koen Verbeeck Leave a comment

I’m presenting a free webinar at MSSQLTips.com at Thursday, July 10, 2025 at 6PM UTC (8PM CET or 2PM EDT). The abstract: As you might learn from the abstract, the session is aimed at people working with “small data”. Just a couple of gigabytes, biggest table is below 100 million rows. But you would be […]

Read More

Check your regions people

April 17, 2024April 17, 2024 Koen Verbeeck Leave a comment

Today I was having a nice discussion with some colleagues about Fabric and pricing/licensing came up. I mentioned an F2 is only around €250 a month, but a colleague said “no no, it’s over €300”. A bit confused, I pulled up the sizing table of my Fabric capacity in Azure, which looks like this: Similarly, […]

Read More

Azure Function App doesn’t retrieve most recent secret value from Azure Key Vault

February 2, 2024February 3, 2024 Koen Verbeeck Leave a comment

Quite a long title for quite an annoying issue. Let me explain the set-up first: I have pipelines running in Azure Data Factory and I want to send e-mails with customized messages when something goes wrong (this means the standard alerting of ADF doesn’t cut it). ADF doesn’t have a built-in activity for sending e-mails […]

Read More

dataMinds Connect 2023 – Raiders of the Lost ADX slides

October 12, 2023October 12, 2023 Koen Verbeeck Leave a comment

You can find the slides for the session that I gave with Johan at dataMinds Connect 2023 at GitHub. As usual, the event was amazing. A lot of great sessions, wonderful speakers and a lot to learned. Our ADX session went well and there were about 20-30 people in the audience. I’m happy with the […]

Read More

Analyzing Azure Cosmos DB Data with Azure Synapse Link – YouTube Live Stream

June 5, 2023June 5, 2023 Koen Verbeeck Leave a comment

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

Read More

Techorama Slides – Analyze Cosmos DB Data with Synapse Link

May 15, 2023May 15, 2023 Koen Verbeeck Leave a comment

I’ve uploaded the slides for my session at Techorama to Github.

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

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

1 2 3 Older posts

Feed

RSS

Social

  • Twitter
  • LinkedIn

Former MVP

Former Microsoft Data Platform MVP (2017-2025)

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

  • dataMinds Connect 2025 – Slides & Scripts
  • Cloud Data Driven User Group 2025 – Slides & Scripts
  • Retro Data 2025 – Slidedeck
  • Secure Logic Apps with OAuth Authorization
  • Free Online Sessions – Building the €100 DWH and Indexing for Dummies

Categories

  • Azure (28)
  • Azure Data Factory (27)
  • Azure Devops (5)
  • Book Review (26)
  • Business Intelligence (29)
  • Events (61)
  • Fabric (19)
  • Power BI (42)
  • Professional Development (9)
  • Snowflake (14)
  • SQL Server (114)
    • 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