In TFS you can create your own reports based on the Analysis warehouse. In order to be able to query the cube, you need to use the MDX language. This language is not very intuitive for someone who is used to query transactional databases, since you now have to deal with cubes, slices, facts and meas... [More]

Reporting (SSRS and Excel) in TFS makes use of Sql Server Analysis Server, or OLAP cube. This cube is by default refreshed every two hours. This is in most cases frequently enough to get the correct information. You can however change this default behaviour. You can either change the interval of the... [More]

In Visual Studio 2008, Microsoft has added the code metrics, which gives you information about the quality and maintainability of the application. Unfortunately you can not easily start the code metrics automically, and you can not integrate it from Team Build. There is NDepend, which has the abili... [More]

A lot of software shops want to use TFS as the time tracking tool. Out of the box, TFS does not provide this information, because all time is entered cumulative per work item. But you can find the information when you look at the transaction database table where all the changes to the work items are... [More]

A frequently heard complaint about using the time fields in the work item is that there is already another system in the organization to enter the working hours in. Using the time fields in the work item would mean a double time management system, which can be out of sync. To come around this, I cr... [More]

When you develop a new report for TFS and you want to deploy the report to all team projects, you have to do a lot of work to upload the file and to set the datasources. This post uses TFS 2008 and SQL Server 2005 There is an easy way to automate that. 1. Add the web service to Reporting Ser... [More]

It is possible to add a SSRS report to your Project Portal. In this way you can create a nice dashboard on you portal home page. This dashboard can consist of multiple reports, or can vary for the different roles in your team. On the Site Actions menu, choose the Edit Page action Click on Add a ... [More]

Introduction In Team Foundation Server 2005 and 2008 it is possible to define links between work items. By doing this, you can imply a work breakdown for your project. This work breakdown is not explicit, since these links are not hierarchical. Therefore is the only report in TFS that does somethin... [More]