SQL Server 2025 introduces Change Event Streaming—a game-changing new feature that brings a true push-based change tracking model to the platform for the first time. Unlike traditional pull-based solutions like Change Data Capture (for data warehousing) or Change Tracking (for client sync), this feature streams changes directly from your database to Azure Event Hubs in real time. It’s reliable, partitioned, and durable, giving developers a cloud-native pipeline for event-driven architectures and real-time analytics without the need for polling or ETL overhead. Best of all? Change Event Streaming is supported across all SQL Server SKUs, including SQL Server 2025 for Windows and Linux, as well as Azure SQL Database and Managed Instance.
Using a new set of system stored procedures, you can easily configure event streams at the database level to publish inserts, updates, and deletes with minimal latency. In this session, you'll learn how to enable, configure, and consume change events from SQL Server, and how to integrate them into your own applications and microservices. Whether you're building reactive APIs, data lakes, streaming dashboards, or any other conceivable downstream consumer, this is the real-time change data model you've been waiting for!
You will learn:
- Understand how Change Event Streaming enables real-time, push-based change tracking in all SQL Server SKUs
- Learn how to configure and manage event streams using the new system stored procedures, including mapping change data to Event Hub partitions
- Explore practical integration patterns for consuming change events in modern applications using Azure Event Hubs or Kafka-based pipelines