What’s New in SQL Server 2014 since SQL Server 2008 R2
PERFORMANCE & SCALE
o In-Memory OLTP
o Enhanced In-Memory ColumnStore for DW
o Support for 640 logical proc. & 4 TB memory
o Support to 15,000 partitions
o Resource Governor IO governance
o Buffer Pool Extension to SSDs
o Query optimization enhancements
o SysPrep at cluster level
o Predictable performance with tiering of compute,
network, and storage with Windows Server 2012 R2
HIGH AVAILABILITY
o SQL Server AlwaysOn
o Delayed Durability
o Recovery Advisor
o Windows Server Core
o Live Migration
o Online Operations enhancements
o Clustered Shared Volume support, VHDX support (Windows
Server 2012 R2)
o Manage on-premises and cloud apps (System Center 2012
R2)
SECURITY
o User-Defined Server Roles
o Default Schema for Groups
o SQL Server Audit
o SQL Server Fine-grained Auditing
o Enhanced separation of duty
o CC certification at High Assurance Level
o Backup encryption support
PROGRAMMABILITY
o SQL Server Data Tools
o Local DB runtime (Express)
o Data-tier Application Component project template
o Data-Tier Application Framework (DAC Fx)
o Query optimization enhancements
o Interoperability support (ADO.NET, ODBC, JDBC, PDO,
ADO APIs and .NET C/C++, Java, Linux, and PHP platforms)
T-SQL ENHANCEMENTS
o Enhanced support for ANSI SQL standards
o Transact-SQL Static Code Analysis tools
o Transact-SQL code snippets
o Intellisense
o Unstructured & Complex Data Support
o FileTable built on FILESTREAM
o Remote Blob Storage with SharePoint 2010
o Statistical Semantic Search
o Spatial features, including Full Globe & arcs
o Large user-defined data types
MANAGEABILITY
o Distributed Replay
o Contained Database Authentication
o System Center Management Pack for SQL Server 2012
o Windows PowerShell 2.0 support
o Multi-server Management with SQL Server Utility
Control Point
o Data-Tier Application Component
ACCESS ANY DATA
o Power Query
o Windows Azure HDInsight Service
o Analytics Platform System (PDW V2)
o Mash up data from different sources, such as Oracle
& Hadoop
INSIGHTS WITH FAMILIAR
TOOLS
o Power BI in Office 365
o Power Map for Excel
o Mobile interfaces for Power BI
COMPLETE BI SOLUTION
o SQL Server BI Edition
o HA for StreamInsight, complex event processing
o BI Semantic Model
o SQL Server Data Tools support for BI
o Change Data Capture for Oracle
ANALYSIS SERVICES
o Import PowerPivot models into Analysis Services
o Enhancements on productivity, performance
REPORTING SERVICES
o Power View
o Configurable reporting alerts
o Reporting as SharePoint Shared Service
o Report Builder 3.0
DATA QUALITY SERVICES
o Build organizational knowledge base
o Connect to 3rd party data cleansing providers
MASTER DATA SERVICES
o Master Data Hub
o Master Data Services Add-in for Microsoft Excel
INTEGRATION SERVICES
o Graphical tools in SSIS
o Extensible object model
o SSIS as a Server
o Broader data integration with more sources; DB
vendors, cloud, Hadoop
o Pipeline improvements
HYBRID CLOUD SOLUTIONS
o Simplified backup to Windows Azure
o Support for backup of previous versions of SQL Server
to Windows Azure
o Cloud back-up encryption support
o Simplified cloud Disaster Recovery with AlwaysOn
replicas in Windows Azure VMs
EASY ON-RAMP TO THE CLOUD
o New Windows Azure Deployment UI for SQL Server
o Larger SQL Server VMs and memory sizes now available
in Windows Azure
o DAC enhancements: Import/export with Windows Azure SQL
Database
COMPLETE AND CONSISTENT FROM ON-PREM TO CLOUD
o SQL Server Data Tools
o License Mobility (with SA)
o Resource Governor enhancements
o Snapshot backups to Windows Azure via SQL Server
Management Studio