Archive for October, 2005

Project Management 2005 – Free Certification

Friday, October 28th, 2005 is not a new name in certification & online testing. They have certifications on wide range of subjects.


Recently they have offered free versions of some of their tests. Project Management 2005 is one of them. The test is based on PMBOK 3rd edition.


For test outlines & details check this URL.


It’s an opportunity to get a certification from a well known company. Don’t miss it ūüėČ

MS Project & Project Server URLs

Friday, October 28th, 2005

Microsoft Links on MS Project & MS Project Server 2003

Project Downloads

Project On Office Online

PS2003 FAQs

MP2003 Support Center

PS2003 Support Center

Project Newsgroups

General Questions Newsgroup

Project Server Newsgroup

Project Development Newsgroup

Search MS Knowledge Base for Project

Project 2003 Assistance (Articles)

Blogs on MS Project & Project Server

Project Downloads

PS2003 Resource Kit

Tools & Utilities for MS Project Server

PS2003 Portfolio Analyzer OLAP Extensions
PS2003 Software Development Kit (SDK)

PS2003 Project Data Service (PDS) Usage and Methods Reference

PS2003 Web Parts and URL Options

Important Topics

Dig Deeper into Scheduling

Course 2732 – Planning, Deploying, and Managing an EPM Solution

Exam 70-281 on Planning, Deploying, and Managing an EPM Solution

Project MVPs (Most Valuable Professionals)

Search for Project Events & Webcasts

MP In-Person Events

MP Project Live Webcasts

MP On-Demand Webcasts

PS In-Person Events

PS Live Webcasts

PS On-Demand Webcasts

Webcasts on Project
TechNet Support WebCast: Active Directory synchronization behavior and troubleshooting in Project Server

Sharepoint Portal Server SP2

Thursday, October 27th, 2005

Microsoft has released the Service Pack 2 (SP2) for SharePoint Portal Server (SPS) 2003. You can check the description of the SP2 here:


You can check the list of bug fixed done in SP2.


Utilities and Tools For MS Project Server

Thursday, October 27th, 2005

There are a lot of good utilities for MS Project Server which eases tasks of Project Administrators & Project Managers. Some of these include:

  • Project Rename
  • Set Tracing
  • EditSite Tool
  • Restore Single Project
  • Project Server Health Monitor
  • PSCOMPlus Tool
  • & few others

I’ve found these tools very helpful during my work on Project Server 2003. You can download these tools from this url on Microsoft site.

I’ll post the functionality of each in a table format sometime here. So keep clicking this space.

MS Project KB Sites

Thursday, October 27th, 2005

MS Project Server KB Articles Home

MS Project KB Articles Home

Sharepoint Portal Server 2003 SP2 Released

Wednesday, October 19th, 2005

Microsoft has released the service pack 2 for Sharepoint Portal Server (SPS) 2003.

Description of SPS 2003 SP2

Issues that are fixed by SPS 2003 SP2


New Reporting Tools For SharePoint Portal Server

Monday, October 17th, 2005

SQL SP to search for string in all tables in a DB

Wednesday, October 12th, 2005

When working on SQL databases, from time to time you feel the need to search for a integer / string in all the tables of a databses. I found these solutions handy.

a. Search for a string in all tables of SQL Server Database

b. Searching and finding a string value in all columns in a SQL Server table

c. Search entire SQL Server database and all tables for a specified string

I wanted to search for a string while I was working on MS Project server database in production. This query solved my purpose.

1. Run the script (go to url above) in Query Analyzer for the database in which you want to search for a integer / string

2. Use the syntax mentioned or try one in the examples section to search for integer / string
3. View the results by querying the ##tmpSearchResult table

(Imp: Play with the script in your testing environment then use in production. Use it at your own risk.)