Wednesday, May 5, 2010

SQL Server Service Broker - An Introduction

SQL Server Service Broker (SSBS or SSB) is a new architecture (introduced with SQL Server 2005 and enhanced further in SQL Server 2008) which allows you to write asynchronous, decoupled, distributed, persistent, reliable, scalable and secure queuing/message based applications within the database itself. This integration of queuing and message based infrastructure into the database provides several advantages from other message/queuing based applications out of the database. In this introductory article on SSBS, I discuss SSBS on a very basic level, how it differs from MSMQ, SSBS architecture and its different components. For more details, click here.