The latest Community Technology Preview (CTP) for SQL Server 2008 R2 is now available
Some of the new capabilities added to SQL Server in this release are:
- improved support for virtualization through Hyper-V with Live Migration in Windows Server 2008 R2
- enhanced data compression with support for Unicode UCS-2.
- New visualization features and a Report Part Gallery to Report Builder 3.0
As mentioned on the site - "SQL Server 2008 R2 includes enhancements designed to help administrators centrally monitor and manage multiple database applications, instances or servers. In addition, it has enabled high-scale complex event-stream processing through SQL Server StreamInsight, and expanded business intelligence capabilities with SQL Server PowerPivot for Excel"
You can download Community Technology Preview of Microsoft SQL 2008 R2 over here