Learn more about SQL Server 2008 through these demos and videos.

http://www.microsoft.com/sqlserver/2008/en/us/demos.aspx

I found the Application Development Videos particularly useful.