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

YouTube

SQL Server Internals and Architecture

PASS Data Community Summit via YouTube

Overview

Explore the inner workings and architectural design of SQL Server in this comprehensive conference talk. Delve into the core components and processes that drive SQL Server's functionality, gaining valuable insights into its internal structure. Learn about key architectural elements, including the buffer pool, query processing engine, and storage engine. Understand how SQL Server manages memory, handles concurrency, and optimizes query execution. Discover the intricacies of transaction management, logging mechanisms, and recovery processes. By the end of this talk, gain a deeper understanding of SQL Server's internals, enabling you to make more informed decisions about database design, performance tuning, and troubleshooting.

Syllabus

SQL Server Internals and Architecture | Deepthi Goguri

Taught by

PASS Data Community Summit

Reviews

Start your review of SQL Server Internals and Architecture

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.