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…
I came across a bit of a weird error when I was trying to connect to a PostGreSQL database (hosted…