Boost SQL Server Database Performance with In-Memory OLTP

In this course you will learn all about SQL Server’s In-Memory Database Processing Engine also known as In-Memory OLTP. To this end, you will learn how to enable In-Memory OLTP in SQL Server, what memory-optimized tables and natively-compiled stored procedures are, as well as, how to boost the performance of your data processes using this powerful SQL Server feature.

In-Memory OLTP, is SQL Server’s Database In-Memory Processing Engine, seamlessly integrated into its Database Engine. With its two main components, that is memory-optimized tables and natively-compiled stored procedures, In-Memory OLTP can help you achieve significant performance improvements and speedups for many of your data processes.

In-Memory OLTP was originally shipped with SQL Server 2014 but was significantly enhanced in SQL Server 2016 and later. From SQL Server 2016 SP1 and later, In-Memory OLTP is available for use in all editions of SQL Server (besides the LocalDB edition), which is something that makes it a must, to at least try this great feature in SQL Server.

Especially now, in this data-driven era we live in, where business decisions and many other areas depend on the fast analysis of large sets of data, maintaining a low latency for your data processes is critical. SQL Server’s In-Memory OLTP Engine can help with that.

WHAT OTHER STUDENTS SAY ABOUT THE COURSE:

• “Excellent and helpful course regarding SQL Server. Very suitable for my job.”

• “So far the course is great! The simplicity of explaining the different concepts is outstanding!”

• “An easy to follow course with excellent content!”

• “I was impressed by this course! It explains in plain words how to utilize In-Memory Optimization in SQL Server and the demos are really amazing.”

THE BENEFITS OF THIS COURSE:

By the time you complete this course, you will know:

• What is the In-Memory OLTP Engine in SQL Server and how it works

• What Memory-Optimized Tables are and which are their main characteristics

• What Natively-Compiled Stored Procedures are and how they work

• How to Use In-Memory OLTP for Boosting the Performance of your Data Processes, by utilizing memory-optimized tables and natively-compiled stored procedures

• How to migrate your data processes to In-Memory OLTP

  • How to find the right candidate databases, data processes and tables for migrating it to In-Memory OLTP 

  • How to analyze your tables and stored procedures prior to planning their migration to In-Memory OLTP

  • Ways to estimate if your workload’s performance can benefit from In-Memory OLTP

MAJOR LEARNING OBJECTIVES:

Throughout the course, I will take you through all the necessary steps that you need to learn, in order to start utilizing SQL Server’s powerful In-Memory OLTP engine.

First, via the introductory section, you will learn what In-Memory OLTP is and which are the best-suited workloads for In-Memory OLTP.

After that, we will be discussing about the requirements for enabling In-Memory OLTP in SQL Server, and we will create together, a SQL Server In-Memory OLTP-Enabled database.

Then, we will thoroughly discuss about memory-optimized tables, and you will learn how to create and use durable and non-durable memory optimized tables in SQL Server. Moreover, we will run some examples for comparing the performance of these two types of memory-optimized tables.

After that, we will be discussing about natively-compiled stored procedures in SQL Server, and among other, you will learn how to create and use this special type of SQL Server stored procedures. Moreover, we will run some interesting examples, for comparing the performance of a disk-based process vs. a process that uses memory-optimized tables vs. a process that uses memory-optimized tables combined with natively-compiled stored procedures.

Then, we will be discussing about how you can improve the performance of your database workload using In-Memory OLTP, and more specifically, we will discuss about, how you can migrate your databases to In-Memory OLTP and how you can estimate if your specific workload type, can benefit from In-Memory OLTP processing in SQL Server.

Finally, we will go through together, many examples of using In-Memory OLTP in SQL Server, where among other, we will be comparing the performance of different disk-based processes vs. processes that use memory-optimized tables vs. processes that use memory-optimized tables combined with natively-compiled stored procedures.

PREREQUISITES:

• Basic knowledge of SQL Server and data principles

THIS COURSE CONTAINS/OFFERS:

• 3 hours of high-quality video

• Live demonstrations and hands-on guides

• Useful quizzes for testing your knowledge on each section

• Many downloadable resources (i.e. summaries and T-SQL scripts)

• A practice test in the end of the course

• Ability to ask the instructor questions via the Q&A section

• Certificate on course completion

Who this course is for:

• SQL Server DBAs, Engineers & Architects that want to learn more about SQL Server In-Memory OLTP and how they can use it, for significantly improving the performance of their data processes.
• SQL Server Developers who want to learn how they can improve the performance of their ETL processes by utilizing In-Memory OLTP in SQL Server.