SQL Server Features and Components

SQT05 SQL Server 2014: A First Look at Whats New!

11/19/2013

11:00am - 12:15pm

Level: Intermediate to Advanced

Bradley Ball

Sr. Consultant – Premier Support for Developers

Microsoft

Microsoft has announced that the next version of SQL Server will be SQL Server 2014. SQL Server 2012 had some major upgrades in AlwaysOn Availability Groups, ColumnStore Indexes, and Resource Governor Caps. SQL 2014 takes those features to the next level and introduces a whole lot more! Rebuild Indexes and Statistics by Partition? Yes! A new Optimizer/Cardinality Estimator that you can choose for your Queries? Yes! Hekaton in memory data tables that exist separate to the buffer pool and use HASH indexes instead of B-TREE? YES! Plus SSD Buffer Pool Extensions, Read-Write ColumnStore Indexes and much more!

You will learn:

  • What the new version of SQL Server 2014 will have as available features.
  • A very solid understanding of What is currently available for testing in current CTP's and what we can expect in the future
  • Hekaton and the architectural changes it will bring to SQL Server