This summer we started blogging about all of the innovation in the products that make up the Microsoft Cloud OS vision. We’ve talked about Windows Server 2012 R2, Windows Azure and of course Microsoft SQL Server 2014.
In the case of SQL Server 2014, we did a series of posts over the past few months on In-Memory OLTP. SQL Server 2014 introduces memory-optimized database technology for optimizing the performance of OLTP workloads. In particular, it introduces memory-optimized tables for efficient, contention-free data access, and natively compiled stored procedures for efficient execution of business logic.
Sound interesting? There is a lot to learn so here is the complete list of those posts in the series:
- SQL Server 2014 In-Memory Technology Blog Series Introduction
- Getting Started with SQL Server 2014 In-Memory OLTP
- In-Memory OLTP: Q & A Myths and Realities
- Architectural Overview of SQL Server 2014’s In-Memory OLTP Technology
- SQL Server 2014 In-Memory OLTP bwin Migration and Production Experience
- Hardware Considerations for In-Memory OLTP in SQL Server 2014
- How In-Memory Optimized Database Technology is Integrated into SQL Server 2014
- SQL Server 2014 In-Memory OLTP App Migration Scenario Leveraging the Integrated Approach
- Improved Application Availability During Online Operations in SQL Server 2014
- Solving Session Management Database Bottlenecks with In-Memory OLTP
- New AMR Tool: Simplifying the Migration to In-Memory OLTP
- In-Memory OLTP Common Design Pattern – High Data Input Rate/Shock Absorber
- In-Memory OLTP Programmability: Concurrency and Transaction Isolation for Memory-Optimized Tables
- Concurrency Control in the In-Memory OLTP Engine
- Troubleshooting Common Performance Problems with Memory-Optimized Hash Indexes
- In-Memory OLTP: How Durability is Achieved for Memory-Optimized Tables
Since SQL Server In-Memory OLTP (formerly known as project code-named “Hekaton”) was unveiled at PASS last November, there has been a lot of conversation and buzz about it. Some of the discussion was well informed and accurate, and some… not so much. We hope you find the list above and the information in those posts informative.
Stay tuned for more information coming out of PASS Summit 2013. We’ll certainly be sharing more on In-Memory OLTP and other innovations in SQL Server 2014, and we have many more blogs to come on the new features of SQL Server 2014!
Ready to download and try it for yourself? Be sure and head over to the Try/Buy Center and take a lab or download the bits. For one stop shopping on evaluation bits for all of the Microsoft products, head on over to the TechNet Evaluation Center. Enjoy!