Overview
This course aims to debunk myths and misconceptions about SQL Server operations and management. The learning outcomes include gaining a deeper understanding of how SQL Server operates and should be maintained. The course covers topics such as data compression, data file management, snapshot isolation, checkpoints, and log recovery. The teaching method is a fast-paced session focused on myth debunking. The course is intended for individuals interested in SQL Server administration and management.
Syllabus
Introduction
My name is Parental
kilt
crossdressing
sheep
Jonathan
Data Compression
It depends
truncate table is
minimally logged
proof
rollback
Data File Shrink
Sequel Server
quel Server
Snapshot Isolation
Checkpoints
Dirty Pages
Size of Data Operation
DB Datafile
One to One
One Log File
Multiple Log Files
Instant File initialization
Crash Recovery
Log Size
Log Records
Corruptions
Automatic Page Repair
Check DB
IO Subsystem
Guarantees
Its Getting Late
Log Recovery Model
Temp DB
SSD fragmentation
Taught by
PASS Data Community Summit