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.
Course info
Rating
(52)
Level
Beginner
Updated
Mar 10, 2016
Duration
1h 38m
Table of contents
Description
Course info
Rating
(52)
Level
Beginner
Updated
Mar 10, 2016
Duration
1h 38m
Description

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.

About the author
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.

More from the author
SQL Server: Using SentryOne Plan Explorer
Intermediate
2h 44m
Nov 18, 2019
More courses by Jonathan Kehayias
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone. My name is Jonathan Kehayias and welcome to my course SQL Server: Building Simple Asynchronous Applications. I'm a principal consultant and trainer at SQLskills. com and have been working with SQL Sever for the last 11 years including using Service Broker with many clients. Most developers interact with SQL Server in a synchronous fashion, sending request to the server and waiting for the results to be returned. However, this is not always ideal and Service Broker provides a flexible and easy to implement way of interacting asynchronously with SQL Server. In this course we'll introduce the basic components required to develop single database asynchronous applications in SQL Server and how to automate processing using queues, services, messages, and contracts in Service Broker. Some of the major topics that we'll cover include: building a Hello World application in Service Broker, the basic architecture and components of Service Broker, building a full application with Service Broker, and some basic trouble shooting scenarios. By the end of this course you'll know how to implement simple asynchronous processing of request in SQL Server using Service Broker. Before beginning the course you should have a basic understanding of Transact-SQL as a language and SQL Server. But no prior knowledge of Service Broker is necessary. From here you should feel comfortable diving into more advanced Service Broker implementations like communicating between instances, addressing scalability problems, and adding high availability to your Service Broker solution. All our which I'll be covering in future courses. In the meantime, I hope you'll enjoy this course and join me on a journey to learn about Service Broker with the SQL Server Building Simple Asynchronous Application course here at Pluralsight.