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
for SQL Server
o Larger
SQL Server VMs and memory sizes now available in Windows Azure
Comments
Post a Comment
Hi User,
Thanks for visiting My Blog and please provide your valuable feedback and subscribe for more updates. Please don't post any spam content or comments.
Thank You