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…
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…