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…
I wrote a piece of SQL that had some new T-SQL syntax in it: IS DISTINCT FROM. This predicate checks…
I'm very excited to announce I've been selected as a speaker for dataMinds Connect 2024, Belgium's (and maybe/probably/most likely mainland…
When you develop data pipelines in Microsoft Fabric (the Azure Data Factory equivalent in Fabric, not to be confused with…
I have a metadata-driven ELT framework that heavily relies on dynamic SQL to generate SQL statements that load data from…