Main Content

SQL Server Service Broker in the Real World

About the Talk

January 31, 2010 5:15 AM

University of California Fullerton

University of California Fullerton

Microsoft SQL Server 2005 and 2008 include a fantastic feature that few people understand or use. That feature is the Microsoft SQL Server Service Broker. The SQL Service Broker is one of the least used features within the database engine, and that lack of use is simply from last of knowledge about the feature.

In this session we’ll dig into how to configure the service broker for not only intra-database message queuing, but database to database queuing as well as server to server database queuing. We will also dig into a real life scenario where the SQL Server Service Broker was used to do ETL from an OLTP database to an OLAP database in near real time for near real time reporting.

By the end of this session you'll understand where SQL Service Broker is the right fit to be used, and you'll hopefully be ready to deploy it within your environment.

Ratings and Recommendations

Avg. Rating

Average based
on 2 ratings

comments powered by Disqus