Practical Microsoft Fabric expertise for people engineering data, building analytics and creating AI

Fabric expertise for real platforms, not demos

Fabric now spans lakehouses, warehouses, real-time intelligence, SQL databases, Power BI and a growing family of data agents. The question is no longer what Fabric can do, but what is ready for production and how to run it well. SQLBits is where practitioners compare notes. 

Practical Fabric knowledge you can put to work

Capacity sizing and cost control, Direct Lake, CI/CD, governance, migrating from Synapse and Data Factory, and building agents on your own data. Sessions are demo-led and honest about what is GA and what is still preview. 

Meet the top team at Microsoft

Microsoft is a headline sponsor of SQLBits, bringing members of the Fabric product, engineering and Customer Advisory teams. Ask them how to make Fabric work in your organisation. 

The challenges we’ll help you solve

If any of these sound familiar, you will find people at SQLBits who have already been there. 

  • One noisy workspace can throttle everyone, and capacity bursting and smoothing are hard to forecast. 
  • Surge protection stops new background jobs but not running ones, so critical workloads still need their own capacity. 
  • Power BI Premium P SKUs are being retired, and capacity is throttled from day 31 after expiry and rejected from day 91. 
  • Moving off Synapse and Data Factory: which pools, pipelines and Spark jobs move cleanly, and when? 
  • Direct Lake on SQL can silently fall back to DirectQuery, while on OneLake it fails past guardrails instead. 
  • Row-level security applies differently in each Direct Lake mode, so access rules are easy to get wrong. 
  • CI/CD is uneven across item types, and warehouse source control is still in preview. 
  • Lakehouse, warehouse or SQL database? Teams struggle to choose and end up duplicating data. 
  • Workspace sprawl and unclear ownership make cost, security and lineage hard to govern. 
  • What may a data agent see, and how do Purview and OneLake security apply to it? 
  • So many AI features are still preview that roadmap bets feel risky. 
  • Engineers must now learn Spark, T-SQL, KQL, DAX, Git and agent design, and the MCP servers are another surface to learn. 

Using Fabric to strengthen your company’s AI capability

One governed data estate

OneLake gives every workload one copy of data under one security model, and agents inherit it. OneLake security (row and column level) is moving towards GA. 

Agents wherever people work

Data agents plug into Copilot Studio, Azure AI Foundry, Teams and Microsoft 365 Copilot, and can be called by external orchestrators. 

A shared business meaning layer

Fabric IQ ontology (preview) defines entities, relationships and rules once, so agents and apps use the same vocabulary. It can be generated from a Power BI semantic model. 

Multi-hop reasoning

Graph in Fabric adds a native graph engine for relationship-heavy questions. Check its current status before quoting. 

RAG and semantic search in the database

DiskANN vector indexes on Fabric SQL and Azure SQL (GA) put semantic search next to operational data. 

Bring operational data in without pipelines

Mirroring lands source data in OneLake as Delta. BigQuery mirroring is GA, and Snowflake security-role mirroring is in preview. 

Real-time context for agents

Eventstreams, Eventhouse and Activator feed live signals to operations agents. 

AI in the query

AI functions (summarise, classify, transform) run in notebooks, with Warehouse AI functions in preview. 

Where agentic AI can help

Eight places agents are already earning their keep in Microsoft Fabric, and where SQLBits sessions will show you how. 

Ask questions of governed data

Fabric data agents (GA) answer natural-language questions over lakehouses, warehouses, semantic models, KQL databases, mirrored databases and ontologies, read-only and under your security model. 

Write and fix code

Copilot generates and fixes SQL, notebook code and Dataflow and pipeline logic. It is generally available in Data Factory, SQL database, Power BI and Real-Time Intelligence, and in preview in notebooks and the Data Warehouse. 

Plan and run engineering work

The Data Engineering Agent (preview, announced at FabCon Europe, September 2026) plans and executes migrations, ETL and performance tuning inside guardrails you set. 

Act on streaming signals

The operations agent in Real-Time Intelligence monitors live data and triggers alerts or playbooks. Microsoft Learn lists it as GA. 

Watch workspaces and capacity

Observability and operations agents (preview) centralise telemetry, alerts and root-cause analysis, building on workspace monitoring. 

Document and discover data

Copilot writes semantic model descriptions (preview, April 2026), and the OneLake catalog search API, MCP and CLI tools (March 2026) help agents and people find the right data. 

Drive Fabric from your AI coding assistant

The local Fabric MCP server (GA, March 2026) and the remote server (preview) let GitHub Copilot, Claude and others scaffold items, query data and deploy. A Data Factory MCP server is also available. 

Build semantic models and reports

Copilot in Power BI (GA) writes DAX and measure descriptions. Agentic app creation in Power BI Desktop (preview, announced September 2026) builds apps from a description. 

Key Speakers

All of these speakers have appeared on the SQLBits stage – check our 2027 agenda when it’s announced for details of our 2027 Fabric speakers. 

Chris Webb, Fabric Customer Advisory Team, Microsoft

Author and blogger (crossjoin.co.uk) and a leading authority on Analysis Services, Power Query and Dataflows. 

 

Mark Pryce-Maher, Senior Program Manager, Microsoft Fabric

Works on Fabric mirroring and Data Warehouse migrations. 

Patrick LeBlanc, Principal Program Manager, Microsoft; Guy in a Cube

Author of five SQL Server books, former MVP and co-host of the Guy in a Cube channel. 

Anna Hoffman, Principal Group Product Manager, Microsoft

Works across the tools and experiences that power SQL Server, Azure SQL and SQL database in Microsoft Fabric. Host of Data Exposed, connecting the people building Microsoft’s data technologies with the people putting them to work. 

Check out some of our recent Fabric sessions

A Whirlwind Tour of the Fabric Capacity Metrics App
Fast tour of the Fabric Capacity Metrics App; learn to read key visualisations, spot performance issues, understand capacity behavior, and turn insights into quick, actionable optimizations to keep your Fabric environment running smoothly.
 
AI-Augmented Query Optimization: SQL Server 2025 Meets Fabric Self-Healing Data Platform
SQL Server 2025 introduces groundbreaking capabilities for performance optimization and observability, while Microsoft Fabric brings unified analytics and AI-driven insights. But how do we combine these innovations to build a truly resilient, self-healing data platform? In this session, we’ll explore AI-Augmented Query Optimization and Fabric Observability to tackle real-world challenges like unpredictable workloads, query regressions, and performance bottlenecks. You’ll learn: Who this is for: Data engineers, DBAs, and architects managing mission-critical SQL workloads in hybrid or cloud environments. What problem it solves: Eliminates manual troubleshooting by leveraging telemetry, ML notebooks, and AI-driven root-cause analysis. What you’ll take away: A practical blueprint for creating a Self-Healing SQL Fabric Dashboard that combines SQL telemetry with Fabric ML for automated anomaly detection and performance tuning. Expect live demos, POC architecture, and actionable strategies to future-proof your data platform with SQL Server 2025 and Microsoft Fabric.
 
An Apache Spark query's journey through the layers of Microsoft Fabric
Follow an Apache Spark SQL query from optimizer to execution across Spark and Microsoft Fabric. Catalyst, Tungsten, Fabric’s native C++ engine, and the Delta Lake/Parquet storage layers are covered, grounded in Spark source code, with practical tips to optimize for speed and cost.
 
Batteries included: SQL DevOps with SQL projects
The evolution of SQL projects continues with expanded IDE support and deeper integration in the Fabric platform. Using the latest in VS Code and SSMS, we’ll walk through keeping our database in source control, integrating changes made in another database, and evaluating deployment plans. Finally, we'll automate CI/CD processes with REST APIs for SQL database in Fabric and the SqlPackage CLI.
 
Beyond Chatbots: Leveraging AI for Unstructured Data Processing
A practical session on going beyond chatbots: using modern AI architectures and services to turn unstructured data (images, audio, text) into usable insights and integrate it with relational data, with actionable next steps to get started.
 
Build It Right: Real-World Microsoft Fabric Pipelines with Metadata & Medallion Architecture
Understand how metadata-driven design improves scalability and reusability in Microsoft Fabric pipelines. Learn how to implement the Medallion Architecture (Bronze, Silver, Gold) using Fabric-native services. Gain practical guidance for delivering trusted, analytics-ready data for downstream consumption.
 
Building Scalable Data Warehouses with Microsoft Fabric:
Learn to design and implement scalable data warehouses using Microsoft Fabric, covering best practices for data storage, management, retrieval, and data warehousing features to create efficient pipelines.
 
Building the Backbone of Agentic AI: A Unified Data Strategy with Microsoft Fabric
As we move from simple chatbots to autonomous Agentic Applications, the data requirements have shifted from static retrieval to dynamic interaction. Agents now need to read, write, and reason over data in real-time, blurring the lines between transactional (OLTP), real-time, and analytical (OLAP) workloads. In this session, we will demonstrate with a real application how Microsoft Fabric serves as the comprehensive "nervous system" for next-generation AI agents.
 
Choosing the Right Incremental Load Strategy in Fabric
Learn how to implement incremental loads in Microsoft Fabric. Explore strategies, tools, and demos to boost efficiency and pick the best approach for your data needs.
 

Take a tour of SQLBits 2025

Bring your Microsoft Fabric questions to the people who can answer them. Book your SQLBits 2027 pass today.