The DBA Fundamentals VC offers training and support to individuals interested in a solid DBA foundation.
Meeting Detail

Tue, Nov 11 2014 11:00 (GMT-06:00) Central Time (US & Canada)

In-memory OLTP – the ultimate performance frontier


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 is a Microsoft SQL Server MVP since 2006, with over 25 years of experience in development and IT. For the past 14 years, he has been consulting, teaching, writing, and speaking about SQL Server worldwide. Ami's areas of expertise are data modeling, database design, T-SQL, and performance tuning.