SQLBits 2017

Get Near Realtime ETL with Service Broker

Using SQL Server Service Broker you can create near real-time data in your data warehouse for more timely analysis and reporting.

Most of the time you’ll see ETL being done with a tool such as SSIS, but what if you need near-realtime reporting? This session will demonstrate how to keep your data warehouse updated using Service Broker messages from your OLTP database.

Speaker

Allen is a Data Platform Consultant. Allen has spent over 40 years in IT and has been using SQL Server since 1992 and is certified MCITP in SQL Server and MCT. Allen has been a Data Platform MVP Award for twelve years.

Allen White's Sessions

Find and Fix those Troublesome Queries

Get Near Realtime ETL with Service Broker

Maintain SQL Server System and Performance with PowerShell

Gather SQL Server Performance Data with PowerShell

Let Service Broker Help You Scale Your Application