SQL 2014 Preview announced at TechED

  • Article

In case you missed it this week and I doubt you did, it was announced at TechED that SQL 2014 will be available for preview the end of this month (June). The biggest most interesting feature for me is In Memory OLTP, of which I am happy to share the first white paper has been published by Kalen Delaney; SQL Server In-Memory OLTP Internals Overview for CTP1. There will be much more to come around this topic, so stay tuned.

For a video from TechED of all the new stuff look no further than here

 

Other items you will be interested in and can read more about in SQL Server Mission Critical Performance White Paper below are just a few of the highlights with some of the presentations form TechED.

  1. In memory OLTP– There were sevaral presentations from TechED o
    1. http://channel9.msdn.com/Events/TechEd/NorthAmerica/2013/DBI-B204#fbid=SJOEd0JGOzH
  2. SQL Server AlwaysOn support for up to 8 Secondary’s
  3. SQL Server AlwaysOn to Windows Azure Virtual Machine
    1. https://channel9.msdn.com/Events/TechEd/NorthAmerica/2013/DBI-B306#fbid=SJOEd0JGOzH
  4. Online Index Rebuild for single partition
  5. Online lock priorities for partition index and switch operations
  6. Updateable ColumnStore Index
    1. https://channel9.msdn.com/Events/TechEd/NorthAmerica/2013/DBI-B322#fbid=SJOEd0JGOzH
  7. SSD Buffer Pool Extension. 
  8. Improvements in Cardinality estimation and statistics
  9. Parallel Select into
  10. 10. Resource Governor for IO

 

Microsoft unveils what’s next for enterprise IT 

SQL Server In-Memory OLTP Internals Overview for CTP1 

Mission Critical Performance & Scale with SQL Server and Windows Server SQL Server 2014