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 –…
One developer from my team has made the following suggestion: why not to alter all views we have in ERP system with SCHEMABINDING option? His main argument was: this would help us to set additional control for changes in tables’ structures, thus increasing system stability. The idea was interesting, so…
From this post I would like to dwell on IT projects: how we manage projects, how TFS helps us handling them, what reports we are using. The first post will be dedicated to the Project Kick off meeting, as it is the first public project event. Kick off meeting –…
In this post I would like to finish my Change Data Capture practice. So I had not described the update of history table. All details about database structure can be found in the early post http://borisfrolov.com/2012/10/28/change-data-capture-practice-experience-part-2/. As I have told everything about architecture of the designed solution, in this post…
Иногда вместо современных игр, большинство из которых достаточно сложное (надо тратить время на расклад игры, на объяснение правил), мы раскладываем игру из нашего общего детства Oh Pardon. Правила простые, что на объяснение уходит меньше минуты.Цель игры – переместить все фишки своего цвета, на поля аналогичного цвета, обозначенные на доске. Кто сделает это…
In this post I would like to speak about support reports. We have systems that are in production for quite a long period of time. And business wants some additional changes and new functionality to be implemented to the current systems. We unite such tasks into several categories and allocate…
In this post I would like to describe step-by-step process how a query can be optimized. This is taken from real practice I faced not so long ago. So, I’ve got a query that joined about 20 tables, had ORDER BY statement and rather complex WHERE clause that looked like:…
Прошедшая неделя выдалась достаточно богатой на число партий, в которые удалось сыграть (особенно по сравнению с октябрем, когда почти не играли): Ticket To Ride: Europe -1 партия Dixit – 1 партия Черепашьи бега – 1 серия игр Во все игры играли впятером.Партия в Ticket To Ride прошла для меня достаточно просто: с самого начала я…