How to upgrade your existing Microsoft Project VPC running on SQL 2005 to SQL Server 2008

I’m sure you have seen these cool SQL Reporting Services 2008 reports: Microsoft SQL Server Reporting Services 2008 – Sample Project Server Reports and would like to do the same in your favorite EPM demo VPC or you just have plenty of free time during this time of the year and you are looking for…

0

SharePoint Performance Tuning References

Thanks to Roger Lamb please find references to improve SharePoint’s and Project Server performance: Case Study: Using Microsoft® Office SharePoint® Server to implement a large-scale content storage scenario with rapid search availability (TechNet) White paper: Database Maintenance for Microsoft® SharePoint® Products and Technologies  (TechNet) White paper: Scaling SharePoint 2007 – Storage Architecture (Knowledgelake) Physical storage…

1

Persist SQL Server Analysis Services Roles settings Solution Starter on CodePlex

A new solution starter that demonstrates how to persist SQL Server Analysis Services (SSAS) Roles settings in the Project Server OLAP database was released today on CodePlex. For instance you might require to create specific Roles in your OLAP database if you have non Project Server users that need to access the database, for instance…

1

New SQL Reporting Services Sample Reports for Project Server

(August 20, 2009 update, check out this Second Report Pack for Project Server 2007)  We have released last week an updated version of our EPM 2007 demo VPC. Please find below the SQL Server Reporting Services (SSRS) reports used in that VPC. All these SSRS reports are using the Project Server 2007 Reporting database as a…

19

Project Server Statistics

Do you ever need to do an audit of your Project Server 2007 data (prior to a migration, to cleanup unnecessary data, to track the historical volume of data…)? Please find attached a T-SQL script that will retrieve the following information: General Project statistics (number of projects, number of resources…) Custom Fields and Lookup Tables…

0

SQL Server Best Practices

With the numbers of databases required in EPM 2007, it’s key to have a well tuned and maintained database server. The following TechNet page gives a recap of all SQL Server Best Practices: Get the real-world guidelines, expert tips, and rock-solid guidance to take your SQL Server implementation to the next level. These SQL Server…

2

Microsoft RML Utilities for SQL Server

Handy tool for your WSS/MOSS/EPM deployments. Brief Description Tools to help database administrators manage the performance of Microsoft SQL Server. Overview Do you know which databases or applications are using the most resources on your server? How will a service pack upgrade, configuration change or application change affect your production SQL Server? The RML Utilities…

2

Project Server Extended Report Pack from Project Conference

Following my presentation yesterday on reporting at the Project Conference in Seattle, please find below the “Extended” EPM report pack I demoed (leveraging SQL Server Reporting Services). Reports added are: Deliverables and Dependencies Issues and Risks Report Project Workspaces ProjectList PSI XML ResourceList PSI XML Risks – XML Data Srouce SSAS Timesheet Timesheet Audit 2…

1

EPM Database Maintenance Tasks

After you deploy EPM 2007 in your production environment, I highly recommend you have a SQL maintenance plan in place. Maintenance tasks that should be in this plan include: Backup Check DB integrity Rebuild Index (-> update statistics) History cleanup Maintenance cleanup For more information on this subject please check the standard SQL documentation as…

4

Controlling the project workspaces list

By default when provision a Project Web Access site, the home page contains a webbox called “Project Workspaces” which display a list of all project’s WS that have been created. By default there are two ways to display the list of WS: “All Workspaces” and “Owned Workspaces” and that’s it. A common request from customers…

4