SharePoint 2010 - SharePoint 2010 just got quicker. The latest patch is doing it’s job!

I’m running Windows 7 on a Dell Latitude E4300 4GB RAM with SharePoint Server 2010 installed for development and demo purposes. In the beginning SharePoint was running with an acceptable performance, but sometimes there would be a little wait here and there.

A few days ago Microsoft released an update for SharePoint Foundations 2010, which it claimed would improve stability and performance.

Guess what? After it was installed, I browsed my SharePoint sites using Chrome – man, it was lightning fast! Was it Chrome? Don’t think so. Same quick response in Internet Explorer 8! The performance is noticeably MUCH quicker. Great job guys!

This is the patch I installed:
Update for Office SharePoint Foundations 2010 (KB2032588)

“Microsoft has released an update for Office SharePoint Foundation 2010, 64-bit Edition. This update provides the latest fixes to Microsoft WSS 2010, 64-bit Edition. Additionally, this update contains stability and performance improvements.”

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=f6f1d567-a21f-4770-80ba-f7d6e05f11aa

SQL Versions – Tip of the day

I was installing SharePoint 2010 – wait, what about the pre-requisites?
- SQL 2005 SP3 with Cumulative update package 3
- OR SQL 2008 SP1 with Cumulative update package 2

So what version have we got? Here’s the tip of the day (for me and to you to share), run this SQL Query to find out:

SELECT serverproperty('productversion'),
       serverproperty('productlevel'),
       serverproperty('edition') 

This should give you information to determine the version number, the release level (RTM or Service Pack), and the edition (Express, Standard or Enterprise).

For convenience, I’ve added the version numbers required for SharePoint 2010:
- SQL 2005 SP3  - 2005.90.4035
- SQL 2008 SP1 – 2007.100.2531.0


For more version numbers go to http://support.microsoft.com/kb/321185.

Referenced from this Microsoft KB http://support.microsoft.com/kb/321185

Microsoft SharePoint Server 2010 – Certifications?

I just read an official note that there will be new four SharePoint 2010 certifications – and they are not specific to either SharePoint Foundation 4 or SharePoint Server 2010.

These exams are:

• 70-667: TS: Microsoft SharePoint 2010, Configuring
• 70-668: PRO: Microsoft SharePoint 2010, Administrator
• 70-573: TS: Microsoft SharePoint 2010, Application Development
• 70-576: PRO: Designing and Developing Microsoft SharePoint 2010 Applications

According to this blog post, the exams are expected to be available in June/July timeframe. More details here.

Microsoft SharePoint Server 2010 Beta 2 – How to recover data from an unattached content and restore it to a (or another) site

A new feature in SharePoint 2010 is the ability to recover content from an unattached database (also tested to work for attached databases). The following are steps to do this (in case I forget in the future).
Note of warning: Screen shots and directions in this entry are based on SharePoint 2010 Beta (v. 14.0.4536.1000) and may change without notice.
I. Export from Database
1. Within Central Administration v4, browse to “Backup and Restore” section in the Quick Launch

2. Click “Recover data from an unattached content database”:

3. On the “Unattached Content Database Data Recovery” Page, enter the database server and database name of the source database to restore from, select “Browse content”, and click Next:

4. Select the Site Collection from the Database, the site from the database and the List as required, select “Export site or list”, and click Next (Note – this screen shot is based on a Beta version, and it appears that even though you have the correct site collection selected, the URL shows the central administration url. Only the relative URL is correct here):

5. Type in a file share location (ensure the SharePoint Farm account has owner access to this folder in Windows), and click Start Export:

6. Wait for the job to complete:


7. Files will be created in the share directory (Note: Contents of the .cmp file can be opened as a cab file – just like most other wsp packages):

II. Import to new Site
1. Open up the SharePoint 2010 Management Shell


2. Let’s assume we have already created a blank site to be restored to @ dougleung.com. We will now restore to that SharePoint Site:
Run this command in the Management Shell:
Import-SPWeb –Identity [url] –path [path]
eg. Import-SPWeb –Identity http://dougleung.com –path \\servername\folder\exportfile.cmp

3. Your contents from your export file (in this case the exported Announcements list) will be imported to the dougleung.com site.