Sunday, August 10, 2008

Articles that I read and would like you to read


A cool article that brings you back to basics, but still it is very important to understand

Subject: Back to Basics: Understanding task dependencies

Best Regards

Bilal Okour

EPM Quick Reference Guide for Project Managers & Team Members


Microsoft published new Quick reference guide for Project Managers and another one for Team members. These are really great where I have been asked by a lot from my customer to provide with such a quick references


Here are the links

For Project Managers:

For Team Members:

now they are free and in Word format


Best Regards

Sunday, August 3, 2008

4 in 1

Did you get the chance to explore the Project server Database, if yes then I am sure that you wonder why there are 4 databases created for each instance of the PWA. I will not answer why but I will till you in brief what is the purpose of each


  1. The Draft database contains tables for saving unpublished projects from Project Professional and other applications. Project Web Access does not show project data in the Draft database.
  2. The Published database contains all of the published projects as well as enterprise resources, the enterprise global template, and other project templates. Published projects are visible in Project Web Access. The Published database also contains tables that are specific to Project Web Access (timesheets, models, views, and so on), and global data tables (outline codes, security, and metadata).
  3. The Archive database saves backup and older versions of projects and other data.
  4. The Reporting database is the staging area for generating reports and OLAP cubes. Data in the Reporting database is comprehensive and is updated nearly in real time. The Reporting tables are optimized for read-only report generation.

For more details please read this article

Best Regards

Bilal Okour