Editing work item description in Excel would show the following warning and the description would lose all its formatting.

by XDK 12. February 2015 08:03



Team Foundation Server doesn't allow editing the actual HTML out of the fields. The text typed in Excel would be published without any of its HTML tags and that is the reason that it lost its formatting.

Following link has the reason why Microsoft wouldn't allow HTML editing



Tags: , ,

TFS 2012 | TFS 2013

User cannot upload the .SWF file in Share Point 2010

by XDK 4. February 2015 12:27


"Error: Access Denied" appears. User cannot upload the .SWF file". 


Users with contributor permissions are prevented from uploading files with extensions ASPX,MASTER,XAP,SWF,JAR,ASMX,ASCX,XSN and XSF


1. Provide "design" permission to the users trying to upload the restricted extensions
2. These restricted extensions are listed in the WebFileExtensions property of the WebApplication. The WebFileExtensions property can be programatically edited as follows

  PowerShell script to list the WebFileExtensions property            

$WebApp = Get-SPWebApplication https://<SharePoint Site Collection URL>/
$Extensions = $WebApp.WebFileExtensions
$Extensions | ForEach-Object {Write-Host $_}

PowerShell script to remove the .swf restriction from the WebFileExtensions property
$WebApp = Get-SPWebApplication http://<SharePoint Site Collection URL>/
$Extensions = $WebApp.WebFileExtensions $Ext = $Extensions.Remove("swf") $WebApp.Update()



How to receive the TFS alerts via a text message?

by XDK 4. February 2015 09:20


Following are the steps to configure TFS alerts via a text message

1.Open team project alerts page : 
http://<TFS SERVER>:8080/tfs/<COLLECTION NAME>/<PROJECT NAME>/_admin/_alerts
2.Enter cell phone number @ your carrier’s email in "send to" field to the existing or new alerts.
Send To: T-MobileNumber@
Carrier Email to SMS gateway
  Alltel : Your Mobile Number@message.alltel.com
  AT&T : Your Mobile Number@txt.att.net
  Boost Mobile : Your Mobile Number@myboostmobile.com
  Sprint : Your Mobile Number@messaging.sprintpcs.com
  T-Mobile : Your Mobile Number@tmomail.net
  US Cellular : Your Mobile Number@email.uscc.net
  Verizon : Your Mobile Number@vtext.com
  Virgin Mobile : Your Mobile Number@vmobl.com


TFS 2010 | TFS 2012 | TFS 2013

How to add IE 11 version to the browser Type to configure a Load Test in Visual Studio IDE?

by XDK 30. January 2015 07:02


1. Open Notepad.

2. Edit the file with the following details

 <Browser Name="Internet Explorer 11.0" MaxConnections="6">
    <Header Name="User-Agent" Value="Mozilla/5.0 (Windows NT 6.3; Trident/7.0; rv:11.0) like Gecko" />
    <Header Name="Accept" Value="*/*" />
    <Header Name="Accept-Language" Value="{{$IEAcceptLanguage}}" />
    <Header Name="Accept-Encoding" Value="GZIP" />

3. Save the file as "IE11.browser" under "C:\Program Files (x86)\Microsoft Visual Studio <Version>\Common7\IDE\Templates\LoadTest\Browsers"


Web Performance & Load Tests | Visual Studio 2010 | Visual Studio 2012 | Visual Studio 2013

How to copy folders and files with the permissions?

by XDK 30. January 2015 06:46


xcopy "<Source Folder>" "<Target Folder>" /O /X /E /H /K

/X - Copies file audit settings and file ownership and ACL information.
/H - Copies hidden and system files.
/E - Copies directories and sub directories, including empty ones.
/V - Verifies each new file.

/D - Copies files changed on or after the specified date (D:m-d-y).If no date is given, copies only those files whose source time is newer than the destination time.

/Y - Suppresses prompting to confirm you want to overwrite an existing destination file.

/K - Copies attributes. Typically, Xcopy resets read-only attributes

/O - Copies file ownership and ACL information

Tags: ,

Supporting Tools

TFS Web interface is not rendering the date field with respect to “daylight saving”

by XDK 29. January 2015 18:28


TFS Web interface is not rendering the date field with respect to “daylight saving” which is causing the confusion between the date field displayed in web access and visual studio IDE. The TFS date fields populated with the date during “daylight saving” on and time as 23:00 are displayed as next day in Visual Studio IDE which is logical and expected.


Install latest "Daylight Saving Time (DST)" update for windows on your app tier(s).

More info: http://support.microsoft.com/gp/cp_dst

Tags: , ,

TFS 2010 | TFS 2012 | TFS 2013

How to upgrade Visual Studio Load Test Rig from 2010 to 2012?

by XDK 20. January 2015 17:26


Pre-Upgrade Tasks

Make a note of the members in the following Test controller windows groups

  • TeamAgentService,TeamTestControllerAdmins and TeamTestControllerUser

Make a note of the members and permissions in "LoadTest2010" DB

Uninstall 2010 Test Agents.

Uninstall 2010 Test Controller.

Installing 2012 Test controller 

Install Test controller with the default option.

Configure Test Controller as below


Create load test result repository by execution the loadtestresultsrepository.sql script at <VS Install Dir>\Common7\IDE


1) Open a cmd prompt

2) Change into the following directory: <VS Install Dir>\Common7\IDE

3) Run the following command: sqlcmd -S <DB Server Name> -i loadtestresultsrepository.sql

Installing 2012 Test Agents

Install Test Agents with the default option.

Configure Test  Agents as below


Post-Upgrade Tasks

Add the users to the following windows groups identified in 2010 load test rig.

  • TeamAgentService,TeamTestControllerAdmins and TeamTestControllerUser

Add the users and permission\login access to "LoadTest2010" DB identified in 2010 load test rig DB


Web Performance & Load Tests

The load test results database could not be opened.

by XDK 20. January 2015 16:41


"The load test results database could not be opened. Check that the load test results database specified by the connect string for your test controller (or local machine) specifies a database that contains the load test schema and that is currently available. For more information, see the Visual Studio help topic 'About the Load Test Results Store'. The connection error was: An error occurred while attempting to create the load test results repository schema: To create the database 'LoadTest2010' your user account must have the either the SQL Server 'sysadmin' role or both the 'serveradmin' and 'dbcreator' roles"



Check your remote test settings in VS solution. You should create a remote test settings in VS solution and specify the remote test controller.

1. Open Test solution

2. Double click on "test settings file". (for example: Local.testsettings)

3. Select "Test execution method" as "Remote execution"

4. Select your remote controller for "Controller"

5. click "Apply"

6. Right click on the "test settings file"

7. Select "Active Load and Web Test Settings"



Performance decreases in TFS 2013 Update 2 after you upgrade to SQL Server 2014

by XDK 11. January 2015 15:14


These issues occur because the hardware requirements for SQL Server 2014 are greater than those for earlier versions of SQL Server. 

Work Around:

Work Around link


Team Foundation Server | SQL Server | TFS 2013

SCRUM - AGILE Workflow status support

by XDK 11. January 2015 09:30


Team Foundation Server


The information provided here is based on my expreriences, troubleshooting and online/offline findings. It can be used as is on your own risk without any warranties and I impose no rights.

About the author

My name is Xavier Dilip Kumar Jayaraj and I am a Software Configuration Management Engineer with a background in application development, Build & packaging using Install Shield.

Profile in LinkedIn , PCEP-Certified , Azure-DevOps-C1

DevOps Tools

ALM tools:
Azure DevOps
IBM Rational
CA Agile Central-Rally
CollabNet VersionOne

Configuration tools:
• Puppet
• AWS OpsWorks
• Ansible

Build automation tools:
Apache Ant 
Apache Maven

Continuous Integration tools:

Testing tools:

Version control system tools:
Team Foundation Server

Code review tools:
Bitbucket Server

Continuous Delivery/release management tools:
XL Release
Serena Release
Octopus Deploy

Quotes I Like

"Failure will never overtake me if my determination to succeed is strong enough."  - Dr. APJ. Abdul Kalam

"Always be yourself, express yourself, have faith in yourself, do not go out and look for a successful personality and duplicate it." - Bruce Lee

"Technology is just a tool. In terms of getting the kids working together and motivating them, the teacher is the most important." - Bill Gates

"Innovation distinguishes between a leader and a follower." - Steve Jobs

Knowledge Base Articles