So, we’ve come to the most important phase for Project Manager – Planning Phase. Why is it so important? The main reason is that on this phase we lay the baseline for the whole project. And with poor foundation any “building” would crash. This building – is our project, and…
While creating SQL queries for reports, it’s usually required to get a continuous list of dates for a given period. E.g.: get all dates from 1980 Jan 01 till 2013 Dec 31 (12419 records). In this post I would like to describe several ways how this can be done and…
In this post I will finish the story started a week ago about Project Initiation phase. We have determined high level objectives and scope of the project, put down boundaries and constraints and check whether our activity is a project or just a work request. Now we have to prepare…
In this post I will finish the ERP system performance block. Today I have chosen topic not directly connected with SQL Server, but it’s rather important for building complete picture of the process. So, we have analyze in details how to look for performance bottlenecks inside system business logic, but…
As I promised, this post will be dedicated to some real life practice. We’ll try to find the bottle neck in one document save process. The principles and structures for ERP performance were described in the previous posts you can find them in my blog. The work starts when we…
In the Project Management Request I’ve concentrated on the request pre-phase of the project and on its main document A3. If A3 has been approved by project sponsor it’s time to start project initiation phase. Initiation phase precedes Project Detailed phase and prepare Project manager and project team for real work….
In this post I’d like to show what performance reports we use in our everyday work to track whether system is ok or not. First section – reports we are receiving on daily basis. Timeout Report. The report consists of two parts: Chart with Timeout Coefficient and List of Timeout…
From this post I would like to switch from TFS reporting to Project Management. The main reason is, that I have described all reports my team is using in everyday work. But of course, if we get some new ones – I will post about them for sure. So, what…
In this I will continue previous one What performance metrics are important and how to collect them and will describe the database structure to store performance statistics. I will take as basis the structure designed by me and generalize it for common use. The database can be divided into two parts:…
На прошедшей недели получилось вернуться к Манчину, но играли не в Манчкин Квест, а в обычный вариант игры. Не могу сказать, что игра мне очень понравилась, но Манчкин показал себя достаточно легкой в освоении игрой, к которой я готов вернуться. Большинство тех недостатков, которые есть в Манчкин Квест, у этой игры либо…