Road map to Project Management

What is it?

Project management is a methodical approach to planning and guiding project processes from start to finish.

Every Project Manager’s wish is to accomplish his project goals on time with available resources. PM can achieve the goals, but finishing it with the constraints of the project is big achievement of that PM. Constraints may include time limit, budget, standards to follow etc. Good planning in the beginning can save you from a lot of hassle in the middle of the project.

I’ll quote these words about Project Management which I read today. “There's never enough time to do it right first time but there's always enough time to go back and do it again.”

The Project Map gives you guidelines for doing your project right the first time. The Project Map discussed here outlines three phases of project.

• Build a plan
• Track & Manage Project
• Close the Project

This map applies to Microsoft Project & Project Server products. You can go through it here.

http://office.microsoft.com/en-us/assistance/HA010745311033.aspx

Sharepoint Portal Server 2003 SP2 Released

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

Description of SPS 2003 SP2
http://support.microsoft.com/kb/887623/

Issues that are fixed by SPS 2003 SP2
http://support.microsoft.com/kb/906337/

Download SPS 2003 SP2
http://tinyurl.com/ac6zj

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

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. While there are queries written by many but I found this one handy.

http://tinyurl.com/7c2ho

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.)