Mark Pryce-Maher·Sep 1Least privilege on a Fabric Data Warehouse/SQL Analytics EndpointThe whole series in one page
Mark Pryce-Maher·Aug 21Need a hand tuning your Fabric DW/SQL analytics endpoint?Which of your queries are bad, and how do you fix them? Ask your warehouse!
Mark Pryce-Maher·Aug 16MD Sync just got better - refresh only the tables you wantIf you use a Lakehouse, you rely on MD Sync (metadata sync) whether you realise it or not. It’s the thing that keeps your SQL analytics…
Mark Pryce-Maher·Aug 15Exposing views in a Fabric Data Warehouse without exposing the underlying tables/data (Part 2)In my last post I locked Isaiah out of pretty much everything in a Fabric Data Warehouse except one lonely view. No tables, no workspace…
Mark Pryce-Maher·Jul 30Are my Fabric tables healthy?There’s a handy little stored proc hiding in the SQL analytics endpoint that I don’t think many people have spotted yet…
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.
Mark Pryce-Maher·Jun 1SQL Analytics Endpoint VARCHAR(MAX) Support!With the release of the new MD Sync (details here), I was asked when varchar(max) support is coming. So I tried it and blow me down, it…
Mark Pryce-Maher·May 25New Metadata Sync FAQWe recently released a new update the SQL analytic endpoint, a couple of improvements to the Metadata sync (MD Sync). The offical docs are…
Mark Pryce-Maher·Mar 3Mirror (or Clone) your Fabric Lakehouse and SQL Analytics EndpointHave you ever been in this scenario? - Your Lakehouse is under load? - Your SQL Endpoint is underload? - You want to give a user access to…
