Geeks With Blogs
Blog Moved to http://podwysocki.codebetter.com/ Blog Moved to http://podwysocki.codebetter.com/
During the last MICSUG meeting, Geoff Snowman gave a great presentation on "When to Use What" with regards to which remoting and messaging technologies should be used in certain scenarios.  The SQL Server 2005 Service Broker (SSB) was mentioned a couple of times in regards to messaging systems and it got me a little intrigued to look at it.
 
So What Is SSB?
 
 
Microsoft SQL Server 2005 Service Broker helps developers build scalable, secure database applications. This new technology, a part of the Database Engine, provides a message-based communication platform that enables independent application components to perform as a functioning whole. Service Broker includes infrastructure for asynchronous programming that can be used for applications within a single database or a single instance as well as for distributed applications.
 
Service Broker reduces application development time by providing much of the infrastructure that is necessary to build a distributed application. Service Broker also makes it easy to scale your application up or down to accommodate the amount of traffic the application receives.
 
So, this got me to thinking, well, what examples are there?  On GotDotNet, they have a site set up for SQL Server Broker Community Samples which has many samples for a brief introduction into the power of the SSB.
 
For a detailed walkthrough, the latest Visual Studio Magazine has an article called "Program SQL Server 2005’s Service Broker" (Registration Required) in which it provides a pretty in depth analysis on what you can do as well as some code examples.  I hope to look at this more in the future!
 
Posted on Tuesday, June 20, 2006 3:41 PM Microsoft , SQL Server | Back to top


Comments on this post: Looking at SQL Server 2005 Service Broker (SSB)

No comments posted yet.
Your comment:
 (will show your gravatar)


Copyright © Matthew Podwysocki | Powered by: GeeksWithBlogs.net