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.
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)