SQL Server 2012 new features
- Achieve a variety of high-availability levels with AlwaysOn
- Ultra-fast queries with Columnstore indexing technology, with star-linked queries and similar queries capable of up to 100 times faster performance, while supporting ultra-fast full-text queries
- Enable fast data discovery with power view and PowerPivot. Power view provides Web-based, high-speed, interactive drag-and-drop data query and data visualization capabilities, with the ability to quickly analyze large-scale data using the PowerPivot plugin in Excel with regular analysis
- Ensure data reliability and consistency through BI semantic layer models and data quality services
- Freedom to scale as needed between stand-alone devices, data centers, and the cloud
- Enables applications to run in any environment with SQL Server Data tools only once written
- Added functionality to support Windows Server core, which greatly reduces the need to install updated OS patches
- The active secondary feature balances some workloads to active standby node instances to take advantage of the ability to scale hardware horizontally and improve IT investment utilization and application performance
- Maximize system uptime with enhanced online operations capabilities and minimize planned downtime with live migration (live migration) technology from Hyper-V
- Simplifies deployment and management of high-availability solutions with integrated configuration and monitoring tools
- Compression reduces 50-60% of data volume storage, speeding up I/O in high-load conditions, dramatically improving performance
- The resource governor (Resource Governor) feature allows you to define different resource usage thresholds for different applications, thus ensuring high performance for SQL Server in concurrent and mixed load scenarios
- Server role customizations, built-in services are turned off by default (the required services can be turned on by Configuration Manager), built-in it controls, Contained Database authentication, built-in encryption capabilities, Auditing capabilities and default schema for Groups features, built-in security features and IT management capabilities to help businesses improve security levels and achieve compliance management
- Provide access to intelligent services across business organizations through collaboration between self-service bi, it dashboards, and SharePoint
- Master Data Services (MDS) can be used to create, maintain, store, and access a master structure for object mapping, reference data, and metadata management. Also, the new MDS plug-in embedded in Excel makes it easier to manage and maintain core data
- Deliver large-scale DW at low cost with a full range of DW solutions for high flexibility and scalability
- The ability to quickly create and extend business solutions from servers to private or public clouds, exactly as you want them
- With easy-to-scale development technology, you can scale your data anywhere on the server or in the cloud. SQL Azure Data Sync provides two-way data synchronization between the data center and DB in the cloud, and OData provides consistent, open data feeds, and by using any of the API standards (ADP.NET,ODBC, Jdbc,pdo,ado), you can cross-include. NET, A variety of platforms, including C + +, Java, and PHP, connect to SQL Server and SQL Azure applications to extend heterogeneous environments.
SQL Server 2014 new features
Http://www.cnblogs.com/lyhabc/archive/2015/01/13/4220459.html
Different versions of SQL Server
