Posted on

Dear SQL DBA: Why Don’t You Teach Service Broker?

To Broker, or Not to Broker? That is the Question

I’ve gotten a few questions about whether I recommend learning Service Broker, and recently I was asked if I’m planning to make any courses on Service Broker. In this 23 minute episode, I talk about why I personally haven’t become an expert with Broker, the factors that I believe play into Service Broker adoption, and other resources online for learning Service Broker in SQL Server.

Join in the fun

  1. Attend the Dear SQL DBA podcast — live! Register here to get an invitation.
  2. Got a question for Dear SQL DBA? Ask away.
  3. Subscribe:  If you’d rather listen on the go, subscribe on iTuneslisten on Google Play, or plug this URL into your favorite podcasting app: http://dearsqldba.libsyn.com/rss#

5 thoughts on “Dear SQL DBA: Why Don’t You Teach Service Broker?

  1. TL;DR – While I like service broker, I don’t think you’re a bad person for stating the opinion you have in the video. 🙂

    Thanks for the great video Kendra! In re: service broker, I think that it’s fairly niche. And it can have a reputation for being a little finicky. That said, I think it’s pretty good at what it does and if you have need for some async processing in SQL Server you could do worse. I personally use in production and like it. That said, everyone has the same (finite) amount of time to learn things and unless you’re using (or thinking about using) it, that time could be better spent elsewhere.

    1. Hey, Ben– as someone who does use it in production, do you have any thoughts about resources other than the ones I mentioned?
      Edit: to recap, the ones I mentioned are…
      Jonathan Kheayias’ Pluralsight course, blogs and online videos
      Klaus Ascenbrenner’s book (2008)
      Blog posts and Stack Overflow answers by Remus Rusanu

      1. I have Klaus’ book and would say that it’s a good 10000 foot view of all of the pieces (i.e. creating the queues, services, etc) necessary to be able to send messages. An as far as Remus’ blog goes, I know that I’ve read several of those in the course of implementing/troubleshooting. Highly recommended!

        One gold nugget that’s mentioned in one of Remus’ post is a whitepaper by MS for performance and scalability. You can find that whitepaper here https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008/dd576261(v=sql.100).

        1. Awesome! Thanks much

  2. We used it successfully at a large Santa Clara based chipmaker to support internal data warehouse. It was used along with resource governor to help manage warehouse usage.

    Resource governor would send a message to a Service Broker queue if the governor detected a certain usage condition, and the queue’s “activation” procedure would parse the message, and call other SPs that would respond appropriately to the usage condition that described in the message.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.