Reusing Conversations

April 25th, 2007

One of the most common deployed patterns of using Service Broker is what I would call ‘data push’, when Service Broker conversations are used to send data one way only (from initiator to target). In this pattern the target never sends any message back to the initiator. Common applications for this pattern are:

· ETL from the transactions system to the data warehouse

· audit and logging

· aggregation of data from multiple sites

Read the rest of this entry »

Consuming Event Notifications from CLR

April 11th, 2007

A question was asked on the newsgroups: how can a C# program be notified when the schema of a table was modified (i.e. a column was added)? The short answer is to use Event Notifications, see

But an example would help J. First thing, we need to set up a queue and service that will receive the notifications:

Read the rest of this entry »

Orlando slides and code

April 3rd, 2007

OK, since the devconnections site is taking a while to update, I’m posting directly my slides and code here.