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 database. Trigger is always inside your transaction. Also you can…
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 hard SQL procedures from users’ transactions. E.g.: we had stored…
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 dwell on how we have developed it. I will not…