Microsoft TechNet has a Webcast called "SQL Server Code Name "Katmai" Data Management Overview" that gives a good high level summary of some of the new features in SQL Server 2008 (a.ka. "Katmai".)

Microsoft has a product overview white paper about SQL Server 2008 posted here.