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…
One of the most important measures of system stability is how many not closed bugs exist at present moment. I will not speak about SLA here (or how quickly IT team is closing them) – this will be the subject of future post. So, how to track number of open…
One of the sessions on Microsoft TechEd 2012 Russia was dedicated to KPIs in IT. It has interested me rather greatly, as in my role as Team Lead I have to deal with them at least weekly. So I’ve decided to dwell on this topic and in the first post…
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…
Last week I’ve visited Microsoft TechEd 2012 in Russia, Moscow. In this post I would like to share some emotions and impressions from the conference. Everything for me began on Friday’s evening November 23rd, when I received the invitation to the conference as a presenter of a mini session about…
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…