A new whitepaper has just posted on MSDN called What Microsoft Visual Studio 2005 Team Edition for Database Professionals Can Do for You

Rob Caron talks a little more about this in his Blog

Despite having been written for CTP 4 it still applies in the most part to CTP 5