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 Comments. Leave new

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

    Reply
    • 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

      Reply
  • 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.

    Reply

Leave a Reply to ken ambrose Cancel reply

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

Menu
%d bloggers like this: