Which SQL Server 2008 R2 Edition is right for your Project Server & SharePoint 2010 Farm?

A common question I have been hearing from some of you, hopefully these documents will help answer the question: http://www.microsoft.com/sqlserver/en/us/product-info/compare.aspx For instance for Analysis Services between the Enterprise and Standard edition, here is what you get: Also read this whitepaper for further information: SQL Server 2008 R2 and SharePoint 2010 Products: Better Together (white paper)…


Introducing Microsoft SQL Server 2008 R2

As announced today Free ebook: Introducing Microsoft SQL Server 2008 R2, a must read for all partners and customers out there. This upcoming release of SQL will definitely bring value to the EPM farms out there. Some quotes from the book to wet your appetite an will make you want to seriously consider SQL 2008…


Under the Table – How Data Access Code Affects Database Performance

Just read this great article from Bob Beauchemin in MSDN Magazine: How Data Access Code Affects Database Performance. It’s a great reminder when you do customization why using stored procedure to access your database is a must compared to building queries on the fly within your C# code for instance. So next time you access…


SQL Server 2008 R2 CTP Released

The Community Technology Preview (CTP) was released this morning to TechNet and MSDN subscribers. The Self-Service Business Intelligence aspect of this next SQL released due next year could be a major enhancement to Project Server reporting. To learn more: http://www.microsoft.com/sqlserver/2008/en/us/R2.aspx


SQL Server 2008 R2

Announced today at TechEd: SQL Server 2008 R2, will be a great enhancement to Project Server deployment from a reporting perspective, why? Check the following preliminary resources (more info here: R2 Benefits by Workload): Self Service Analysis with “Project Gemini” Self Service Reporting with SQL Server 2008 R2 Reporting Services Register for the Community Technology…


SQL Server 2008 Service Pack 1 (SP1)

SQL Server 2008 Service Pack 1 (SPI) is available and ready for download here (includes a pointer to the Release Notes). Related links: Why consider SQL Server 2008 for your EPM farm? Microsoft SQL Server Reporting Services 2008 – Sample Project Server Reports


Inventory of SQL Databases in a Typical Project Server Deployment

I have recently seen this question on how many databases are created once the Project Server and Project Portfolio Server are installed?  My first answer was: “it depends!” Here is why. Assume we are installing both Project Portfolio Server and Project Server on a SharePoint Server farm and that they all share the same SQL…

2

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…


Announcing the release of SQL Server 2005 SP3

Microsoft released today SQL Server 2005 Service Pack 3 (SP3). SQL 2005 version should now be 9.00.4035. Microsoft SQL Server 2005 Service Pack 3 (SP3) contains hotfixes that were included in cumulative update packages for SQL Server 2005 Service Pack 2 from cumulative update package 1 to cumulative update package 9, and fixes to issues…

1

Microsoft SQL Server Reporting Services 2008 – Sample Project Server Reports

Following the release of this sample SQL Server Reporting Services 2005 report pack: New SQL Reporting Services Sample Reports for Project Server, I have just updated two sample reports (Risks and Portfolio Status, attached below) to illustrate the use of the Gauge which comes with SQL Server Reporting Services 2008. I used SQL Server 2008…

3