- New high-availability options with AlwaysOn Availability Groups which allows you to use your disaster recovery (DR) environment for reporting or backup purposes.
- Database Recovery Advisor, which helps DBAs in creating a correct restore sequence using the new backup timeline dialog
- New performance records achieved - see SQL Server 2012 Performance Benchmarks and SQL Server 2012 RTM, sets performance records, offers increased ROI
- SQL Server 2012 includes new features for PowerPivot for SharePoint such as the ability to install a PowerPivot server outside of the SharePoint farm, PowerPivot gallery, scheduled data refresh and management dashboard. (See What’s New (Analysis Services) and Upgrade PowerPivot for SharePoint)
- A new version of the Reporting Services add-in for SharePoint products – the add-in can be installed as part of the SQL Server Installation Wizard but is also available as a separate download – Microsoft SQL Server 2012 Reporting Services Add-in for SharePoint Server 2010 .The new architecture is implemented as a SharePoint 2010 Service application – see What’s New (Reporting Services)
- BI Semantic Model – which is actually a combination of Analysis Services 2012 (supporting both the multidimensional model which was available in 2012 and the new tabular model) combined with the power of PowerPivot.
- Big Data support by providing bidirectional Hadoop connectors – check out SQL Server 2012 and Big Data presentation
- SQL Server 2012 Reporting Services introduces Power View, an interactive data exploration, visualization, and presentation experience which provides intuitive self-service reporting for business users against data exposed through the BI Semantic Model – see Channel 9 Exploring SQL Server 2012 Power View
For a full overview check out the SQL Server 2012 What’s new whitepaper