SQL Server Service Broker—Security
There are 2 types of security in Service Broker: dialog and transport. Dialog security establishes a secure, authenticated connection between Service Broker Services or dialog endpoints.
Colleen Morrow
SQL Server Service Broker—Sending & Receiving
Service Broker uses TCP/IP to communicate with other Service Broker services on the network.
SQL Server Service Broker—Internal Activation
The other way to automate this stored procedure is by attaching it to the queue itself so that it Service Broker directly executes the procedure in a process called activation. With activation Service Broker starts an application whenever there is work to do (e.g. when messages are in the queue).
SQL Server Service Broker – Networking
This post is part of a series on this blog that will explore SQL Server Service Broker, a native messaging and queueing technology built into the SQL Server Database Engine.
SQL Server Service Broker – Error Handling
This post is part of a series on this blog that will explore SQL Server Service Broker, a native messaging and queueing technology built into the SQL Server Database Engine.
SQL Server Service Broker – Conversation Architecture
This post is part of a series on this blog that will explore SQL Server Service Broker, a native messaging and queueing technology built into the SQL Server Database Engine.
SQL Server Service Broker – Service Architecture
This post is part of a series on this blog that will explore SQL Server Service Broker, a native messaging and queuing technology built into the SQL Server Database Engine. Previous post: SQL Server Service Broker – Introduction See all posts in the series here. In this installment, we introduce the basic Service Broker service … Full story
SQL Server Service Broker – Introduction
SQL Server Service Broker is a messaging technology that’s baked right into the SQL Server engine. It was first introduced in SQL Server 2005, and if you ask me, is one of the most under-utilized, under-appreciated features in SQL Server.
SQL Server Service Broker – Security
There are 2 types of security in Service Broker: dialog and transport.
