SQL Server Service Broker

by Ming X
The article I read is called an Introduction to SQL Server Service Broker, by Deanna Dicken. As she mentions, “Service Broker is a technology built into SQL Server and utilized by the engine for its internal asynchronous processing.” SSB is a new architecture introduced with SQL Server 2005 and enhanced further in SQL Server 2008 and later versions that allows you to write asynchronous, decoupled, distributed, persistent, reliable, scalable and secure queuing/message based applications within the database itself.
There are some benefits of SSB including:
Reliability
Guaranteed Delivery
Replay-ability
Separation of concerns
Scalability
Priority processing
Guaranteed ordering
A SSB integration consists of Conversations or Conversation Groups, Message Types, Contracts, Services and Queues. Users can use T-SQL language to implement these pieces.

Service Broker is a technology that provides messaging and queuing functions between instances. The basic functions of sending and receiving messages forms a part of a “conversation.” Each conversation is considered to be a complete channel of communication. Each Service Broker conversation is considered to be a dialog where two participants are involved. Service broker find applications when single or multiple SQL server instances are used. This functionality helps in sending messages to remote databases on different servers and processing of the messages within a single database. In order to send messages between the instances, the Service Broker uses TCP/IP.

I think SSB is a very useful tool to database applications. Database integration enhances application performance and simplifies administration. Message ordering and coordination for simplifies application development. Loose application coupling provides workload flexibility. Automatic activation allows applications to scale with the message volume. With SSB, users will be able to add reliable, scalable, asynchronous functionality to the database applications.

Reference

Dicken, Deanna: An Introduction to SQL Server Service Broker, Database Journal, July 9, 2012. http://www.databasejournal.com/features/mssql/an-introduction-to-sql-server-service-broker.html

3 thoughts on “SQL Server Service Broker

  • November 11, 2012 at 2:12 pm
    Permalink

    Thanks for the article. This article once again prove that SQL is still use widely for most business and most developer are developing new software that are SQL integrated like the article I read for this week. There is a software under development that try to overcome the “big data” using SQL.

  • November 11, 2012 at 3:35 pm
    Permalink

    Great article pick. It is great to see just the many functions in SQL that I myself am not yet familiar with. If these inovations or enhancements continue in SQL, then perhaps it will not simply be NoSQL and Big Data taking over the industry.

  • November 11, 2012 at 4:06 pm
    Permalink

    Nice article, It is completely new to me. It is definitely another advantage to SQL when comparing it with NoSQL. During my search on SQL articles, I have found a lot of articles are about NoSQL overtaking SQL since SQL has been out for too long. However, it has never make any sense to me that NoSQL is better just because SQL is old. I did research on the both SQL and NoSQL and I found that both NoSQL and SQL have their advantages and disadvantages.

Comments are closed.