The DBA Fundamentals VG offers training and support to individuals interested in a solid DBA foundation.

Sign in to Subscribe

Meeting Details
In-memory OLTP – the ultimate performance frontier

Tue, Nov 11 2014 17:00 UTC

In-memory OLTP – the ultimate performance frontier

In-memory OLTP is a radical new, in-memory technology integrated into SQL Server 2014. This is one of the most exiting technologies for SQL Server in the past 20 years. It has been the cause for much buzz, as is typically the case with disruptive technologies. A lot of misconceptions and hopes have been published and discussed about it. In this session we will introduce the concepts that drove the design of the in-memory OLTP engine. We will learn about its strengths and shortcomings, what is missing in this current release and as important - what NOT to expect from it. We will explore several architectural patterns that were found to benefit the most from migration to in-memory OLTP and understand why. We will also explore some scenarios which are less suited for migration and discuss some migration considerations.


Ami Levin

Ami is a data nerd that has been designing, consulting, training, writing, and speaking about SQL, relational modeling, and data platform architecture for more than 20 years. Currently works as a senior online SQL instructor at O'Reilly Media, Pluralsight author, and part time mentor.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids