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 […]
Category: Azure
Bad Request Error when Running PowerShell Command in Azure Devops
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, […]
Free Webinar – Build a data warehouse on Azure Data Platform for $150
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 […]
Check your regions people
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, […]
Azure Function App doesn’t retrieve most recent secret value from Azure Key Vault
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 […]
dataMinds Connect 2023 – Raiders of the Lost ADX slides
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 […]
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, […]
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 […]
Why Managed Identities are Awesome
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 […]