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…
This book was recommended by some of my colleagues, so I decided to give it a try. After finishing the…
In the introduction of this blog post series, I explained the use case: extracting data from the Planview Portfolios REST…