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


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: http://download.microsoft.com/download/8/4/F/84F00BE4-DAFE-4BA4-92AC-5D1080127984/SQL_Server_2014_CTP1_Product_Guide.zip

Comments (3)

  1. ArthurZ says:

    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).

  2. ggvsd says:

    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

  3. Laurie says:

    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

Skip to main content