Visual Studio 2005 Team System
I watched Visual Studio Team System end-to-end demo given at TechEd 2004 and found it to be very informative on how Unit, Web, Load and Manual Testing has been integrated into Visual Studio. I also learned that Compuware's TestPartner which is a functional testing tool can be integrated into Visual Studio 2005 Team System. The video is fairly lengthy but well worth watching.