TFS2010: Diagnosing Email and SOAP subscription failures

Sometimes emails alerts such as “Work Item Changed” will fail to send.  Sometimes SOAP (web service) subscriptions will not be called correctly. See Chris Sidi’s blog for an overview of the TFS Job Agent service  To diagnose these, you can look in the tbl_JobHistory table in the Tfs_Configuration database. If you run this SQL command,…


TFS2010: SQL Queries for TFS Statistics

Brian has been posting TFS statistics from the Developer Division dogfood TFS server for many years.  I’ve updated the queries from TFS2008 to work with Team Foundation Server 2010 Beta 2. Here are the statistics for the TFS2010 Beta 2 server that we have been using internally since August 2009.  VSTS Pioneer TFS2010 Dogfood Server:…


VSTS Pioneer TFS2010 Dogfood Server: Upgrading

(See this summary on the VSTS Pioneer dogfood server and all the other posts.) One of the major goals of the Pioneer Team Foundation Server is to upgrade it to early builds so that we can get some “bake time” with them and feel confident with what we’re releasing to customers.  Since we spun up…


VSTS Pioneer TFS2010 Dogfood Server: Statistics September 2009

(See this summary on the VSTS Pioneer dogfood server and all the other posts.) September was a busy month for dogfooding TFS – all of the VSTS team were completely moved across and on 9/17 we upgraded to an almost final TFS2010 Beta 2 build. Here are the numbers from the end of September: Recent…


TFS2010: Installing pre-requisites from the command line

On the Team Foundation Server team, there is a new build of the server every night that comes out of our build lab. These vary in quality throughout the development cycle and the QA teams look at them and rate them as “Self Test”, “Self Test (with workarounds)”, or “Self Toast”.  The QA & dev…