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…
