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…
In this post I will continue to speak about project management and how TFS helps me handling it. I’ve started from Project Kick-off meeting, then we have created branches for project’s code and reserved iterations for development and testing. Now we are ready for Detailed Planning phase. Still we are…
Not so long ago we have faced the following problem while implementing SQL jobs to test and production environment: Job is developed be developer by deployed to test or production by DBA. E-mail lists, folders are different on each environment. So the process was the following: developer come and together…
In this post I will continue speaking about projects, but now I will come back to TFS. Today’s story is about Merge & Branch structure and strategy for projects and significant changes. In one scheme it can be presented the following: So we have four branch directions: Main branch –…