SQL Server: Building Simple Asynchronous Applications
Course info



Course info



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.
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.