Launch Event
Why to Upgrade to SQL Server 2014
What’s New in SQL Server 2014
since SQL Server 2012
Mission Critical Performance
|
|
PERFORMANCE & SCALE
In-Memory OLTP
Enhanced In-Memory ColumnStore
for DW
Buffer Pool Extension to SSDs
Enhanced Query Processing
Resource Governor adds IO governance
SysPrep
at cluster level
Predictable performance with tiering
of compute, network, and storage with Windows Server 2012 R2
HIGH AVAILABILITY
Enhanced AlwaysOn,
with 8 secondaries
and Replica Wizard
Delayed
Durability
Clustered Shared Volume support, VHDX
support (Windows Server 2012 R2)
Manage on-premises and cloud apps (System Center 2012 R2)
SECURITY
Enhanced separation of duty
CC certification at High Assurance Level for 2014
Backup encryption support
PROGRAMMABILITY
Query optimization enhancements
|
Faster Insights from Any Data
EASY
ACCESS TO DATA, BIG & SMALL
Power
Query
Windows
Azure HDInsight Service
Analytics
Platform System (PDW V2)
POWERFUL
INSIGHTS WITH FAMILIAR TOOLS
Power
BI in Office 365
Power
Map for Excel
Mobile
interfaces for Power BI
Platform for Hybrid Cloud
HYBRID
CLOUD SOLUTIONS
Simplified
backup to Windows Azure
Support
for backup of previous versions of SQL Server to Windows Azure
Cloud
back-up encryption support
Simplified
cloud Disaster Recovery with AlwaysOn replicas in Windows Azure VMs
EASY
ON-RAMP TO THE CLOUD
New
Windows Azure Deployment UI
for SQL Server
for SQL Server
Larger
SQL Server VMs and memory sizes now available in Windows Azure
