In a project code-named Hekaton, Microsoft said it will be integrating in-memory capabilities across analytic and transactional scenarios into the database. As a result, Microsoft promises performance gains of about 50x.
There was not much detail on the technology itself other that it will be part of SQL Server and will not require customers to buy any specialized hardware to go along with this "SQL Server Next". In comparison to in-memory databases offered by its rivals, Microsoft will be highlighting cost-savings and reduced management that is delivered by the tight integration in its core database product.
There was no release date, even as Microsoft says that Hekaton is currently being tested by a few select partners. Meanwhile, the company publicly released the final version of SQL Server 2012 Service Pack 1 with support for PowerPivot and Power View analytics capabilities in Office 2013.
Wolfgang GruenerWolfgang Gruener is a contributor to Tom's IT Pro. He is currently principal analyst at Ndicio Research, a market analysis firm that focuses on cloud computing and disruptive technologies, and maintains the conceivablytech.com blog. An 18-year veteran in IT journalism and market research, he previously published TG Daily and was managing editor of Tom's Hardware news, which he grew from a link collection in the early 2000s into one of the most comprehensive and trusted technology news sources.
See here for all of Wolfgang's Tom's IT Pro articles.