EPM, Enterprise Project Management, Project Server, Project Portfolio Server, SharePoint Services, SharePoint Server
Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server 2005   (RSS)

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 Read More...
Posted Wednesday, June 18, 2008 9:18 PM by chrisfie | 1 Comments

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 Read More...
Posted Thursday, April 10, 2008 11:47 PM by chrisfie | 1 Comments

New SQL Reporting Services Sample Reports for Project Server

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 data source. Read More...
Posted Thursday, April 10, 2008 7:15 PM by chrisfie | 9 Comments
Attachment(s): EPM2007 VPC V2- SSRS Reports.zip

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 Read More...
Posted Tuesday, January 08, 2008 10:23 PM by chrisfie | 0 Comments
Attachment(s): EPM2007 Statistics.txt

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 Read More...
Posted Friday, January 04, 2008 7:05 PM by chrisfie | 2 Comments

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 Read More...
Posted Tuesday, December 18, 2007 5:43 PM by chrisfie | 2 Comments

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 Read More...
Posted Tuesday, October 30, 2007 4:40 PM by chrisfie | 0 Comments
Attachment(s): Microsoft Project 2007 Report Pack Extended Project Conference.zip

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 Read More...
Posted Thursday, October 25, 2007 10:07 PM by chrisfie | 2 Comments

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” Read More...
Posted Wednesday, October 03, 2007 10:41 PM by chrisfie | 3 Comments
Attachment(s): Project WS 1.rdl

Newly published content for Office Project Server 2007

You should probably bookmark this url: Newly published content for Office Project Server 2007 and check it on a regular basis for updated documentation on the EPM 2007 platform. For instance this month a detail guide on configuring OLAP for EPM 2007 using Read More...
Posted Thursday, April 26, 2007 5:02 PM by chrisfie | 0 Comments

Configuring a SQL 2005 Analysis Repository for DSO9 instead of an Access MDB

The standard procedure to configure ( KB 921116 ) the Cube Building Services (Analysis Services 2005) for Project Server is to copy the Msmdrep.mdb file on a network share. ¾ Get a backup of a SQL 2000 AS Repository database (you can use the migration Read More...
Posted Thursday, December 14, 2006 4:43 PM by chrisfie | 2 Comments
Attachment(s): AS2000_Repository_BAK.zip

Configuring Project Server 2007 with SQL Server Analysis Services 2005

When you use SQL Server 2005 Analysis Services (please note you need to apply SP1), you'll have to follow the procedure described in this KB to configure the "cube refresh": http://support.microsoft.com/default.aspx/kb/921116/en-us Read More...
Posted Saturday, December 09, 2006 1:11 PM by chrisfie | 0 Comments
 
Page view tracker