If you are interested in taking a look at the latest and greatest…Denali is found here: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=6a04f16f-f6be-4f92-9c92-f7e5677d91f9
Column based query acceleration is greatly improved. Computed values and aggregates are calculated much, much faster (at least by a factor of 10 according to Microsoft).
Improved performance for FileStream. FileStream was a technology that was introduced in SQL Server 2008.
BI has also been greatly improved with a lot more functionality.
Better programming interfaces.
A workflow approach has been included for better integration.
It now uses Visual Studio 2010 for its interface!
There is now an actual dashboard that is more responsive, a nice bell or whistle (whichever you prefer).
The official Microsoft page for all future versions of SQL Server is here: