Scott Guthrie recently provided a demo on what excites him most about Visual Studio 2008 (code named "Orcas"). You can now find his demos at http://msdn2.microsoft.com/en-us/vstudio/bb655906.aspx.
On this site you can find Scott’s demo as well as more training videos from TechEd and other events. Check them out!.
And if you want more, Soma posted some “how do I” videos on his blog a few weeks ago and those can be found at http://blogs.msdn.com/somasegar/archive/2007/06/29/helping-developers-with-how-do-i-information.aspx.