Autoplay
Autocomplete
HTML5
Flash
Player
Speed
Previous Lecture
Complete and continue
SQL Server Service Broker for Developers and DBAs
Module 0: Getting started
Who is this course for? (0:56)
Who is Greg? (1:17)
What will I learn in this course? (1:15)
Configuring your lab environment (12:24)
Module 1: Core service broker concepts
What is Service Broker? (1:59)
Why message-based? (3:19)
Asynchronous designs (1:37)
Asynchronous processing (4:11)
Robust communication (1:45)
Common asynchronous scenarios (2:12)
Application queues (1:33)
Alternatives to Service Broker (5:05)
Service Broker history (3:26)
Processing performance (1:15)
What Service Broker is not (2:02)
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 (1:52)
Service defined (1:32)
Queue defined (1:40)
Message Type defined (1:46)
Conversation defined (1:08)
Conversation Group defined (1:14)
Contract defined (1:51)
Dialog defined (1:18)
Message reliability (1:13)
Message ordering and retry (1:26)
Processing messages in a queue (1:21)
Ending a conversation (1:04)
Quiz 2: Service Broker message flow and objects
Module 3: Implementing Service Broker objects
Using T-SQL to implement objects (1:40)
Checking if Broker is enabled (2:30)
Built-in Message Types (1:45)
Creating a Message Type (2:43)
Built-in Contracts (0:40)
Creating a Contract (2:30)
Modifying contracts (1:19)
Built-in Queues (0:40)
Creating a Queue (1:39)
Built-in Services (0:28)
Creating a Service (1:33)
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 (4:24)
Sending a message (0:30)
Receiving and peeking at messages (4:08)
Conversation states (1:31)
Ending a conversation (1:06)
Securing messages (1:21)
Lab 4: Sending and receiving messages
Lab 4: Solution
Quiz 4: Sending and receiving messages
Module 5: Activation
Message processing options (0:47)
Internal activation (3:54)
Queue monitors (3:30)
Designing efficient internal activation (1:39)
Activation execution context (1:44)
External activation (1:57)
Poison messages (4:00)
Lab 5: Activation
Lab 5: Solution
Quiz 5: Activation
Module 6: Routing
Message routing (1:48)
Service Broker Endpoints and protocols (1:16)
Create an Endpoint (4:07)
Route defined (1:13)
Special routing values (1:12)
Built-in Route (0:48)
Creating a Route (2:30)
Routing logic (0:51)
Message forwarders (2:02)
Conversation Priority defined (1:33)
Creating and assigning Conversation Priority (1:51)
Quiz 6: Routing
Module 7: Architectural considerations
General design considerations (3:08)
Number of Services and Queues (0:54)
High availability options (1:09)
Design for Performance (0:57)
Quiz 7: Architectural considerations
Module 8: Monitoring and troubleshooting Service Broker
Health monitoring (1:08)
Broker statistics report (2:27)
Troubleshooting internal activation (1:00)
Troubleshooting lack of messages (2:01)
Clean up transmission queue (1:19)
Troubleshooting conversation priority (1:00)
ssbdiagnose diagnostic tool (3:16)
Lab 8: Using ssbdiagnose
Lab 8: Solution
Lab 8: Walk-through (1:43)
Quiz 8: Monitoring and troubleshooting Service Broker
Module 9: Next steps
Summary and further steps (0:48)
Lab 8: Solution
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock