Last week, company officials reconfirmed plans to incorporate in-memory OLTP -- via a new engine codenamed "Hekaton" -- in the the next version of SQL Server, known officially as SQL Server 2014. But they also expanded on some of the other features that will be in the coming release.
The Hekaton in-memory capabilities are being design to complement the existing in-memory data-warehousing and business-intelligence (BI) capabilities already in SQL Server, officials said during TechEd last week.
Officials reiterated that even though Microsoft is changing the core engine, the Hekaton technology will continue to work with traditional SQL Server tables, so that users will see performance gains even on existing hardware.
With SQL Server 2012, Microsoft introduced new column store capabilities into its database. But that column store was an in-memory index. With SQL Server 2014, this column store becomes updatable with faster query speeds and greater data compression, yielding more real-time analytics processing capabilities.
SQL Server 2014 also will include new buffer-pool-extension support for solid-state drives, enabling faster paging. Microsoft is enhancing its "AlwaysOn" technology, also introduced with SQL Server 2012, so that it delivers "mission-critical" availability, with up to eight readable secondaries and no down time during online indexing.