Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

SQL Server 2014 In-Memory OLTP Overview

PASS Data Community Summit via YouTube

Overview

This course provides an overview of SQL Server 2014's in-memory OLTP technology, focusing on user scenarios, hardware trends, architectural pillars, and integration with the rest of SQL Server. By the end of the course, learners will understand the benefits of in-memory optimization, no lock/latch concurrency control, and native compilation. The course teaches skills such as analyzing memory technologies, identifying hardware trends, and implementing in-memory OLTP solutions. The teaching method includes discussions, demonstrations, and Q&A sessions. This course is intended for database administrators, SQL Server developers, and IT professionals interested in optimizing OLTP workloads using in-memory technology.

Syllabus

Introduction
Business Analytics Conference
Kevin Farley
SQL Server 2014
Memory Technologies
Why OLTP
Hardware Trends
InMemory OLTP
Demo
Block Diagram
InMemory Roast or Columnstore
Demonstration
Questions

Taught by

PASS Data Community Summit

Reviews

Start your review of SQL Server 2014 In-Memory OLTP Overview

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.