Categories
PowerShell SQL Server

PowerShell Script to check SQL server connectivity, version, custering status, user permissions

SharePoint service account requires dbcreator and securityadmin roles to setup a farm. Often time it is neglected by the clients while provisioning the accounts as in most cases there are two different teams involved in this the Active Directory team and the DBA’s whose manages the SQL Server platform. The missing right are discovered late […]

Categories
SharePoint WSS

SharePoint Calculated Columns Formulas

SharePoint/WSS has field type which is calculated column. This is very handy for end users who do not have to run to their IT for new calculated data they require. Well but they are not well documented and not everyone knows tricks to put formulas to work. I have numerous situations where I need to […]

Categories
SharePoint

SharePoint Cumulative Update for Feb 2009

Microsoft has released cumulative update for WSS 3.0 on 24 Feb which has the following HotFix 961750 (http://support.microsoft.com/kb/961750/ ) Description of the Windows SharePoint Services 3.0 hotfix package (Sts.msp): February 24, 2009 963023 (http://support.microsoft.com/kb/963023/ ) Description of the Windows SharePoint Services 3.0 hotfix package (Sts.msp): January 27, 2009 961175 (http://support.microsoft.com/kb/961175/ ) Description of the Windows […]

Categories
SharePoint

SharePoint Planning and Architecture Resources : Visio Diagrams

Arno Nel has published links to a really cool set of Visio drawings that relate to Microsoft SharePoint on his blog: Arno Nel 2.0 – The Information Worker. The diagrams illustrate models, scenarios, and flowcharts for planning, designing and deploying SharePoint installations. These high-quality Visio drawings were created by Microsoft for the TechNet site, and […]

Categories
SharePoint

Running CQWP on Team Site without publishing infrastructure feature enabled (MOSS 2007)

Content Query Web Part (CQWP) is by far the most useful web part when it comes to render the contents and allowing developers full control over its style and layout. It is bundled as part of MOSS 2007 and it is enabled with Publishing Infrastructure. So if you are using Team Site template then the […]

Categories
SharePoint WSS

Determine the site template used to create SharePoint sites

I was facing an issue where two site which were look alike but behaved differently, the navigation and bread crumbs were laid differently. We have a standard process to using pre defined templates and as per the request for site creation both the site were suppose to have Team Site template and I guess they […]

Categories
SharePoint WSS

Installing a language pack for SharePoint (MOSS SP1 and WSS 3.0 SP1)

Installing SharePoint 2007 (MOSS) or WSS 3.0 in multi-lingual environment is not point and click process. It take you a while to download and install them all. Also it depends on how many language are you supporting. To enable SharePoint for multi-lingual contents you need to install the following component and most importantly you have […]

Categories
SharePoint WSS

Enumerating all Document Libraries and Form Libraries in a Site Collection Using SQL

Recently I had a situation where I needed to produce a list of all Document Libraries and Forms Libraries within a site collection along with associated template attached to them. The site collection was quite huge with the database size of over 75 Gigs and thousands of libraries and the environment was SharePoint Portal Server […]

Categories
Team Foundation Server (TFS)

TFS Tools and Utilities – Part I : User Permissions

TFS though a good product lack a lot of administration UI. Typically this is not a characteristic of a Microsoft product. When I first installed and started using TFS I went around searching for any administration console on the server which is more common for a Microsoft product but could not find one. Then I […]

Categories
SharePoint WSS

Optimizing SharePoint or WSS for large document size

The default max single file upload size is 50 MB by default for a web application.  Microsoft IT limits their environment at 100 MB, and the maximum that the product itself can handle or support is 2GB which is essentially a SQL limit.  By setting the limit to blank will essentially support what SQL will […]