Share via

What’s new in SQL Server 2014 (CTP1)?

  • Article

The release of SQL Server 2014 (CTP1) has brought good amount of new features and enhancements. Some of the notable features are presented below.

  • Database Engine Enhancement:
    • In-Memory OLTP for ~10X performance gains by moving most used tables into memory.
    • Updatable and clustered column store indexes for faster retrieval.
    • Enhanced query processing for better performance without app changes.
    • Buffer Pool extension to SSDs for faster paging.
    • Resource Governor controls IO along with CPU and memory.
    • Enhanced Always On now supports 8 secondary for better HA (High Availability)
  • Business Intelligence Enhancement:
    • Power Query (formally codename “Data Explorer”) in Excel makes easy to access Internal and External data (both Relational and Non-Relational).
    • Power Map (formally codename “Geo Flow”) in Excel can be used to get insights with 3D visualization.
    • Parallel Data Warehouse with Polybase to support querying Big Data with T-SQL.
  • Cloud support Enhancement:
    • Simplified cloud Backup and Deployment lets you Backup and Restore from SQL Azure/Windows Azure VM to SQL Server and vice-versa.
    • HA/Always On in Azure helps to handle disaster recovery.

What's you most favorite feature :) let me know.. 

Reference: https://download.microsoft.com/download/8/4/F/84F00BE4-DAFE-4BA4-92AC-5D1080127984/SQL_Server_2014_CTP1_Product_Guide.zip

Comments

  • Anonymous
    August 29, 2013
    Mine is the in-memory OLTP AKA Hekaton; it comes out just at the right time when the key-value stores are gaining traction. However I wish the feature would not be as limited (for an exhausted list of features and nuances see an excellent white paper by Kalen Delaney http://goo.gl/v9foH).

  • Anonymous
    April 09, 2014
    SELECT    db_name(ps.database_id)AS'Database Name',    object_name(ps.OBJECT_ID)AS'Database Object',    ps.index_id,    b.name,    ps.avg_fragmentation_in_percent FROMsys.dm_db_index_physical_stats(DB_ID(),NULL,NULL,NULL,NULL)ASps INNERJOINsys.indexesASbONps.OBJECT_ID=b.OBJECT_ID ANDps.index_id=b.index_id WHEREps.database_id=DB_ID() ORDERBY    ps.avg_fragmentation_in_percentDESC GO

  • Anonymous
    December 22, 2014
    I really loved all the new features, you can also check this SQL Server 2014 new features 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