Upgrade from TFS 2010 RC to RTM

TFS Upgrade Summary Steps

1. Ensure you have a backup of existing SQL databases (TFS, SharePoint and Reporting)
2. Uninstall Team Foundation Server 2010 Beta2/RC components (in-place upgrade)
• Use Add/Remove programs from Control Panel to uninstall TFS Components via "Microsoft Team Foundation Server 2010"
• Select "Uninstall" to remove all TFS components from each server where Beta2/RC is installed
• NOTE: You may see a program in the Control Panel called "Microsoft Team Foundation Server 2010 Object Model". This is an object model used by products connecting to TFS (e.g. Visual Studio and Team Lab). This component will be uninstalled or updated by the installation program for those products. You should not uninstall this component during the TFS 2010 upgrade process.

3. If using a separate SharePoint farm uninstall TFS 2010 Beta2/RC extensions and install TFS 2010 RTM extensions.
4. Run the TFS 2010 setup and select the Upgrade from Previous Version Wizard and complete the wizard.

Celebrating 2 years as a software engineer

It's the time to celebrate something in this life.
Work on irregular hours, weekends & night time took me to 2 years in this long career life.

When turn back of last 2 years
I was a guru in sharepoint.
Did well in WF,Reporting & TFS.
Touch areas like Infopath,Webservices & Remoting.

Hope to work on WCF,Silverlight in coming year.
It is always good to remind that i helped a lot to others &
make good contact with Gurus like prasanna,joy,dinesh,prabath,buddhima.

Did well in free lance projects on sharepoint & got big reputation.

So it was a hard working 2 years with great commitment.
Hope to do something different in future. :)


"It is better to be the first in the loosing team than the last in the winning team".

How to delete a TFS task

Sometimes we want to delete task that we have added to TFS
But there is a no way to delete using a UI.

we have to use command promt

cd C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE or
cd  C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE
then type follwing command

witadmin.exe destroywi /Collection:http:\\Optimus:8080\tfs\IPG /id:9
Collection == Team Project collection url
Id == ID that is generated by TFS


Simple as a UI click :)


Additional Details
Most of the people are not getting this witadmin.exe
So i have uploaded it.   Download WITADMIN.EXE

Get query string parameters using a Java Script

function getQuerystring(key, default_) {
if (default_ == null) default_ = "";
key = key.replace(/[\[]/, "\\\[").replace(/[\]]/, "\\\]");
var regex = new RegExp("[\\?&]" + key + "=([^&#]*)");
var qs = regex.exec(window.location.href);
if (qs == null)
return default_;
else
return qs[1];
}

//Call the function
var CategoryID = getQuerystring('CategoryIDs');

Change time format inside SharePoint

When we want to change the time format that display in sharepoint calendar,



We have to go to Site settings --> regional settings



After change the time format we can see our calendar in 24 hour time format.

Why TFS portal webparts throwing an error - [Solution]

When we have configured sharepoint webportal for TFS, sometimes is throws an error when displaying "Project Dashboard" & "My Dashboard", all webparts displaying as missing components.


This is because, we have lost all webparts (basically dll's that renders webparts).
What we have to do is,
(1) Central administration --> Operations --> Solution management --> tswawebpartcollection.wsp --> DEPLOY




(2) Central administration --> Application Management --> Manage Web Application Features --> Visual Studio Team Foundation Server Configuration --> ACTIVATE



Now refresh your page :)

SQL Inner Query to get data without a cursor

ProductCode	MinimumLevel	Bonus
1	5	2
1	10	3
1	20	5
2	5	2
3	8	2
3	12	3

SQL Query

select p.ProductCode,

p.MinimumLevel,

(select
top 1 q.MinimumLevel from ProductTable q where q.MinimumLevel > p.MinimumLevel and q.ProductCode = p.ProductCode)
as MaximumLevel,

p.Bonus

from ProductTable p

ProductCode	MinimumLevel	MaximumLevel	Bonus
1	5	10	2
1	10	20	3
1	20	NULL	5
2	5	NULL	2
3	8	12	2
3	12	NULL	3

TFS 2010 error when creating team project

This error raised, when the TFS versions are mismatch. That is TFS server version & the TFS Client (Team Explorer).

We had to uninstall previous version of "Team Explorer" & install new version.
(In my case had to uninstall TFS 2010 beta & install TFS 2010 RC)
Then it starts work fine.
Cheers...

Tax Calculation In Srilanka

Summarized Tax Table - Regular Profits from Employment

Monthly remuneration Tax in SriLanka

1. Monthly remuneration up to Rs. 27,184 - Exempt

2. Monthly remuneration exceeding Rs. 27,184 but not exceeding Rs. 63,406

4.6% of monthly remuneration less Rs. 1,250

3. Monthly remuneration exceeding Rs. 63,406 but not exceeding Rs. 78,125

9.2% of monthly remuneration less Rs. 4,167

4. Monthly remuneration exceeding Rs. 78,125 but not exceeding Rs. 97,917
10% of monthly remuneration less Rs. 4,792

5. Monthly remuneration exceeding Rs. 97,917 but not exceeding Rs. 131,250
15% of monthly remuneration less Rs. 9,687

6. Monthly remuneration exceeding Rs. 131,250 but not exceeding Rs. 172,917
20% of monthly remuneration less Rs. 16,250

7. Monthly remuneration exceeding Rs. 172,917 but not exceeding Rs. 214,584
25% of monthly remuneration less Rs. 24,896

8. Monthly remuneration exceeding Rs. 214,584 but not exceeding Rs. 256,250
30% of monthly remuneration less Rs. 35,625

9. Monthly remuneration exceeding Rs. 256,250

35% of monthly remuneration less Rs. 48,437

String Split in SQL

Declare @checkedItems varchar(20)

SET @checkedItems ='N,L,D,E'

Declare
@ParsedList table
(
OrderID varchar
)

DECLARE @OrderID varchar(10), @Pos int

SET @checkedItems = LTRIM(RTRIM(@checkedItems))+ ','
SET @Pos = CHARINDEX(',', @checkedItems, 1)

IF REPLACE(@checkedItems, ',', '') <> ''
BEGIN
WHILE @Pos > 0
BEGIN
SET @OrderID = LTRIM(RTRIM(LEFT(@checkedItems, @Pos - 1)))
IF @OrderID <> ''
BEGIN
INSERT INTO @ParsedList (OrderID)
VALUES (CAST(@OrderID AS varchar)) --Use Appropriate conversion
END
SET @checkedItems = RIGHT(@checkedItems, LEN(@checkedItems) - @Pos)
SET @Pos = CHARINDEX(',', @checkedItems, 1)

END
END

select * from @ParsedList

====================================
OUTPUT
====================================
OrderID
N
L
D
E