SharePoint ULS log viewer tool comparison and verdict

There has been some confusion on which SharePoint ULS log viewer to use when troubleshooting SharePoint issues. In May 2010, I blogged about the SharePoint 2010 ULS Log viewer published by Microsoft (

SharePoint 2013 Alert: In August 2014, I blogged about a re-released ULS Viewer for SharePoint 2013 enhanced by Microsoft.

Read more about it here:

In this post, I have discussed all the ULS log viewer tools here with screenshots and my final verdict..

Continue reading

Install Reporting Services 2008 R2 in Sharepoint Integrated mode via command line

In this article, we will discuss a few things to have you installing Reporting Services 2008 R2 with SharePoint 2010 in ‘SharePoint Integrated mode’ – not NATIVE mode using a config file for the SQL set up (Reporting Services is a SQL product) and also integrating Reporting Services with SharePoint (the Central Admin stuff). Continue reading

Moving SharePoint sites off the system drive – changing IIS virtual directories

A good practice is to move IIS off the system drive to another such as D:

Ok, so you tell your Server guys but they miss out on an important step such as updating the registry to the new D:\inetpub… location. You dont check this since you think they know what they are doing and go ahead and install SharePoint and once you are done, you realise that your Central Admin website has been installed and its virtual directory is located on C: – the system drive.

What now?
Continue reading

SharePoint 2010 database maintenance

This is a reminder for SharePoint Admins, DBAs and Developers to ensure that they have taken the necessary steps recommended by Microsoft when it comes down to SharePoint 2010 database maintenance.

A few years ago, I posted out a similar ‘reminder’ for SharePoint (MOSS) 2007.

More recently, last year, Microsoft (Bill Baer and Bryan Porter) published a document on SharePoint 2010 database maintenance. Continue reading to get a summary of what is involved in maintaining databases for SharePoint 2010…

Continue reading

SharePoint Diagnostic Studio 2010

When troubleshooting SharePoint 2010 issues, you often find the need to have a tool that can give you performance, availability and usage metrics over a period of time across the farm.

One such tool is Microsoft’s SharePoint Diagnostic Studio 2010 that comes free as part of the SharePoint 2010 Administration Toolkit v2.0.
Download here:

Continue reading

Getting started with PowerPivot for Excel in SharePoint 2010

PowerPivot (previously known as Project Gemini) is a Microsoft’s business intelligence (BI) solution, allowing business management and decision makers to collect and present business data in Excel or web based via SharePoint.  Many business executives have the capability to harness PowerPivot for Excel 2010 or SharePoint 2010 as they already either have the platforms in place or are a few steps away in getting this state-of-the-art BI solution by Microsoft.

Continue reading

SharePoint 2010 Site Collection size and email it via PowerShell script

I was asked to generate a list of SharePoint sites and their sizes via powershell and notify certain people via email. Here is some powershell that generates a html file with all the site collections in your farm and the sizes in MB and then emails it off to different people.

Unfortunately, at this point in time, there is no powershell to get sizes for ‘subsites’ (SP-Web), only for site collections. Continue reading

Finally a custom SharePoint 2010 PerformancePoint Database Name switch!

I was keen from Day 1 to install SharePoint 2010 WITHOUT the GUIDs in the database names for the farm and service applications! That was possible through PowerShell but with the exception of ONE Service Application database – PerformancePoint!

Good news is that since SharePoint 2010 SP1 we now have a ‘DatabaseName’ switch parameter when creating a new PerformancePoint Service Application through PowerShell!

Open PowerShell:

Type in: get-help New-SPPerformancePointServiceApplication -full
    –DatabaseName [<string>]
        Specifies the name of the PerformancePoint Service database used for the service application.
        Required?                    false
        Position?                    Named
        Default value
        Accept pipeline input?       False
        Accept wildcard characters?  false

Project Server 2010 Planning design and deployment video training

For those who are visually inclined and prefer webcasts, here is an awesome Project Server 2010 training for designing, planning a Project Server 2010 deployment.

More videos: