Introduction to Service Broker Programming

Queuing and asynchronous messaging are needed for many database applications today. Service Broker provides a new, queue-based durable messaging framework to address these needs. By using the Transact-SQL API provided by Service Broker, you can easily develop services to handle application requirements for queuing or asynchronous communications.

Some of the benefits of programming with Service Broker are as follows:

  • Flexible development: The programs that are used in a single distributed application can be written in multiple languages. Each program provides the functionality of each distributed application component.
  • Improved security: You can express security requirements through certificates. Therefore, application components do not have to share the same security context. Service Broker uses SQL Server security features to help you secure your applications.
  • Transactional processing: Message processing occurs within SQL Server transactions to assure data integrity. Service Broker supports remote transactional messaging over a standard connection to the database.
  • Guaranteed ordering: Service Broker provides strong guarantees regarding the delivery and processing of a related set of messages exactly once and in order. Therefore, no additional coding is required to provide this functionality.
  • Reliable delivery: All of the data needed for a conversation--a set of related communications between two or more services--is persisted in SQL Server. Service Broker supports clustering and database mirroring. A conversation might be maintained through system restarts, server failover, network outages, and so on without failing or losing data.
  • Improved scalability: Service Broker routing delivers messages based on the name of the service, instead of on the network address of the computer where the service runs. This lets you install an application on multiple computers without changing application code.
  • Ability to use existing knowledge: Service Broker uses Transact-SQL to create objects. Applications that use Service Broker are most often implemented in Transact-SQL or Microsoft .NET Framework-compatible languages. You do not have to learn a new language to create Service Broker applications.

In This Section

Topic Description

Service Broker Programming Basics

Desribes the elements in a Service Broker application and reviews the expected workflow.

Service Broker Programming Concepts

Describes the fundamental concepts behind Service Broker programming.

Developer Responsibilities for Service Broker

Reviews the Service Broker components that the application developer must provide.

Planning for Service Broker Development

Describes how to plan for a Service Broker application and provides a list of items to consider.

See Also


Creating Service Broker Objects
Service Broker Programming Samples

Other Resources

Creating Service Broker Applications
Introducing Service Broker
Service Broker Tutorials

Help and Information

Getting SQL Server 2005 Assistance