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
About the author
Jonathan Kehayias is a Principal Consultant with SQLskills. He is the youngest person ever to achieve the Microsoft Certified Master - SQL Server 2008 certification and has been a SQL Server MVP for many years. Jonathan is heavily involved in the SQL community; including being the top answerer on the MSDN Database Engine forum, writing deep technical content on his blog (plus his old blog, and answering questions as @SQLPoolBoy on Twitter. Jonathan is a performance tuning expert, both SQL Se... more