New AMR Tool: Simplifying the Migration to In-Memory OLTP 

4 min read

As we have addressed in previous blog articles, the transition into SQL Server In-Memory OLTP is not as simple as flipping a switch. One of the design principles of In-Memory OLTP is that you would only need to make surgically precise migrations for your app to reap the most benefit from In-Memory OLTP for the Read more

10 Comments

How Memory-Optimized Database Technology is Integrated into SQL Server 2014 

4 min read

SQL Server 2014 takes an integrated approach to in-memory database technology. In-Memory OLTP, which optimizes performance of OLTP workloads, is fully integrated in the core SQL Server relational database management system. Now, what do we mean by “fully integrated”? In this post we highlight some of the aspects that demonstrate: Installation No special steps are Read more

10 Comments

Hardware Considerations for In-Memory OLTP in SQL Server 2014 

3 min read

In-Memory OLTP uses memory and disk in different ways than traditional disk-based tables. The  performance improvement you will see with In-Memory OLTP depends the hardware you use. In this blog post we discuss a number of general hardware considerations, and provide generic guidelines for hardware to use with In-Memory OLTP. CPU In-Memory OLTP does not Read more

15 Comments

Architectural Overview of SQL Server 2014’s In-Memory OLTP Technology 

6 min read

At the SQL PASS conference last November, we announced the In-memory OLTP database technology (code-named “Hekaton”) for a future SQL Server release. Microsoft’s technical fellow Dave Campbell’s blog provided a broad overview of the motivation and design principles behind the technology and discussed four architectural principles: (1) optimize for main memory data access, (2) Accelerate Read more

8 Comments

In-Memory OLTP Q & A: Myths and Realities 

3 min read

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. With this series, and with online documentation at http://technet.microsoft.com/en-us/library/dn133186(v=sql.120).aspx, we will be giving Read more

11 Comments

‘Wicked Fast’–Real World Experience with SQL Server 2014 In-Memory OLTP 

1 min read

Recently Quentin Clark announced SQL Server 2014 during TechEd North America. One of the key features to be announced was the in-memory online transaction processing (OLTP) engine, which would complement the in-memory technologies which have been available in the data warehouse and analytics engines in SQL Server 2012, and integrated into PowerPivot in Excel 2013. Read more

2 Comments

SQL Server 2014 In-Memory Technologies: Blog Series Introduction 

4 min read

At the SQL PASS conference last November, we announced the In-memory OLTP (project code-named Hekaton) database technology built into the next release of SQL Server. Microsoft’s technical fellow Dave Campbell’s blog provides a broad overview of the motivation and design principles behind this project codenamed In-memory OLTP. In a nutshell – In-memory OLTP is a Read more

11 Comments

How Fast is Project Codenamed “Hekaton” – It’s ‘Wicked Fast’! 

1 min read

Recently I posted a video about how the SQL Server Community was looking into emerging trends in BI and Database technologies – one of the key technologies mentioned in that video was in-memory. Many Microsoft customers have been using in-memory technologies as part of SQL Server since 2010 including xVelocity Analytics, xVelocity Column Store and Read more

3 Comments

Oracle Surprised by the Present 

3 min read

I’d like to clear up some confusion from a recent Oracle-sponsored blog. It seems we hit a nerve by announcing our planned In-Memory OLTP technology, aka Project ‘Hekaton’, to be shipped as part of the next major release of SQL Server. We’ve noticed the market has also been calling out Oracle on its use of Read more

24 Comments