External Activator Security

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 Windows account that External Activator service will run as). The choice is from well-known Windows service accounts and a custom user with a password….


Sample activated application

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. A file with source code of the application is attached to this post and you can get it by clicking here. The sample assumes a usage scenario…

18

Get Started With Using External Activator

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 steps: ·         How to create a notification service ·         How to create an event notification…

20

Service Broker Wait Types

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 the statistics for all wait types and can potentially point to performance issues and code paths with high…

9

Announcing Service Broker External Activator

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 messages from the database engine service to an application executable that runs outside the database…

5

Securing a dialog with certificates

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 on a database-to-database basis. If this is required, then dialog security can…

1

Fast data push tuning

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 service broker can handle a proposed work load, and how to “tune” a broker…

3

Reusing dialogs with a dialog pool

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 dialog pool is a variation of Remus Rusanu’s reusing and recycling…

1

Using multiple routes in Service Broker

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, I suggest staying within single database. Once you have an idea of how…

0

Real Time Data Integration with Service Broker and Other SQL Techniques

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 which is incorporated into the data integration service. Please refer to provided links for…

9