SQL Server: Building Simple Asynchronous Applications
This course explains and demonstrates the basic configuration of Service Broker and how to build single-database, asynchronous applications using the Service Broker components provided by SQL Server.
What you'll learn
The Service Broker feature of SQL Server is transforming the way developers think about processing requests within the database and opens new opportunities for scalable applications. This course is for application and database developers that want asynchronous processing capabilities in SQL Server, queue-based processing, or a guarantee of reliable execution of queued requests, even after an instance failure. The course walks through how to build a simple two-way, message-processing application using a single database, and is applicable to all versions from SQL Server 2005 onwards.
Table of contents
- Introduction 1m
- Building a Stored Procedure for Queue Processing 3m
- Demo: Building a Stored Procedure 4m
- System Messages to Handle 1m
- Demo: Handling System Messages 3m
- Testing Queue Processing End-to-end 3m
- Demo: Testing Processing 3m
- Automating Processing with Internal Activation 2m
- Demo: Automating Activation 2m
- Module Summary 1m