This nice video has people giving their comments on their favourite features of SQL Server 2012.