Install SQL 2008 Express Management Studio

If you are using standalone instance of SharePoint 2010 and want to add SQL Express 2008 Management Studio to the machine, you may encounter errors during installation. The option looks valid is to add feature to current instance. however, it is not the correct one.

After some search on line, I found this blog with detail information Turns out you need to select New Instance option (I have no idea why) to continue. So if you were not able to install management studio for SQL Express 2008, try this article first.

Where is the Datasheet View in SharePoint 2010

If you have installed Office 2010 64-bit to a 64-bit OS machine, you may find out you are not able to use Datasheet view in a library or list. This will happen to users who is working on a single machine or VM environment with SharePoint 2010 and Office 2010 installed together.

So, what can you do?

According to Microsoft, you can install Office 2010 32-bit instead. The other option is mentioned in this blog, install Access Runtime for 2007 or 2010. When that blog was published, Access Runtime 2010 is still in Beta version. Now you download the full version from here.

Find closed web parts all over your portal

For most users, it's very common to close, instead delete a web part from pages, especially the landing page of a site. As an administrator, you can go to each page and open web part maintenance page to check and removed closed ones.

However, how do we find out which site has the most and deal with them first if you have hundred of sites to manage? You can use a SQL query to geerate a list. (MIcrosoft said do not touch your database, so, this is just for your own reference and risk).

select ''+dirname+'/'+ leafname+'?contents=1'
from alldocs inner join webparts on
Alldocs.id=webparts.tp_pageurlid
where tp_isincluded=0