What’s
New in SQL Server 2014 since SQL Server 2012
PERFORMANCE & SCALE
o In-Memory
OLTP
o Enhanced
In-Memory ColumnStore for DW
o Buffer
Pool Extension to SSDs
o Enhanced
Query Processing
o Resource
Governor adds IO governance
o SysPrep
at cluster level
o Predictable
performance with tiering of compute, network, and storage with Windows Server
2012 R2.
HIGH AVAILABILITY
o Enhanced
AlwaysOn, with 8 secondaries and Replica Wizard
o Delayed
Durability
o Clustered
Shared Volume support, VHDX support (Windows Server 2012 R2)
o Manage
on-premises and cloud apps (System Center 2012 R2)
SECURITY
o Enhanced
separation of duty
o CC
certification at High Assurance Level for 2014
o Backup
encryption support
PROGRAMMABILITY
o Query
optimization enhancements
EASY ACCESS TO DATA, BIG & SMALL
o Power
Query
o Windows
Azure HDInsight Service
o Analytics
Platform System (PDW V2)
POWERFUL INSIGHTS WITH FAMILIAR TOOLS
o Power
BI in Office 365
o Power
Map for Excel
o Mobile
interfaces for Power BI
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
This list also includes
some technologies that work together with SQL Server such as Azure, System
Center, Excel 2013, Power BI for Office 365 and others.