February, 2008

Christophe Fiessinger's Blog
Updates on Microsoft's Enterprise Social Networking (ESN) and Project Portfolio Management (PPM) offerings

  • Christophe Fiessinger's Blog

    Running SQL Server Profiler with Project Server

    Quite often when you are performing customizations or when you want to troubleshoot your Project Server deployment it's useful to go "deep" and see what's happening under the SQL hood.

    The best way to achieve that is to run a SQL Server Profiler trace on the SQL Server instance you want to analyze. Since Project Server 2007's architecture is based on a queuing system you will find a lot of "noise" if you run a standard trace.

    I have attached at the end of this post a template I have created that eliminates a lot of the extra SQL queries due to the queuing system.


    • Download trace template and copy it when you'll be running the SQL Profiler from
    • Double click on it:

     125 2008-02-28, 21_55_37

    • SQL Server Profiler is launched and you should get this message:

    126 2008-02-28, 21_57_29

    • Click OK and click New Trace then connect to the DB server
    • Under Use Template select Project Server 2007 SQL Trace Template, and run trace

    127 2008-02-28, 21_59_30

    • Sample trace should look like this:

    128 2008-02-28, 22_05_57

    Please note that this trace only looks at databases with the suffix Published and ignores commands with prefix MSP_TimesheetQ.
    Happy tracing!

  • Christophe Fiessinger's Blog

    Database Maintenance for SharePoint

    Bill Baer’s white paper: Database Maintenance for SharePoint is now live. 

    Table of Contents

    • Check for and repair consistency errors by using DBCC CHECKDB 1
    • About DBCC CHECKDB 1
    • DBCC CHECKDB and performance 2
    • Measure and reduce fragmentation 3
    • Measure fragmentation in a SQL Server 2005 database (sys.dm_db_index_physical_stats) 4
    • Measure fragmentation in a SQL Server 2000 database (DBCC SHOWCONTIG) 5
    • Reducing Fragmentation for a Database 6
    • Reducing fragmentation for a specific table and its indexes 9
      • Using ALTER INDEX 9
    • Fine tuning index performance by setting fill factor 10
    • Shrinking data files 10
      • Shrinking a database by using Transact-SQL commands 11
      • Shrinking a database by using SQL Server 2005 Management Studio 12
    • Creating SQL Server 2005 Maintenance Plans 13
    • Configure a SQL Server 2005 Database Maintenance Plan 13
    • Summary 22
  • Christophe Fiessinger's Blog

    Project Server 2007 post-Service Pack 1 hotfix package

    On December 11th, 2007 Microsoft released Service Pack 1 (SP1) for the 2007 Microsoft Office System. We released this week the post-SP1 hotfix package (fixes made after the SP1 code base was locked down and up until SP1 is released), as well as Project Portfolio Server 2007 Service Pack 1.

    This hotfix package is intended to correct only the problems that are described in the Knowledge Base (KB) articles mentioned below. Apply it only to systems that are experiencing this specific problem, or if the customer has been waiting for this package to deploy SP1. 

  • Christophe Fiessinger's Blog

    IT Manager Webcast: Deploying SharePoint Server with Project Server 2007

    I'll be hosting the following webcast targeted at IT Professionals on  Thursday, March 20, 2008, 11:00 AM Pacific Time (US & Canada)

    Out of the box, Microsoft Office Project Server 2007 is deployed on top of Windows SharePoint Services. In this session, we explain why customers are deploying Project Server 2007 with Microsoft Office SharePoint Server 2007 as well, and we describe how together these products offer the best combination of collaboration, project, and portfolio management. We review and demonstrate the added benefits of Report Center, Excel Services, key performance indicators (KPI), InfoPath Forms Services, Business Data Catalog, and Enterprise Search in the context of a Project Server deployment.

    Register for this Live Webcast

  • Christophe Fiessinger's Blog

    Advanced SharePoint Videos and Whitepapers available on TechNet

    Watch lectures delivered by experts in Microsoft Office SharePoint Server 2007, and download and read supporting white papers:

    Advanced lectures and white papers

    • Overview: Office SharePoint Server server farm architecture
    • Overview: Configuring server farms
    • Securing server farms
    • Configuring performance options
    • Backing up and restoring Office SharePoint Server server farms
    • Operations and management
    • Capacity planning
    • Search architecture and configuration
  • Christophe Fiessinger's Blog

    Timesheet Data Population Tool on CodePlex

    The Project Server 2007 Timesheet data population tool has been released on CodePlex: http://www.codeplex.com/EPMTSdatapop

    The Project Server 2007 Timesheet Data Population Tool enables you to simulate timesheet entries in your farm. This tool can help you perform scalability studies of your PS architecture and validate the sizing of an existing architecture (by measuring timesheet queue throughput for instance). This tool can also be used to test timesheet customization, for instance the Timesheet Tied-mode code sample on Codeplex. This powerful tool should not be run a production environment!

    The Timesheet Data Population tool is a console application written in C#.  It uses standard PSI (Project Server Interface) web service methods to populate timesheets.

    Please refer to the latest version of the Project Server Software Development Kit (SDK) for more information on the PSI methods and how to use them.

    This solution starter was written initially to perform Project Server 2003 vs. Project Server 2007 benchmarks, and has been used since to perform scalability studies and to test timesheet customizations.

  • Christophe Fiessinger's Blog

    SharePoint post-Service Pack 1 hotfix package

    These hotfix are intended to correct only the problem that is described in the KB articles above. Apply it only to systems that are experiencing the specific problem.

    Contact Microsoft Customer Support Services to obtain these hotfix.

  • Christophe Fiessinger's Blog

    Project Portfolio Server 2007 Service Pack 1

    PPS SP1 was released today.

    Description of Project Portfolio Server 2007 Service Pack 1:

    Download PPS SP1

    This service pack can only be applied to an existing installation of Microsoft Office Project Portfolio Server 2007.

    To install Microsoft Office Project Portfolio Server 2007, please see the deployment guide.

  • Christophe Fiessinger's Blog

    Custom Project Initiation Solution Starter on CodePlex

    A new solution starter that demonstrates how to leverage InfoPath & Forms Services as well Windows Workflow Foundation (hosted by SharePoint) to create your own project initiation phase has been released on CodePlex.

    The project initiation phase is different for every customers and organizations. It typically requires a set of custom attribute to be filled in a web based custom form; and then it needs to go through a custom approval process workflow reviewed by all key decision makers. InfoPath Forms services combined with a SharePoint’s sequential workflow enables you to achieve this business need. This solution starter also demonstrates the added value of deploying Project Server 2007 in a SharePoint Server farm (using InfoPath Forms Services).

    The goal of this solution starter is thus to provide the following two code samples:

    • InfoPath Form with managed code that issues Project Server Interface calls to populate and submit form data
    • SharePoint sequential workflow that leverages the form created earlier to create a custom workflow

    This solution starter requires Project Server 2007, InfoPath and Forms Services 2007, and Visual Studio 2008.

    Step 1 – Fill out and submit Project Initiation Form Step 2 – Approve data submitted in Step 1 and create Project in PS 2007 Resulting data in Project Server 2007
    clip_image001 clip_image002 clip_image003

    This solution starter was created for a presentation I delivered at the 2008 Office Developer Conference.

  • Christophe Fiessinger's Blog

    Project in a Terminal Services environment

    Please find below useful links when deploying Project Standard or Project Professional on a Terminal Services (or Citrix) environment.

    A common issue I have heard/seen is that the version used on Terminal Services is incorrect (you need a Volume License Key) with this type of error message displayed: "This copy of Microsoft Office Project cannot be used on Terminal Server".

    This issue is addressed in the following knowledge base article: http://support.microsoft.com/kb/924622

    Other useful links are:

Page 1 of 2 (15 items) 12