SQL Server 2014 New Features

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