Course 3180: Designing Asynchronous, Queued Operations Using SQL Server 2005 Service Broker

Introduction In this 2-hour premium course, you will learn how to incorporate Service Broker into your SQL Server™ 2005 Database solutions. Topics range from discussing Service Broker architecture to data flow and availability. In the lab, you will use these skills to build a SQL Server 2005 Service Broker solution.

Having this experience will enable you to design databases that utilize the integrated messaging system to perform asynchronous processing.

This course will also prepare you for exam 70-441 PRO: Designing Database Solutions by Using Microsoft SQL Server 2005 and 70-442 PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005. Objectives At the end of the course, students will be able to:

• Identify Components of a Service Broker Solution
• Design a Service Broker Solution Architecture
  • Implement a Service Broker Solution
  • Identify Services and Conversations
• Design Service Broker Data Flow
  • Identify Conversation Groups
  • Identify Data-Staging Locations
  • Identify Service Routes
  • Identify Service Activation Methods
• Design for Service Broker Solution Availability
  • Implement Service Broker Fault Tolerance
  • Implement Service Broker Backup Strategy

Modules & Lessons Course Overview Module Introduction Navigation Overview Lab Information Designing a Server-Side Solution for Microsoft SQL Server 2005 Designing a Service Broker Solution Module Introduction Overview of a Service Broker Solution Lesson Introduction Components of a Service Broker Solution Example Service Broker Solution Self Test Designing a Service Broker Solution Architecture Lesson Introduction Using Service Broker Services and Conversations Considerations for Implementing a Service Broker Solution Considerations for Identifying Services Considerations for Identifying Conversations Considerations for Designing Dialog Standards Considerations for Designing Queue Usage Self Test Designing Service Broker Data Flow Lesson Introduction Process of Designing Service Broker Data Flow Considerations for Identifying Conversation Groups Considerations for Identifying Data-Staging Locations Considerations for Identifying Service Routes Considerations for Identifying Service Activation Methods Self Test Designing Service Broker Solution Availability Lesson Introduction Considerations for Designing Service Broker Fault Tolerance Considerations for Designing Service Broker Backup Strategy Self Test Lab: Designing a Service Broker Solution Lesson Introduction Scenario Exercise: Identifying Considerations for Designing Service Broker Components Exercises Lab Review Module Summary Glossary Module Introduction System Requirements To view this course, you need:

• A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ
• Microsoft® Windows® 2000 or higher
• Microsoft Internet Explorer 6.0 or higher
• Adobe Flash 7.0 or higher (1MB disk space needed to install)
• Microsoft Silverlight 4.0 or higher
• Microsoft Windows Media Player 7.0 or higher
• Microsoft XML Core Services 3.0 or higher
• A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.
• A sound card, and either speakers or headphones (for multi-media audio).
• Internet bandwidth of 56K or faster. Broadband internet access is recommended.

For courses containing Virtual Server-based labs (courses in the IT Professional and Developer Catalog), you will need:

• Microsoft Virtual Server ActiveX control (1MB disk space needed to install)

Test your computer's capabilities to see if it supports this course. Accessibility Requirements The following software must be running on your computer in order to access this course with Screen Reader Software:

• Microsoft Internet Explorer 6.0 or higher
• Window-Eyes from GW Micro
• JAWS from Freedom Scientific
• MSAA enabled