I have read and seen a lot about the TFS Power Tools and I am finally getting a chance to install them and try them out.   The first tool I wanted to try was the Best Practices Analyzer.   The term Best Practices is rather vague so I didn't know what to expect in its findings.  To my surprise, this tool not only tested configuration and server requirement best practices, it also can do pre-requisite checks on servers before you install and it will also check for errors after you install TFS.  I have a virtual machine with TFS that I use for some prototyping.  I knew my virtual machine had a couple problems but the scan resulted in those and some additional ones I would have never known about. 

Here's the results of the scan. 

I noticed that this database was SUSPECT before I ran the scan.  I expanded it to display the details.  Not only does it show the details of the issue but you can also click on the the like to tell you more about the issue and how to resolved it.  I tried fixing this before through SQL Management Studio and the only I option I had was to restore from backup.   I was curious to see if it had any ideas.  When I clicked on the the link the explanation only talked about about single user mode and when the database is not online.   Unfortunately there was no magic answer for my problem on this one.  The other resolutions proved to be more useful.  Those solutions pertained to my issues.

Here's an example of the resolution

As you have seen this along with the other great tools including the Process Template editor, Build Notification Tool, TFS Users tool, etc is a must to download and utilize for your implementation of Team Foundation Server.

View and download the Visual Studio Team System 2008 Team Foundation Server Power Tools 

Mike