In-Memory Computing and in-memory Data: Future of SQL Server

In-Memory Computing and in-memory Data: Future of SQL Server

Earlier this year, Microsoft announced SQL Server 2012 and today Microsoft announced SQL Server 2012 SP1. But beyond that, Microsoft is showcasing what is coming next in its data storage chapter.

Microsoft is calling it in-memory computing and in-memory data that will speed up the performance of data up to 50 times.

In a blog posted by Ted Kummert, Corporate Vice President of Microsoft’s Business Platform Division talks about new SQL Server.

“In-memory computing is a core element of Microsoft’s strategy to deliver a data platform that enables customers to analyze all types of data while also accelerating time to insight. Our approach to in-memory computing is to provide a complete portfolio for all application patterns, built into our existing products that enable rapid insights on any data, structured or unstructured. We’ve been delivering advanced in-memory technologies as part of SQL Server since 2010. Since then, we have shipped more than 1.5 million units to customers, making it the most pervasive data platform of its kind with in-memory technologies built in.

Furthering Microsoft’s commitment to deliver in-memory solutions as part of our data platform, today we are introducing Project codenamed “Hekaton,” available in the next major release of SQL Server. Currently in private technology preview with a small set of customers, “Hekaton” will complete Microsoft’s portfolio of in-memory capabilities across analytics and transactional scenarios. It will provide breakthrough performance gains of up to 50 times, and because it will be built into SQL Server, customers won’t need to buy specialized hardware or software and will be able to easily migrate existing applications to benefit from the dramatic gains in performance.”