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….
New really great feature appears in SQL Server 2008 – change data capture. In few words: Change data capture records insert, update, and delete activity that is applied to a SQL Server table. This makes the details of the changes available in an easily consumed relational format. Further details can be…
Straight to the point: this week I’ve faced an interesting SQL issue. Few words about environment where it has occurred: Enterprise system with SQL Server 2005 databases. All changes made by users are logged using internal mechanism to history tables. The mechanism looks like Change Data Capture, but this possibility…
На прошедшей неделе устроили внутрисемейную партию в Агрколу. Играли втроем: я, жена и сын, естественно в семейную версию игры без карт Простых улучшений и Занятий.Игра получилась очень интересной, я, к сожалению, допустил несколько ошибок, в итоге занял только второе место, отдав лавры победителя жене. Итоговый счет: 37–35–27.Про игру в двух…
Today I would like to focus on the main tool that my team is using for every day control of planning process. I called it Task Capacity report. If you are familiar with Microsoft Project and Gantе chart you will find much common between this tools and Task Capacity report,…
Let’s try to have a look at some SQL functions that are not very popular but can be very useful in some cases. Let’s imagine that we have the following task: replace all letters in a varchar column between first and last spaces with symbol ‘*’. The task can be…
На прошедшей неделе поиграть не получилось, поэтому продолжу статистический анализ сыгранных партий.По временам года: Здесь картина ожидаемая – зима и осень вне конкуренции. Действительно, лета и весна это отпуска, выезд на природу – особо не разыграешься.По месяцам: Поразил ноябрь. Надо попробовать понять, чем он так выделяется. Почему у него такой…
Let’s go to the next activity: I called it every day\every week planning. These periods cannot be separated as they’re going hand by hand through the planning process. We create plans for a week and control it on every day basis. Some key moments of this type of planning are:…
As promised I’m going to describe main reports that are based on Project and Scenarios work items and give me possibility easily to analyze my projects portfolio and resource workload. Of course you can say that these reports can be easily received from MS Project Server, but it rather expensive…
GDPR Cookie Consent with Real Cookie Banner