http://msdn.microsoft.com/vstudio/default.aspx?pull=/library/en-us/dnvs05/html/TEDBPro.asp

What Microsoft Visual Studio 2005 Team Edition for Database Professionals Can Do for You

 

Check out this paper - it's a good overview at the 20,000 foot level of the product...