Christophe Fiessinger's Blog Updates on Microsoft's Enterprise Social Networking (ESN) and Project Portfolio Management (PPM) offerings
A lot of you have been asking for it, the TechNet team just published it :)
Requirements for using SQL Server 2008 Analysis Services with the Project Server 2007 Cube Building Service
and yes Project Server 2007 is supported on SQL Server 2008 as stated here (bottom of the page): http://technet.microsoft.com/en-us/library/cc197379.aspx
Office Project Server 2007 supports Microsoft SQL Server 2008. However, you must install Windows SharePoint Services 3.0 with Service Pack 1 (SP1) or later as well as Office Project Server 2007 SP1 or later before you install SQL Server 2008.
Key reasons why consider SQL 2008:
Check the related TechNet article for more information:
Please find attached an inventory of ActiveX controls required for both Microsoft Project Server 2007 and Microsoft Portfolio Server 2007. These ActiveX controls need to be deployed on user’s desktop. Thanks Boris B for putting this together.
This 490-page white paper covers the essential phases and steps to upgrade existing instances of SQL Server 2000 and 2005 to SQL Server 2008 by using best practices. These include preparation tasks, upgrade tasks, and post-upgrade tasks. It is intended to be a supplement to SQL Server 2008 Books Online.
The categories in the following list correspond to chapters in the white paper.
Other related links:
The SQL has just released the following article: Running SQL Server 2008 in a Hyper-V Environment, Best Practices and Performance Considerations
Hyper-V in Windows Server 2008 is a powerful virtualization technology that can be used by corporate IT to consolidate under-utilized servers, lowering TCO and maintaining or improving Quality of Service. Through a series of test scenarios that are representative of SQL Server application fundamentals, this document provides best practice recommendations on running SQL Server in Windows Hyper-V environment.
Last week the URL Rewrite Module for IIS 7 was released, this could be useful for your Project Server and SharePoint Server deployment:
URL Rewriter for IIS 7.0 enables Web administrators to create powerful rules to implement URLs that are easier for users to remember and easier for search engines to find. By using rule templates, rewrite maps and other functionality integrated into IIS Manager, administrators can easily set up rules to define URL rewriting behavior based on HTTP headers and server variables, or to perform redirects, send custom responses, or stop HTTP requests based on the logic expressed in the rewrite rules.
Check the announcement from the Windows Server team: URL Rewriter RTW and More IIS Extension Updates
Save the date: May 11-15 2009 in Los Angeles, California. We are back to single week covering both Developer and IT Professional communities.
Expect to see some great Enterprise Project Management sessions.
and in case you missed I also expect to see you at the next Project Conference in September 2009 in Phoenix Arizona.
Check out the following article from TechNet Magazine (December 2008 edition) from Pav Cherny on how to deploy Project Server 2007 on top on Windows Server 2008 and SQL 2005: Inside SharePoint Enterprise Project Management with SharePoint.
Key Enterprise Project Management Resources
Please join us this week to the following two webcasts:
TechNet Webcast: Microsoft Office Project Server 2007: Workload Scenarios and Reference Architecture (Level 300)
Wednesday, November 12, 2008 - 1:00 P.M.–2:00 P.M. Pacific Time
In this webcast, we cover Microsoft Office Project Server 2007 workload scenarios and reference architecture to help you plan your deployment. We discuss typical product operations broken out by user roles and explain how they affect performance. We also present typical reference architecture based on key capacity planning characteristics. This webcast is part of a series targeted at IT professionals. In the series, we present the key aspects in detail that you should consider when you evaluate, plan, deploy, and operate Project Server 2007.
TechNet Webcast: Performance Management Using Project Server 2007 and PerformancePoint Server 2007 (Level 200)
Thursday, November 13, 2008 - 1:00 P.M.–2:00 P.M. Pacific Time
The Microsoft Enterprise Project Management (EPM) Solution allows users in an enterprise environment to create, select, plan, and manage projects over their lifespan. The EPM Solution includes Microsoft Office Project Professional 2007, Project Server 2007, and Project Portfolio Server 2007. Operational systems such as those built with EPM have a point-in-time view of the world for most of their metrics. As the number and complexity of projects rise, it is critical that you are able to create trend analysis and other performance management reports easily. In this webcast, you learn how to use the Microsoft Business Intelligence suite to augment the suite of built-in operational reports in the EPM Solution to deliver a broad range of analysis to the entire organization. This approach uses Microsoft Office PerformancePoint Server 2007 to integrate data from EPM as well as other internal systems, such as human resources. We also cover the Microsoft SQL Server Analysis Services cubes that ship with Project Server and discuss how you can extend their capabilities by adding additional data and analytics. Attend this webcast to discover:
How to create PerformancePoint key performance indicators (KPIs) targeted to project management, exception reporting, and guided analytics.How to implement a PerformancePoint application that you can roll out to your entire organization using Project Server.How easy it is to create trend analysis reports using PerformancePoint, enabling business users to look at all KPIs over time.
For other past and upcoming webcasts check the following: http://www.microsoft.com/events/series/epm.aspx
The Ramp Up program (www.MyRampUp.com) has just launched a brand-new learning track: SharePoint for Developers, Part I today. This includes:
Ramp Up is a free, online, community-based program that can help users save time in learning Microsoft technology. The easy-to-access content (provided by subject-matter gurus) is specifically tailored to the Ramp Up program, and offered in a variety of forms (whitepaper, v-lab, codecast and slidecast). This SharePoint track, along with the other currently offered tracks (eg, Visual Studio 2008), teaches the important skills in a guided path, making the learning process easier and more efficient. Currently, there are no assessments in the program, so it's quicker than ever to graduate and receive the reward (25% off on certification and 50% off on e-Learning - only for graduates of Ramp Up).