In-Memory OLTP Courses and Certifications

PASS Data Community Summit

In-Memory OLTP in SQL Server - Overview and Architecture

Dive into SQL Server's In-Memory OLTP architecture, exploring memory optimization, native compilation, and lock-free concurrency control for enhanced database performance.

• YouTube
• 57 minutes
• On-Demand
• Free Video

PASS Data Community Summit

In-Memory OLTP for Database Developers in SQL Server 2014

Dive into SQL Server 2014's in-memory OLTP optimization, exploring memory-optimized tables, hash indexes, and natively compiled stored procedures for enhanced database performance and lock-free transactions.

• YouTube
• 59 minutes
• On-Demand
• Free Video

PASS Data Community Summit

In-Memory OLTP Internals - Understanding the 30x Performance Boost in SQL Server Hekaton

Discover how SQL Server Hekaton's in-memory architecture revolutionizes data management, offering unprecedented performance boosts through optimized memory storage and innovative checkpoint mechanisms.

• YouTube
• 1 hour
• On-Demand
• Free Video

PASS Data Community Summit

The Ambiguous Case of Off Row Storage in In-Memory OLTP

Dive into the complexities of off-row storage mechanisms in In-Memory OLTP, exploring implementation strategies and performance implications for SQL Server databases.

• YouTube
• 56 minutes
• On-Demand
• Free Video

T-SQL Execution Plans, Indexes, Transactions, In-Memory OLTP

764 ratings at Udemy

Learn Execution Plans, Indexes, Transactions, Isolation Levels & In-Memory OLTP using T-SQL in Microsoft SQL Server

• Udemy
• 9 hours
• On-Demand
• Paid Course

PASS Data Community Summit

Field Testing Buffer Pool Extension and In Memory OLTP Features

Explore SQL Server 2014's In-Memory OLTP and Buffer Pool Extension features through field testing results, benchmarks, and real-world examples to enhance database performance and scalability.

• YouTube
• 1 hour
• On-Demand
• Conference Talk

PASS Data Community Summit

SQL Server 2014 In-Memory OLTP Overview

Explore SQL Server 2014's in-memory OLTP technology, its architectural pillars, and integration with SQL Server for optimized workloads and improved performance.

• YouTube
• 1 hour 6 minutes
• On-Demand
• Conference Talk

PASS Data Community Summit

SQL Server 2014 In-Memory OLTP Management

Explore SQL Server 2014's in-memory OLTP technology, focusing on ACID compliance, storage optimization, memory provisioning, high availability, and manageability for enhanced database performance.

• YouTube
• 1 hour 2 minutes
• On-Demand
• Conference Talk

PASS Data Community Summit

SQL Server 2014 - In-Memory OLTP End-to-End - Preparing for Migration

Explore SQL Server 2014's In-Memory OLTP feature, its performance benefits, and learn how to plan and execute a successful migration using a sample workload demonstration.

• YouTube
• 59 minutes
• On-Demand
• Conference Talk

PASS Data Community Summit

A Case Study Featuring In Memory OLTP and Hybrid Cloud Scenarios

Practical insights on upgrading mission-critical databases to SQL Server 2014, implementing In-Memory OLTP, Managed Backup, and Azure Storage integration for large workloads.

• YouTube
• 58 minutes
• On-Demand
• Conference Talk

PASS Data Community Summit

In Memory OLTP Performance Troubleshooting

Troubleshoot In-Memory OLTP performance issues: diagnose and resolve log IO bottlenecks, index tuning, and query plan problems to achieve desired performance improvements.

• YouTube
• 55 minutes
• On-Demand
• Conference Talk

PASS Data Community Summit

In Memory OLTP Memory Storage Monitoring and Troubleshooting

Explore In-Memory OLTP monitoring, troubleshooting, and management using familiar tools like PerfMon, Profiler, DMVs, and XEvents for optimal performance and operational stability.

• YouTube
• 49 minutes
• On-Demand
• Conference Talk

PASS Data Community Summit

AMA Open Questions and Answers on SQL Server 2014 In Memory OLTP

Open Q&A session addressing queries about SQL Server 2014 In-Memory OLTP, offering expert insights and solutions for database professionals seeking to optimize performance.

• YouTube
• 58 minutes
• On-Demand
• Conference Talk

PASS Data Community Summit

SQL Server 2016 Hero Features in Action - Full Lifecycle of Financial Data

Explore SQL Server 2016's hero features, including record-breaking performance, enhanced availability, in-memory OLTP, and secure data protection, with practical applications in financial data management.

• YouTube
• 1 hour 2 minutes
• On-Demand
• Conference Talk

PASS Data Community Summit

AlwaysOn in Microsoft SQL Server 2014

Explore upgrading mission-critical databases to SQL Server 2014, enabling new features like in-Memory OLTP and Managed Backup, with minimal downtime for large workloads.

• YouTube
• 59 minutes
• On-Demand
• Conference Talk