In-Memory OLTP Courses and Certifications

Optimizing OLTP and Data Warehousing with SQL Server 2014

161 ratings at Pluralsight

Optimize OLTP and data warehousing performance with SQL Server 2014's In-Memory OLTP and Clustered Columnstore Indexes. Learn to leverage hardware advancements and implement cutting-edge database technologies for improved efficiency.

• Pluralsight
• 2 hours 19 minutes
• On-Demand
• Conference Talk

Practical SQL Server In-Memory OLTP Tables and Objects

40 ratings at Pluralsight

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.

• Pluralsight
• 2 hours 51 minutes
• On-Demand
• Free Trial Available

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

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

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

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

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

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

Are You Optimistic About Concurrency?

Explore optimistic concurrency in SQL Server, focusing on in-memory OLTP, isolation levels, and transaction management for improved database performance and scalability.

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

PASS Data Community Summit

Index Internals - RowStore, ColumnStore, and NoStore

Explore index internals in SQL Server, covering RowStore, ColumnStore, and NoStore structures. Learn when to use each type and understand their performance implications.

• YouTube
• 59 minutes
• 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

New Features in SQL Server 2016 for Developers

Take a developer-focused tour of SQL Server 2016. Learn how to use new features to write less code and bring increased security, performance, and reliability to your applications.

• LinkedIn Learning
• 1-2 hours
• Finished
• Free Trial Available