SQL Server 2014 New Features ★★★★★★★★★★★★★★★ Mike WilmotMay 2, 20141 Share 0 0 SQL 2014 New Features Mission Critical Memory-Optimized Tables Memory-optimized, integrated database engine. Updateable Clustered Columnstore Indexes Improve data compression and query performance for DW. AlwaysOn Enhancements Hybrid solutions & up to 8 replicas. Resource Governor Enhancements CPU, Memory and I/O gating. Buffer Pool Extension Improve I/O with SSD drives. New Design for Cardinality Estimation Query Plan quality based on predicting result set. Faster Insights Power BI Interactive dashboards and maps. Power Map & Power Query for Office 365 Geospatial and data movement functionality in Office 365. Power View Report for Multidimensional Model Create reports against multidimensional models. Hybrid Cloud Deploy a SQL Server Database to Windows Azure Virtual Machine Deploy & host a database in a Windows Azure VM. SQL Server Backup to URL Backup and restore to Windows Azure Blob storage.