SQLDay 2013 | DBA/DEV Track | Denny Cherry – Getting SQL Service Broker Up and Running

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. Learn about the SQL Service Broker database objects. Learn how to send and receive messages within a database and how to send and receive messages between servers.