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…
In the introduction of this blog post series, I explained the use case: extracting data from the Planview Portfolios RESET…
In the introduction, I explained the setup of the use case and why we need to use the OData feed:…
I have a client using Planview Portfolios to manage their PMO. As part of the data warehouse, we want to…