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 прошла для меня достаточно просто: с самого начала я…
This post will end the first look on every day\every week planning with two reports: Hours Planned for Developers and Triage. The report Hours Planned for Developers gives simple picture what workload developers have on each week: Whether there are hours that stay in the past. Whether developer does not…
Continue speaking about Change data capture I would like to start from the detailed description of the tables with business data database structure. The structure looks like: Just few words about each table: ABSMainRate– for every change in users’ database cause new record in this table. REV – is the…
I would like to speak about Aging Report this post. This report helps us to look on the age of Work Items. I want this report to show me not only some totals, but also allow me to drill through to each single work item that is out of date….
GDPR Cookie Consent with Real Cookie Banner