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…
You can find the slidedeck for my Techorama session "Microsoft Fabric for Dummies" on github.
On Wednesday May 15th 2024 I will give a free webinar on MSSQLTips.com about Microsoft Fabric (at 6PM UTC).Abstract: Microsoft…