SQL Server 2014 and in-memory database processing

Posted: (EET/GMT+2)

 

There were plenty of great announcements from the cloud to mobile devices to servers in the TechEd 2013 event that was held in from 3rd to 6th this month in New Orleans. One of these interesting topics discussed (or announced, rather) was the forthcoming version of SQL Server, named SQL Server 2014.

Among with tons of other improvements, I find the support for in-memory databases the most interesting of all these new features. Called In-Memory OLTP (codename "Hekaton"), the promise is to load a database (or parts of it, anyway) in memory, and thus dramatically improve performance of both queries and data updates. OLTP stands for On-Line Transaction Processing.

In case you are interested, here's a nice datasheet available on the forthcoming new version.

Waiting for the trial to become available!