SQL Server: Building Multi-instance Asynchronous Applications

Learn how to use Service Broker to send messages between databases in a single instance or between multiple instances. This course is applicable to all versions of SQL server and is aimed at application and database developers.
Course info
Level
Intermediate
Updated
February 13, 2018
Duration
2h 20m
Table of contents
Introduction
7m 10s
Description
Course info
Level
Intermediate
Updated
February 13, 2018
Duration
2h 20m
Description

The Service Broker feature of SQL Server is transforming the way developers think about processing requests within the database and open new opportunities for scalable applications. This course builds on the basic concepts introduced in the SQL Server: Building Simple Asynchronous Applications course by introducing single-instance multi-database and multi-instance configurations for Service Broker. In this course, SQL Server: Building Multi-instance Asynchronous Applications, you'll learn how to configure security for Service Broker operations across databases as well as the networking and routing configurations for secure communications between multiple instances of SQL Server. Next, you'll explore bidirectional conversations between services to allow for status updates and the appropriate way of ending a conversation between two services. Finally, you'll see how to maintain and troubleshoot Service Broker configurations using the SSBDiagnose tool to validate that all of the required components have been appropriately configured, using the Dynamic Management Views for checking message statuses, and using the events in SQL Trace and Extended Events for troubleshooting Service Broker problems. When you've finished this course, you'll have the skills and knowledge to start implementing multi-database and multi-instance Service Broker configurations.

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: Change Data Capture
Intermediate
2h 10m
27 Mar 2015
SQL Server: Using SQL Sentry Plan Explorer
Intermediate
2h 4m
26 Dec 2013
More courses by Jonathan Kehayias
Transcript
Transcript

Hello,

My name is Jonathan Kehayias and welcome to my course, SQL Server Building Multi-instance Asynchronous Applications. I am a consultant and trainer with SQLskills, as well as a Microsoft Data Platform MVP. The Service Broker feature is one of the best kept secrets in SQL Server and I find that many companies don't leverage Service Broker because of the lack of information available and the lack of UI support for the feature.

This course builds on the SQL Server: Building Simple Asynchronous Applications course and expands the configuration from a single database to multiple databases as well as to multiple instances of SQL Server.

In the first few modules, you'll learn about the additional objects involved with Service Broker applications that involve multiple databases in the same instance of SQL Server as well how to send Service Broker messages to another instance of SQL Server.

Along the way, we'll discuss and demonstrate security best practices so you understand the different security considerations and any risks associated with them. You'll then learn how to support and maintain a Service Broker implementation and finally how to troubleshoot any problems that occur.

By the end of this course, you'll understand how to build asynchronous solutions on top of Service Broker using multiple databases and multiple instances of SQL Server, the considerations for transport and dialog security, and what to do when something isn't working the way that you expect it to. You only need a basic understanding of SQL Server and development to be able to follow the information in this course.

I hope you'll join me to go deeper with Service Broker in this course SQL Server: Building Multi-instance Asynchronous Applications, here on Pluralsight.