Get creative with Service Broker

This page contains the description for my conference session “Get creative with Service Broker”, and links to the slide deck and demo code used in this presentation.


Target audience Database developers and DBAs with some experience in SQL Server
Short description A short “how-to” guide on Service Broker, followed by three real-world scenarios where Service Broker was used
Duration The ideal length for this session is 60 – 75 minutes.
Full abstract Service Broker is a very interesting feature, that was introduced in SQL Server 2005, and then never found much enthusiasm. There are two reasons for this: the complexity of the feature, and the shortage of real world scenarios where it can be used.

But I have found that, when you dare to think out of the box, Service Broker can actually be used creatively to solve some actual business problems, in an elegant way.


In this session, I first briefly describe, in simplified terms, what Service Broker is and how it works, and I present a skeleton for the code you’ll need to make all the elements work together.
After that, I describe three real-world scenarios from my prior practice where I used Service Broker, maybe not exactly as Microsoft intended it, to solve a problem.


Click here to download a ZIP file containing the slide deck and demo code used in this presentation.

(Note: my presentations tend to evolve over time, so the version you find here may not be an exact match for the version you witnessed)

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.