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.

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.

• Introduction to In-Memory Use Cases 12mins
• Understanding In-Memory Tables 36mins
• Reducing Latency with In-Memory Tables in New and Existing Work 29mins
• Improving Query Performance with In-Memory Indexes 38mins
• Gaining Complete Memory Efficiency with Natively Compiled Objects 30mins
• Analyzing and Monitoring Your In-Memory Solution 23mins