Monthly Archives: December 2012

Service Broker: add message to queue

In this post let’s dwell on adding messages to queues. In our system we prefer doing it inside triggers. Why triggers? There are several reasons: You cannot miss trigger event, whenever you perform update through web-service, or direct in the … Continue reading

Posted in Database development, SQL Server, Technology | Tagged , , , | 2 Comments

Why Service Broker? + Service Broker customization.

First, let’s start from advantages of Service Broker (SB) – why it can be useful. I will list main points and examples how we use it. SB provides mechanism of asynchronous queue. This gives us an opportunity to move some … Continue reading

Posted in Database development, SQL Server, Technology | Tagged , | Leave a comment

Service Broker (SB): first look

In this post I would like to start a series how we use Service Broker in our enterprise system. Today I would like to speak about target scheme that we were planning to archive several years ago, later I would … Continue reading

Posted in Database development, SQL Server, Technology | Tagged , | Leave a comment