Chris Leong

Disoriented views from the rosy lens of an optimistic realist.


Error when open Excel Doc in TFS

For those who are getting error when open Excel documents stored on the Team Foundation Server (TFS). Courtesy from Poh Sze.

“TF84037: There was a problem initializing the Microsoft Excel Team Foundation Addin.  Re-installing the Team Foundation Client may be required.”

The reason is because the Office .Net programmability support is not installed.  You need to modify your installed version of Office and install this option.

1.  In Add/Remove programs, locate your Office application and select it.
2.  Click on the ‘Change’ button
3.  Select ‘Add or Remove features’ and click ‘next’
4.  Select ‘Choose advanced customization of applications’ and click ‘next’
5.  In the tree view, expand ‘Microsoft Office Excel’ and make sure the .NET Programmability Support option is set to ‘run from my computer’.
6.  Click ‘update’

DevTalk – Improving Software Quality

Apologies for not posting this up sooner. It has slipped my mind with all the deadlines that i need to catch.

Here’s the link to my slides for both session “Build Better Software – Code Performance” and “Governing Software Quality with Visual Studio Team System”

Link to my slides

In the link, you can also find an excel spreadsheet with some recommendation on Capacity Planning. This is courtesy from the ACE team. ACE team is

The ACE (Application Consulting & Engineering) Team is responsible for application performance, security & privacy engineering @ Microsoft.  Our mission is to drive application excellence into production by providing application engineering leadership through world class performance, security & privacy analysis services.

Here is also some great information on Performance Testing Guidance Patterns & Practices and a Quick Reference Guide on Testing with VSTS

Quick Test Reference for Visual Studio Team System

Finally you can get a cheat sheet on how to test in VSTS. Thanks to VSTS Rangers in providing a quick reference for the test features in VSTS.

This guide covers.

  • Setup Considerations
  • Web Test Considerations
  • Web Service Test Considerations
  • Unit Test Considerations
  • Load Test Considerations
  • Load Test Rig Consideration
  • Performance Data Collection And Usage
  • Load Test Results Store Information
  • Test Customization
  • Items Changed Or Fixed In Vsts 2008 Sp1
  • General Commands And Tricks (Not Vsts Specific)

Download it from

Microsoft Virtual Tech Days for Developers

Microosft Virtual Tech Days

What is it?
A 24 hour Virtual Event where you can learn about all different development technologies that Microsoft offers.

1st April, 2009


  • Windows Development and Frameworks
  • Windows Mobile Development
  • Office and SharePoint Development
  • Developer Tools, Languages & Practices
  • Web Development & User Experience

Get some details about the sessions here

Check it out at Microsoft Virtual Tech Days

DevTalk – Improving Software Quality

As promised here are the slides that I used in the presentation on how to improve software quality using Visual Studio Team System.

In this presentation, i have showcased how Code Analysis, Code Profiling, Loading Testing do wonders in helping you develop quality applications.


You can download my slides about Improving Software Quality. If you want to try out Visual Studio Team System 2008, try downloading the VSTS 2008 VPC.



Delete a project from Team Foundation Server

Deleting a project on Team Foundation Server is not that straight forward. Here’s how you can delete a team project

  1. Open the Visual Studio 2008 Command Prompt window.
  2. Change to the C:Program FilesMicrosoft Visual Studio 9.0Common7IDE directory. For example: cd "C:Program FilesMicrosoft Visual Studio 9.0Common7IDE"
  3. Run the TFSDeleteProject utility using the following command line. “TFSDeleteProject /server:YourServerName YourTeamProjectName”
  4. To confirm the deletion press Y and then press ENTER.

TFSDeleteProject utility then deletes the team project that you’ve selected

Visual Studio Flex Add On (Amethyst)

Received an email from Huw Collingbourne highlighting to me the availability of another Visual Studio Flex Add On.

For more information about this. Checkout the following sites:

In my previous post I’ve also blog about another add on

Check out the screenshots for the Amethyst add on

Flex Add On

Flex Add On

ALM Workshop – Slides

I presented in the Application Lifecycle Management Workshop on 18 Nov, Tuesday on “Governing Software Quality with Visual Studio Team System”.

Here are my slides



If you have a webpage still running on ASP, you can use this tool to check for SQL injections vulnerabilities. Microsoft Source Code Analyzer for SQL Injection