Mark Pryce-Maher·Aug 23Speeding up slow extracts from Fabric Data WarehouseI‘ve been working with a customer who extracts a lot of data from their Fabric Data Warehouse, every single day. Queries running for over…
Mark Pryce-Maher·Jul 9Materialized Views in Fabric Warehouse?No — they are not a thing. But maybe they can be… I am seeing a bit of demand for materialized views (yes, the Americanised spelling with…A response icon3A response icon3
Mark Pryce-Maher·Jun 10Build Type 2 Slowly Changing Dimensions in Fabric — Without CDCOne of the most common patterns in data warehousing is the Type 2 Slowly Changing Dimension (SCD). It solves a fundamental requirement: how…
Mark Pryce-Maher·Jun 8Finding Data Changes Over Time in Microsoft Fabric Using FOR TIMESTAMP AS OFTime 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.
Manisha Bhandari·Nov 17, 2025Microsoft Fabric: How to Grant Read Access to Specific Items in Fabric Lakehouse/Warehouse…When you’re building a data platform in Microsoft Fabric, a common challenge appears right after you’ve finished your pipelines and…
Oluwapelumi Arowosaye·Sep 25, 2025How-to: Connect SQL Server Management Studio (SSMS) to Microsoft Fabric Data WarehouseConnecting SQL Server Management Studio (SSMS) to your Microsoft Fabric Data Warehouse allows you to query and manage your warehouse data…
Mark Pryce-Maher·Mar 19, 2025Handling time zones in Fabric Warehouse: A Simple WorkaroundThe Problem: Fabric Warehouse loses time zone information
