Mark Pryce-Maher

Microsoft Fabric’s Warehouse and SQL analytics endpoint have evolved rapidly—with capabilities that make SQL-first analytics faster, safer, and simpler to operate. In this session, you’ll see how the SQL analytics endpoint provides a read-only, T-SQL experience over Delta tables with support for views, functions, and granular SQL security, while using the same engine that powers the Warehouse for low-latency queries. We’ll unpack automatic metadata discovery that keeps table stats and schema in sync without manual steps, and we’ll cover endpoint behavior, limitations, and reprovisioning options you can use to self-mitigate provisioning hiccups. On the Warehouse side, we’ll dive into Warehouse Snapshots—point-in-time, read-only views retained for up to 30 days that decouple reporting from ongoing ETL and enable safe roll-forward of the snapshot timestamp for consistent BI and compliance scenarios. You’ll leave with concrete patterns to combine Warehouse and the SQL analytics endpoint for resilient, performant lake-centric analytics in Fabric.

Do you have to be experts like Bob Ward and Anna Hoffman to use SQL? What about Fabric?  Why not both? Come join our experts from Microsoft in this entertaining and educational session where the worlds of SQL and Fabric come to together in way you never knew existed