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

 

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.

Comments

• Anonymous
  December 22, 2014
  I really loved all the new features, you can also check this list with great info in it, some even cover specifics on how to implement each feature sqlturbo.com/sql-server-2014-top-8-new-features