AI MKT MA Mark Pryce-Maher Build Type 2 Slowly Changing Dimensions in Fabric — Without CDC One of the most common patterns in data warehousing is the Type 2 Slowly Changing Dimension (SCD). It solves a fundamental requirement: how…
AI MKT SPT MA Mark Pryce-Maher Finding Data Changes Over Time in Microsoft Fabric Using FOR TIMESTAMP AS OF Time travel has been a feature of the Fabric SQL Warehouse for a while now and its only just been released for the SQL analytics endpoint.
LIF MA Mark Pryce-Maher Read Optimized Custom SQL Pools As a nerd, I love new and shiny features, so what is newer and shiner that Custom SQL Pools — the TL/DR — read the documentation! Also…
TCH AI MKT MA Mark Pryce-Maher Fabric Data Warehouse readable secondary This is for anyone hitting concurrency limits in Fabric Warehouse, or wondering how far it can actually scale.