Sign in
SQL Server: Service Broker Team Blog
This blog is about the Service Broker feature for the Microsoft SQL Server
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Options
Email Blog Author
RSS for posts
Atom
RSS for comments
OK
Search
Tags
.net
background tasks
certificates
conversations
data push
Definitions
dialogs
efficiency
endpoints
External Activator
External Activator Security
forwarding
high availability
load balancing
performance
periodic tasks
Poison Messages
recycling dialogs
reusing dialogs
routing
security
service application
wait-types
Archive
Archives
July 2010
(1)
March 2010
(1)
May 2009
(1)
December 2008
(1)
November 2008
(1)
August 2008
(2)
July 2008
(3)
June 2008
(3)
May 2008
(1)
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
SQL Server: Service Broker Team Blog
External Activator Security
Posted
over 3 years ago
by
luis vargas [MSFT]
1
Comments
This short post deals with security and permission-related aspects of External Activator. Selecting External Activator service account When you install External Activator, you are asked to choose the service account (the...
SQL Server: Service Broker Team Blog
Sample activated application
Posted
over 3 years ago
by
pmarciniak
18
Comments
In today’s post we're providing a sample application skeleton that may be used to play with External Activator, as well as serve as a base for writing custom activated applications....
SQL Server: Service Broker Team Blog
Get Started With Using External Activator
Posted
over 4 years ago
by
junan_msft
17
Comments
In the blog post Announcing Service Broker External Activator , we introduced Service Broker External Activator and showed what benefits a broker user can get from using it. In this article, we'll get you started with using external activator in four...
SQL Server: Service Broker Team Blog
Service Broker Wait Types
Posted
over 5 years ago
by
priyankporwal
6
Comments
SQL server engine keeps track of wait operations (aka wait types ) performed by all its executing threads, either to serialize access to protected structures or to wait for asynchronous events/notifications. Sys.dm_os_wait_stats DMV can be used to get...
SQL Server: Service Broker Team Blog
Announcing Service Broker External Activator
Posted
over 5 years ago
by
junan_msft
2
Comments
The Microsoft SQL Server Service Broker External Activator (EA) is distributed in the Microsoft SQL Server 2008 Feature Pack. It is an extension of the internal activation feature and lets you move the logic for receiving and processing service broker...
SQL Server: Service Broker Team Blog
Securing a dialog with certificates
Posted
over 5 years ago
by
portegys
1
Comments
This sample shows how to set up a secure dialog using certificates. Service broker will always have a level of security at the transport level, which may include encryption, but this is at a server level of granularity. It does not secure conversations...
SQL Server: Service Broker Team Blog
Fast data push tuning
Posted
over 5 years ago
by
portegys
3
Comments
A common use of service broker is the "data push" scenario in which messages are asynchronously sent to a destination such as a data warehouse for storage and processing with minimal impact on the source application. Two frequent concerns are whether...
SQL Server: Service Broker Team Blog
Reusing dialogs with a dialog pool
Posted
over 5 years ago
by
portegys
1
Comments
As noted in various Service Broker sources, it is often advantageous to minimize the overhead of creating dialogs to send messages on. This blog shows how to create a shared pool of dialogs to be able to reuse dialogs instead of creating new ones. The...
SQL Server: Service Broker Team Blog
Using multiple routes in Service Broker
Posted
over 5 years ago
by
pmarciniak
0
Comments
One of main Service Broker components is routing. Whenever you want your messages to leave the database they originate in, you need to provide routes. Setting up routes may become complicated, so if you're making your first steps in Service Broker area...
SQL Server: Service Broker Team Blog
Real Time Data Integration with Service Broker and Other SQL Techniques
Posted
over 5 years ago
by
Jang
8
Comments
This article discusses how to use various SQL technologies to accomplish real time data integration between SQL Server instances. It provides a set of sample code to help users with their development. The document focuses on the usage of each technology...
SQL Server: Service Broker Team Blog
Poison Message Handling
Posted
over 5 years ago
by
junan_msft
7
Comments
Service broker provides automatic poison message detection, which disables the service queue upon five consecutive transaction rollbacks in trying to receive messages from the queue. However, an application should not rely on this feature for normal processing...
SQL Server: Service Broker Team Blog
Service Broker Periodic Tasks
Posted
over 5 years ago
by
priyankporwal
0
Comments
SSB receives notifications every 5 seconds from the SQL engine's timer framework. SSB in turn counts these notifications and performs its various periodic maintenance tasks at different intervals. Tasks performed every notification: 1. Internal...
SQL Server: Service Broker Team Blog
A simple secure dialog with transport certificates
Posted
over 5 years ago
by
portegys
2
Comments
If you want to have a broker dialog between server instances, you have to be concerned with having a secure network connection, which in service broker terminology is called transport security. An effective way to accomplish this is using certificates...
SQL Server: Service Broker Team Blog
Welcome to the Service Broker Blog
Posted
over 5 years ago
by
portegys
2
Comments
Service Broker is a part of the SQL Server that allows secure, transactional messaging between databases that can be within the same server instance or in different ones. The feature first appeared in SQL Server 2005, and has a growing clientele already...
Page 1 of 1 (14 items)