Power BI Field Parameters and Slowly Changing Dimensions
Power BI field parameters are a new feature in Power BI Desktop, and it’s one of the best of the past months. In short, Power BI field parameters allow...
2022-06-17
137 reads
Koen Verbeeck
Speaking at dataMinds Connect 2022
I’m very excited to announce I’ll be giving a session at the 15th edition of dataMinds Connect (in the beginning it was called SQL Server Day(s)). It will be...
2022-06-17 (first published: 2022-06-16)
33 reads
Techorama 2022 – Session Materials
You can find my slidedeck for the session “Introduction to Azure Data Factory” on Github:https://github.com/KoenVerbeeck/SessionMaterials All demos given in the session are explained in the ADF tutorial at MSSQLTips.com.
The...
2022-05-25
29 reads
How you can save up to 80% on Azure Data Factory pricing
… with this one weird little trick 🙂 Sorry for the clickbait, but you can actually save a lot on ADF pricing if you design your pipelines carefully. And...
2022-06-01 (first published: 2022-05-11)
679 reads
Webinar – Data Warehouse Modernization
I’m delighted to announce I’m participating in a panel discussion about data warehouse modernization. The full title is “Data Warehouse Modernization – Crafting a Successful Migration Strategy Post Pandemic”....
2022-05-05
71 reads
How to Deploy an Azure Function with PowerShell using Azure Devops
In the blog post Azure Function with PowerShell and the Power BI REST API I explained how you could create an Azure Function using the PowerShell scripting language. This...
2022-05-16 (first published: 2022-04-27)
240 reads
Azure Function with PowerShell and the Power BI REST API
In this blog post I’m going to show you how you can create an Azure Function that will interact with the Power BI REST API. I choose PowerShell as...
2022-05-06 (first published: 2022-04-26)
608 reads
How to Deploy Azure Logic Apps with ARM and Azure Devops
It’s easy to duplicate an Azure Logic App in a resource group, but unfortunately you cannot duplicate a Logic App between environments (you might try to copy paste the...
2022-04-29 (first published: 2022-04-21)
321 reads
Logic Apps and Source Control (with PowerShell)
At a data warehouse project I’m using a couple of Logic Apps to do some lightweight data movements. For example: reading a SharePoint list and dumping the contents into...
2022-05-25 (first published: 2022-04-20)
341 reads
Error – Reference to external ‘master.dacpac’ could not be resolved when deploying dacpac in Azure Devops
I have a database project in Visual Studio. Inside the database, I use a couple of system views to fetch some metadata about tables. To make the project build...
2022-04-25 (first published: 2022-04-16)
534 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
How Can Database Performance Improve the Overall Website Experience?
I’ve been looking into ways to improve the connection between a website and its...
When And How to Automate?
Comments posted to this topic are about the item When And How to Automate?
Hyperscale Replicas II
Comments posted to this topic are about the item Hyperscale Replicas II
Question of the Day
Hyperscale Replicas II
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers