Friday, May 16, 2014

SQL Server 2014 Launch Update in DC

For those who missed the event will re-publish Microsoft slides here:

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
Larger SQL Server VMs and memory sizes now available in Windows Azure