What new features are present in SQL Server Denali, R2, 2008

Do you know what features are introduced in 2008/R2/Denali (2011) ?

Is there a single url to check it out ?

Yea, Thanks to this post. This msdn blog is your one stop shop for all SQL Server versions/features to get started....

Features in SQL Server Denali - Please check whitepaper link
Denali Learning Series - Videos from Channel9 - link

Selected Interesting Videos on Denali features

• Columnstore Indexes Unveiled
• Full text Search in SQL Server 2008 and Denali
• The T-SQL Cookbook: What's Cool in Microsoft SQL Server 2008 R2 and New in SQL Server Code-Named "Denali"
• Microsoft SQL Server Code-Named "Denali" AlwaysOn Series,Part 1: Introducing the Next Generation High Availability Solution
• What's New in Microsoft SQL Server Code-Named "Denali" for SQL Server Analysis Services and PowerPivot 

Few more good sql learning resouces from the blog

• Queries with UPDLOCK hints on small tables causing blocking
• How to use SQLDiag, SQLNexus and PAL tools to analyze performance issues in SQL Server
• Notes - SQL Server Index Fragmentation, Types and Solutions

Happy Learning!!!