Service Broker - Recommended Reading?

Question

Service Broker - Recommended Reading?

Chad Crawford

SSChampion

Points: 11610
More actions
August 30, 2010 at 8:51 am

#227047

I'm getting started with a project that is going to use Service Broker, and this is my first dive into that area of SQL. It's the perfect place to get our feet wet - a non-critical, only running during business hours, can be down for short periods implementation, but I would like to show that we can use it elsewhere when it is the right option so I want to set it up right. What reading would you recommend beyond the BOL and MSDN entries? Is there a book or blog post that you found to be invaluable when configuring, monitoring or debugging SSB?
Thanks,
Chad

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736342 More actions · Answer 1

I haven't seen much lately, but there's a blog here: http://blogs.msdn.com/b/sql_service_broker/

You can ping them for stuff if you need it. There's a book from Amazon that I have, but it was written early, and not sure that it's a great book. Haven't done enough with it to know if it's good: http://www.amazon.com/Rational-Server-Service-Broker-Guides/dp/1932577270

There's another "Pro" book that I haven't read, but it's rated highly by a couple people. http://www.amazon.com/gp/product/B001W0ZD36/ref=pd_lpo_k2_dp_sr_1?pf_rd_p=486539851&pf_rd_s=lpo-top-stripe-1&pf_rd_t=201&pf_rd_i=1932577270&pf_rd_m=ATVPDKIKX0DER&pf_rd_r=1HDK0NAQW13BH06E35VR

LutzM SSC Guru Points: 107049 More actions · Answer 2

I refer to rusanu's web site[/url] once in a while.

It might help you as well, even though most of the stuff he wrote about is related to SS2K5.

I can also recommend the "Pro" series book Steve mentioned (at least based on the SS2K5 version, again).

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Chad Crawford SSChampion Points: 11610 More actions · Answer 3

Sweet, thanks Steve and Lutz. I think I'll pick up the Pro book and read though those blogs before I begin. I convinced them we would save money by purchasing a book and 2+ recommendations for the same one is good enough for me. We'll actually be implementing on 2K5, but I prefer the 2K8 book since it's only a matter of time until we migrate and I should be able to figure out the differences (hopefully). I'd rather have to figure out how to "downgrade" what I read than not realize I could upgrade later.

Thanks,

Chad