~/talk

What Playing Minecraft Taught Me About DevOps

on YouTube 20m
Talkat SQLBits 2023 · 2023-03-14..03-18· [devops-and-delivery]

speaker

name:Richie Lee
links:none on file

resources

video:https://youtu.be/5tY7t8xyj_c
slides:none on file

summary

Describes converting huge partitioned heap tables to clustered column store indexes without the downtime SSDT’s rebuild-copy-drop would cause, using stored procedures, SQL Agent jobs, a logging table and per-partition high-watermarks, tested with DBFit and full pre-prod restores, moving data partition-by-partition over four months, monitoring CPU and log growth, then swapping and renaming tables — result: massive compression and a controlled rollout that avoids the “copy everything at once” failure mode.

AI-written summary · about

chapters (8)

  1. 0:00Introduction and setup
  2. 1:25Minecraft and DevOps basics
  3. 2:51Surviving the first night
  4. 5:59Real-world DevOps problem
  5. 9:48SSDT and creepers analogy
  6. 11:14Controlled data migration
  7. 13:59Deployment and testing
  8. 18:31Lessons learned and conclusion

related talks

~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.