An Introduction to SQL Server Service Broker
Contents Introduction Queues Dialogs Conversation Groups Activation Why Use Asynchronous, Queued Messaging? Why Use Transactional Messaging? How Service Broker Solves the Hard Problems in Messaging Message Ordering Coordination Multithreading Receiver Management Why Build Messaging into the Database? Conversation Group Locking Remote Transactional Receive Handling Common Administration Direct Sends to Receive Queue Common Language Support Single-Connection Execution Capability Enhanced Security Transmission Queue Visibility Across Databases Conclusion Introduction With Service Broker, a feature in Microsoft SQL Server 2005, internal or external processes can send and receive guaranteed, asynchronous messages by using extensions to Transact-SQL Data Manipulation Language (DML). Messages can be sent […]
Read more