From SQL to Fabric: Building Scalable Real-Time Data Platforms with T-SQL, Eventhouse, and Data Acti

Regular 50 minute session for SQLBits 2026

TL; DR

SQL skills are more relevant than ever—but modern data platforms demand real-time processing, cloud scale, and event-driven intelligence. This session shows how SQL professionals can evolve existing T-SQL knowledge into scalable, real-time architectures using Microsoft Fabric. You’ll see how familiar SQL concepts extend naturally into Eventhouse, streaming analytics, and automated actions, enabling low-latency insights without abandoning proven data skills.

Session Details

Many organizations still rely on batch-oriented SQL systems, even as their businesses demand real-time insight and instant reaction. In this session, we bridge the gap between traditional SQL and modern streaming data platforms by building a real-time, end-to-end architecture on Microsoft Fabric—using skills SQL professionals already have.

Starting from familiar T-SQL patterns, we’ll ingest live event data into Fabric using Eventstreams and Eventhouse, apply real-time transformations and aggregations, and expose results through semantic models and analytics endpoints. You’ll see how Eventhouse extends SQL-style querying to high-throughput streaming data, and how Data Activator turns query results into automated, event-driven actions—alerts, workflows, and operational responses.

Through live demos and reference architecture walkthroughs, we’ll cover performance patterns, scaling strategies, and common pitfalls when moving from batch SQL workloads to streaming-first designs. The session closes with guidance on governance, security, and cost control, helping you modernize safely and incrementally. If you’re a SQL professional looking to stay relevant in a real-time, cloud-first world, this talk shows how to move forward—without starting from zero.

3 things you'll get out of this session

1. Extend SQL skills into real-time architectures
Learn how T-SQL concepts translate into Eventhouse and Microsoft Fabric to query, aggregate, and analyze streaming data at scale.
2. Build event-driven intelligence with Fabric
Understand how to combine Eventstreams, Eventhouse, and Data Activator to deliver low-latency insights and trigger automated actions from data.
3. Design scalable and production-ready platforms
Explore proven patterns for performance, security, governance, and cost optimization when migrating from batch SQL systems to real-time data platforms.