This guy has a great blog article on high availability on the latest version of SQL Server. I highly recommend reading it. Unlike previous versions, you can query all the nodes and you aren’t limited to a two node configuration like before! I have another article, a very terse one, here: http://wp.me/p175D9-3o
Reblog is awesome! It is very easy to use!
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: