Robbie Staples - Dynamic SQL 101

Managing transactional workloads while enabling analytics in near real-time often requires complex architectures and multiple tools. SQL Database in Microsoft Fabric, currently in preview, aims to simplify this by combining OLTP capabilities with built-in analytics integration.

This session introduces SQL Database in Fabric—a developer-friendly, cloud-native solution built on Azure SQL that automatically replicates data into OneLake for near real-time analytics. You'll learn how it supports familiar tools like SQL Server Management Studio and the Fabric portal, offers intelligent performance features, and enables cross-database queries and semantic modeling for Power BI.

Attendees will leave with a clear understanding of how Fabric SQL can streamline data architecture, reduce operational overhead, and accelerate insights—all without sacrificing transactional performance.

Session Goals - Attendees will:

Have you ever wondered how to leverage Dynamic SQL for your needs? Have you needed Dynamic SQL and not gotten the online help you would? If so, then this session is for you. Topics discussed will range from the legacy way of writing Dynamic SQL to a new method that allows for optimizing performance when you need it.