SQL Server 2012 will provide mission critical confidence with greater uptime, blazing-fast performance and enhanced security features for mission critical workloads; breakthrough Insight with managed self-service data exploration and stunning interactive data visualizations capabilities; cloud on your own terms by enabling the creation and extension of solutions across on-premises and public cloud.
User-defined server roles
Easily manage permissions around data access to support separation of duties and enable compliance around strict data access policies.
Simplify application testing and help minimize errors with production-like application testing and configuration changes, and upgrades.
SQL server data tools
Take database development to the next level with SQL server data tools an integrated development experience for database and BI.
Greater uptime and recovery
Reduce OS patching by as much as 50-60% with more support for Windows Server Core. Meanwhile, database recovery advisor introduces significant user experience enhancements to the ways DBAs can restore databases using SQL Server Management Studio.
Simplify application testing and minimize errors on a single database with application changes, configuration changes, and upgrades using distributed replay. Meanwhile, updated management packs for system center operations manager help IT centrally manage their infrastructure.
More easily integrate data
More easily integrate data from multiple disparate sources with enhancements to Integration Services which include rich DBA and IT Implementer support for the deployment and administration of ETL tasks, including better tracking of SSIS packet status, run SSIS as a server, and the ability to run administration and other capabilities as a separate SQL server instance.
Rich support for content
SQL Server 2012 makes it easier to manage content as an integrated part of an application. FileTable makes it easier to manage content into file stream blob storage with standard tools and applications. Improvements to full-text indexing help yield better performance and search functionality.