SQL Server with Mr. Denny:

Service Broker


June 16, 2008  11:00 AM

Back To Basics: Service Broker Services



Posted by: Denny Cherry
Back To Basics, Route, Service, Service Broker, SQL

Services are used to bind contracts to queues.  They are also used to database to database, or server to server routing of messages via routes (we'll talk about them later).  Unlike most other objects within SQL Server, the name of the service is case sensitive, no matter what collation you have...

June 5, 2008  11:00 AM

Back To Basics: Service Broker Queues



Posted by: Denny Cherry
Back To Basics, Queue, Service Broker, SQL

The service broker queue is where the messages are stored after they are delivered, but before they are processed.  They are kind of like tables as you insert data into them (sending the message) and you view the data in them (receiving the message).  While tables can have triggers, queues can...


June 2, 2008  11:00 AM

Back To Basics: Service Broker Contracts



Posted by: Denny Cherry
Back To Basics, Contract, Queue, Service Broker, SQL

Every Service Broker conversation requires a contract.  The contract defines which message type or types will be used, as well as who (sender or receiver) can use which message types.  The contract is specified when the conversation is created. The syntax for creating the contract is pretty...


May 26, 2008  11:00 AM

A very strange Service Broker and TempDB problem



Posted by: Denny Cherry
Service Broker, SQL, SQL Server 2005, TempDB

So, a little while ago I was having a major problem at work that I'd like to share in the hopes that someone else finds this information useful. (When I was having this problem, Google wasn't able to find anything for me.) The symptoms that we were having in a nut shell was that the tempdb was...


May 15, 2008  11:00 AM

Back To Basics: Service Broker Message Types



Posted by: Denny Cherry
Back To Basics, Message Type, Service Broker, SQL

The message type is the first of the service broker specific objects.  The message type defines the name of the message, and performs any validation that the service broker needs to do on the contents of the message prior to sending the message.  If the message is being sent to another database...


May 8, 2008  11:00 AM

Back To Basics: The SQL Server Service Broker



Posted by: Denny Cherry
Back To Basics, Service Broker, SQL

The SQL Server Service Broker is a fantastic new addition to SQL Server.  For those who have used Microsoft Message Queue (MSMQ) the service broker will be easy to understand as it's the same basic concept.  Messages are sent from one place to another, within a database, from database to...


May 8, 2008  4:04 AM

Quest Meet the Expert Video published



Posted by: Denny Cherry
Queue, Video

Quest Software has just published the first of a few videos which I recorded with them. You can download or view the video from here. I've...


April 17, 2008  10:00 PM

New Article: Configure SQL Server Service Broker for sending stored procedure data



Posted by: Denny Cherry
Article, Service Broker, SQL Server 2005, SQL Server 2008

I’ve just published a new tip on SearchSQLServer.com called Configure SQL...

Bookmark and Share     1 Comment     RSS Feed     Email a friend


April 14, 2008  10:00 AM

I’ll be speaking at the NJ SQL Server User Group



Posted by: Denny Cherry
In Person Events, Service Broker

The NJ SQL Server User Group has been kind enough to invite me to come speak to them about SQL Server Service Broker.  I'll be speaking up there on August, 19,...


March 21, 2008  6:11 AM

I had a great time speaking at the San Diego SQL User Group



Posted by: Denny Cherry
In Person Events, Query tuning, Service Broker

I'd like to thank the San Diego SQL Server User Group for having me come and speak to them tonight.  I had a great time presenting both my


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: