Expanded Library

Practical SQL Server In-Memory OLTP Tables and Objects

by Russ Thomas

A practical approach to understanding the benefits and requirements of implementing in-memory OLTP tables, indexes, natively compiled stored procedures, and UDFs. This course also treats support, monitoring, and troubleshooting IMOLTP.

What you'll learn

In-memory OLTP objects have created some of the most drastic performance improvements of any SQL Server feature introduced to date. Further improvements from its initial "hekaton" release to the modern version of SQL Server makes this feature not only more robust, but puts this approach within reach of the every-day DBA and database developer. In this course, Practical SQL Server In-memory OLTP Tables and Objects, you will learn the foundational make-up of SQL Server in-memory objects and what you need to leverage these objects in your projects. You'll also learn to avoid pitfalls common to working with in-memory, as well as some of the myths surrounding in-memory objects, identifying where they do and do not offer a benefit. This practical approach focuses on real world usage but gives the user a moderately deep overview of internals as well. By the end of this course, you will understand what you need to implement in-memory objects and how they can benefit you.

Table of contents

About the author

Currently an IT leader in Denver Colorado's financial sector Russ has focused on database engineering, modelling, administration, and BI since 1997 across the Microsoft stack. Russ is a passionate trainer and SQL community volunteer presenting regularly at PASS SQL Saturday events and local user groups around the US. In 2019 much of Russ' focus turned to cloud based data lakes specifically on Google BigQuery.

Ready to upskill? Get started