Design for Operations Integration Kit

This is interesting - it’s a sample that generates work items in Team Foundation Server when a .NET application has application errors or performance problems.

The only problem I can see is that it apparently requires MOM on the server where the applications are deployed.

We currently just generate e-mails with the exception details and send them to the developers. Still, if the dependency on MOM could be removed then this could be useful.

SQL Server 2005 SP1

SQL Server 2005 Service Pack 1 has been released

There are also “April” releases of a number of other SQL 2005 tools:

• Microsoft SQL Server 2005 Upgrade Advisor
• Feature Pack for SQL Server 2005 Apr 2006
• SQL Server 2005 Samples and Sample Databases (April 2006)

Setting TFS work items to default to be unassigned

Wouldn’t it be nice to have your work items in Team Foundation Server default to be “unassigned”, so that it is easier to determine what jobs are being worked on and what are unallocated?

Well it turns out this is possible.

First of all, you need to export the work item definitions that you want to customise:

cd "C:\Program Files\Microsoft Visual Studio 8\Common7\IDE" witexport.exe /t tfsserver /p ProjectName /n Bug /f c:\Bug.xml witexport.exe /t tfsserver /p ProjectName /n Task/f c:\Task.xml

Now open these .xml files, locate the “Assigned To” field and update it to be the following:

 <FIELD name\="Assigned To" refname\="System.AssignedTo" type\="String" reportable\="dimension"\>

 <HELPTEXT\>The person assigned to do the work</HELPTEXT\>

 <ALLOWEDVALUES expanditems\="true"\>

 <LISTITEM value\="\[Project\]\\Project Administrators" />

 <LISTITEM value\="\[Project\]\\Contributors" />

 </ALLOWEDVALUES\>

 <PROHIBITEDVALUES\>

 <LISTITEM value\="Project Administrators" />

 <LISTITEM value\="Contributors" />

 <LISTITEM value\="domain\\tfssetup" />

 </PROHIBITEDVALUES\>

 </FIELD\>

What this does is limit the users that are displayed in the “Assigned to” drop-down list box to be just the direct project administrators and contributors.

Import these back into TFS:

witimport.exe /t tfsserver /p ProjectName /f c:\Bug.xml witimport.exe /t tfsserver /p ProjectName /f c:\Task.xml

Next, from Team Explorer, right-click on the team project and select Team Project Settings | Group Membership. Click on the ‘New’ button and create a new project group named “Unassigned”. Select the [Project]\Contributors group and add the [Project]\Unassigned group as a member. Now, select the team foundation server from with the Team Explorer, and right-click and ‘Refresh’ to reload the new templates.