Skip to Main Content
Programming SQL Server 2005
book

Programming SQL Server 2005

by Bill Hamilton
February 2006
Intermediate to advanced content levelIntermediate to advanced
586 pages
17h 35m
English
O'Reilly Media, Inc.
Content preview from Programming SQL Server 2005

Chapter 17. Service Broker

SQL Server 2005 introduces Service Broker —a technology that is part of the Database Engine that helps you to build scalable, loosely coupled database applications. Service Broker provides a message-based communications platform that integrates independent application components. Service Broker makes it easier to build distributed applications by providing an asynchronous programming framework that includes queuing and reliable messaging. Service Broker can be used both for applications that use a single SQL Server instance and for applications that are distributed across multiple instances. The Service Broker Framework provides a T-SQL Data Manipulation Language (DML) interface for sending and receiving streams of asynchronous messages.

Architecture

Before you look at the message flow within a Service Broker solution, there are some key Service Broker terms with which you should be familiar.

A message is a unit of information exchanged between applications that use Service Broker. Internally, a message is stored in SQL Server as a varbinary(max) data type. Each message has a message type that defines the name and type of data that a message contains. Each message has a unique identity. Each message also has a unique sequence number within its conversation, which is used to enforce message ordering.

A conversation is a reliable, persistent communications channel made up of a series of messages. Messages are guaranteed to arrive in the order in which they ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Programming Microsoft® SQL Server® 2012

Programming Microsoft® SQL Server® 2012

Leonard Lobel and Andrew Brust

Publisher Resources

ISBN: 0596004796Supplemental ContentErrata Page