Where Does Service Broker Fit?
When I talk to people about Service Broker, I inevitably get questions about how it relates to Microsoft Message Queue (MSMQ), BizTalk, or Windows Communication Foundation (WCF). This section will discuss some general guidelines for deciding whether Service Broker or one of the other messaging technologies is appropriate for your needs.
What Service Broker Is
With Service Broker, SQL Server becomes a platform for building loosely coupled, asynchronous database applications. Service Broker implements queues as first-class database objects. The queue-handling code built into the database kernel handles the locking, ordering, and multithreading issues associated with managing queues.
To support scaling out asynchronous ...
Get Inside Microsoft® SQL Server™ 2005 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
