Archive for October, 2005

Project Management 2005 – Free Certification

Friday, October 28th, 2005

Brainbench.com 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.

http://tinyurl.com/d67sr

 

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

http://tinyurl.com/an628

Project On Office Online
http://office.microsoft.com/project/

PS2003 FAQs
http://tinyurl.com/dxaj7

MP2003 Support Center
http://support.microsoft.com/ph/2525

PS2003 Support Center
http://support.microsoft.com/ph/2526

Project Newsgroups
http://tinyurl.com/8z7b5

General Questions Newsgroup
http://tinyurl.com/84j99

Project Server Newsgroup
http://tinyurl.com/alzfh

Project Development Newsgroup
http://tinyurl.com/a6wyx

Search MS Knowledge Base for Project
http://support.microsoft.com/search/?adv=1

Project 2003 Assistance (Articles)
http://tinyurl.com/8k5ro

Blogs on MS Project & Project Server
http://blogs.msdn.com/lduff/default.aspx

Project Downloads

PS2003 Resource Kit

Tools & Utilities for MS Project Server
http://support.microsoft.com/kb/839457

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
http://tinyurl.com/a4uar

Course 2732 – Planning, Deploying, and Managing an EPM Solution
http://tinyurl.com/crr3c

Exam 70-281 on Planning, Deploying, and Managing an EPM Solution
http://www.microsoft.com/learning/exams/70-281.asp

Project MVPs (Most Valuable Professionals)
http://www.mvps.org/links.html#Project

Search for Project Events & Webcasts
http://www.microsoft.com/events/AdvSearch.mspx

MP In-Person Events
http://tinyurl.com/9yje6

MP Project Live Webcasts
http://tinyurl.com/bdz43

MP On-Demand Webcasts
http://tinyurl.com/7rxey

PS In-Person Events
http://tinyurl.com/abtn8

PS Live Webcasts
http://tinyurl.com/7q3b2

PS On-Demand Webcasts
http://tinyurl.com/c3bcb

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

http://support.microsoft.com/default.aspx?kbid=906738

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:

http://support.microsoft.com/kb/887623

 

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

http://support.microsoft.com/kb/906337/

 

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.

http://support.microsoft.com/kb/839457

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
http://support.microsoft.com/ph/2526

MS Project KB Articles Home
http://support.microsoft.com/ph/2525/en-us

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
http://support.microsoft.com/kb/887623/

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

 

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