Featured resource
pluralsight tech forecast
2025 Tech Forecast

Which technologies will dominate in 2025? And what skills do you need to keep up?

Check it out
Hamburger Icon
  • Course
    • Libraries: If you want this course, consider one of these libraries.
    • Data

Practical SQL Server In-Memory OLTP Tables and Objects

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.

Russ Thomas - Pluralsight course - Practical SQL Server In-Memory OLTP Tables and Objects
by Russ Thomas

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

Russ Thomas - Pluralsight course - Practical SQL Server In-Memory OLTP Tables and Objects
Russ Thomas

Currently an IT leader in Denver Colorado's financial sector Russ has focused on database development, 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.

More Courses by Russ