I recently read the book Agile Data Warehouse Design - Collaborative Dimensional Modeling, from Whiteboard to Star Schema (quite the…
You can find the slides for the session Building the €100 data warehouse with the Azure Data Platform in this…
I was asked to do a review of the book Microsoft Power BI Performance Best Practices 2nd edition (Amazon link),…
This is a quick blog post, mainly so I have the code available if I need it somewhere in the…
Praise whatever deity you believe in, because it's finally here, a tenant switcher for Microsoft Fabric (which includes Power BI).…
This book was making its rounds on social media, and the concept seems interesting enough to make me want to…
I'm hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM UTC. The topic is about window…
The slides and scripts for my session "Tackling the Gaps & Islands Problem with T-SQL Window Functions" at dataMinds Connect…
Sometimes your Microsoft Entra ID account (formerly known as Azure Active Directory) is added as a guest user in another…
In Azure Data Factory (ADF, but also Synapse Pipelines and Fabric Pipelines), you have a typical scenario where you retrieve…