SQL Server Service Broker for Developers and DBAs

Don’t know why SQL Server experts use Service Broker? Don’t know why you should be too? Find out fast!

Course Summary

Learn to use SQL Server Service Broker effectively

You’d like to avoid tight coupling in your database applications
You need queues in your database and suspect that you shouldn’t be building your own using tables
You’d really like the queues to work with transactions
You want to send messages between systems asynchronously (i.e. you don’t want to wait for the other system)
You’d like to create triggers that do hard work and you’d like them to do it asynchronously
You’ve heard that service broker is difficult but not sure if that’s true
You’ve configured service broker before but not sure if you’re doing it correctly
You want to learn from an expert

If any of these apply to you, this course is for you! And as well as detailed instruction, the course also offers hands-on labs with downloadable resources, and video lab walk-throughs, quizzes to check your learning, and a certificate on completion.

Enroll now for $295 USD !

Modules and Lessons

Module 0: Getting started

Who is this course for?
Who is Greg?
What will I learn in this course?
Configuring your lab environment

Module 1: Core service broker concepts

What is Service Broker?
Why message-based?
Asynchronous designs
Asynchronous processing
Robust communication
Common asynchronous scenarios
Application queues
Alternatives to Service Broker
Service Broker history
Processing performance
What Service Broker is not
Lab 1: Review lab scenarios
Lab 1: Set up test system
Quiz 1: Core Service Broker concepts

Module 2: Service Broker message flow and objects

Typical topology
Service defined
Queue defined
Message Type defined
Conversation defined
Conversation Group defined
Contract defined
Dialog defined
Message reliability
Message ordering and retry
Processing messages in a queue
Ending a conversation
Quiz 2: Service Broker message flow and objects

Module 3: Implementing Service Broker objects

Using T-SQL to implement objects
Checking if Broker is enabled
Built-in Message Types
Creating a Message Type
Built-in Contracts
Creating a Contract
Modifying contracts
Built-in Queues
Creating a Queue
Built-in Services
Creating a Service
Lab 3: Implementing Service Broker objects
Lab 3: Solution
Quiz 3: Implementing Service Broker objects

Module 4: Sending and receiving messages

Creating a dialog conversation
Sending a message
Receiving and peeking at messages
Conversation states
Ending a conversation
Securing messages
Lab 4: Sending and receiving messages
Lab 4: Solution
Quiz 4: Sending and receiving messages

Module 5: Activation

Message processing options
Internal activation
Queue monitors
Designing efficient internal activation
Activation execution context
External activation
Poison messages
Lab 5: Activation
Lab 5: Solution
Quiz 5: Activation

Module 6: Routing

Message routing
Service Broker Endpoints and protocols
Create an Endpoint
Route defined
Special routing values
Built-in Route
Creating a Route
Routing logic
Message forwarders
Conversation Priority defined
Creating and assigning Conversation Priority
Quiz 6: Routing

Module 7: Architectural considerations

General design considerations
Number of Services and Queues
High availability options
Design for Performance
Quiz 7: Architectural considerations

Module 8: Monitoring and troubleshooting Service Broker

Health monitoring
Broker statistics report
Troubleshooting internal activation
Troubleshooting lack of messages
Clean up transmission queue
Troubleshooting conversation priority
ssbdiagnose diagnostic tool
Lab 8: Using ssbdiagnose
Lab 8: Solution
Lab 8: Walk-through
Quiz 8: Monitoring and troubleshooting Service Broker

Module 9: Next steps

Summary and further steps

Enroll now for $295 USD !