SharePoint 2010 and Project Server 2010 Service Pack 1 Released!

Microsoft has released Service Pack 1 for SharePoint Foundation, SharePoint Server 2010, and Project Server 2010. You can find them on the Microsoft Download Center or through these direct download links:

• Service Pack 1 for SharePoint Foundation 2010 (KB2460058)
• Service Pack 1 for Microsoft SharePoint Server 2010 (KB2460045)
• Service Pack 1 for Microsoft Project Server 2010 (KB2460047)
• Service Pack 1 for Microsoft SharePoint Foundation 2010 Client Object Model Redistributable (KB2508825) 32-bit Edition
• Service Pack 1 for Microsoft SharePoint Foundation 2010 Client Object Model Redistributable (KB2508825) 64-bit Edition

What fix am I looking forward to most in the service packs you ask? The ability to use browsers other than Internet Explorer with Project Server 2010. Yay.

Error saving SharePoint 2010 site as template or activating a site template

If you receive the following error when saving a SharePoint 2010 site as a template or activating the site template in the site collection solution gallery:

Feature definition with Id 316e6f10-362c-4a52-943f-182dba32a876 failed validation, file ListInstances\ElementsFields.xml, line 321, character 325: The 'NoCrawl' attribute is not allowed. ...

Read full article

Project Server 2010 Status Report database schema

Recently I needed to incorporate some status report data from Project Server 2010 into a custom report. No problem, I though, I just need to find the schema for the related tables. After a lot of searching online, I came up empty. So, after a little digging, here’s a picture of the schema I was able to reverse engineer. Note that the tables are in Project Server’s Published database, not in its Reporting database, so use caution when querying the data.

Extranet Topologies for SharePoint 2010

Microsoft has posted a nice diagram of various extranet server farm topologies available for SharePoint 2010. The diagram includes advantages and disadvantages of each topology as well what the farm layout might look like. The included topologies are:

• Edge firewall
• Back-to-back perimeter
• Back-to-back perimeter with cross-farm services
• Back-to-back perimeter with content publishing
• Split back-to-back
• Split back-to-back optimized for content publishing

Download the document from:
http://www.microsoft.com/downloads/en/details.aspx?familyid=EB4BFF25-BABA-4112-B518-F2FC442D5467&displaylang=en

No cross browser support in Project Server 2010, requires Internet Explorer

I was really excited about the SharePoint 2010’s cross browser support. I even lauded Microsoft in this video clip. Well imagine my surprise when I tried to access a local Project Server 2010 Project Web Access site in my shiny new Firefox 4 browser, and I got the nasty error:

“Project Server 2010 requires at least Microsoft Internet Explorer 7.0.”

I can’t believe this is the way the product was released, and after Microsoft made such a big deal about replacing the ActiveX grid that Project Server 2007 used with SharePoint Foundation’s JavaScript Grid, something else for which I applauded them. Oh well, I guess we’re back to 1990 with Internet Explorer-only web applications.