This session will explain the benefits of asynchronous processing in Service Broker compared to other options like SQL Agent jobs or SSIS packages, and how to implement the basic components required.
You have tuned your SQL server to it's limits, you have maxed the RAM on your server, and still your data warehouse is too slow. Is a Parallel Data Warehouse the next step?
Service Broker was introduced in SQL Server 2005 to provide asyncronous messaging in your database applications. In this session we'll walk you through the basics of Service Broker and show how you can use it to build highly scalable applications.
Service Broker: Message in a bottle
Service Broker provides several new key features for building SOA applications directly with SQL Server 2005.