~/talk

SQL Horror Stories

on YouTube 21m
Talkat SQLBits 2019 · 2019-02-27..03-02· [databases]

speaker

name:Kevin Kline
links:none on file

resources

video:https://youtu.be/njgTbph0wdI
slides:none on file

summary

Guided tour of real failures: backups often succeed but restores fail, forcing recovery from 10+ day-old copies; DBCC CHECKDB is cited as mandatory before a restore; one team exports corrupted tables, rebuilds the DB and reloads rows — recovery takes days. A TDE certificate kept on C: is lost to Petya ransomware and encrypts everything. Mentions SolarWinds DPA and observability tools, a booklet giveaway of SQL in a Nutshell (25 printed copies), and many laughable, avoidable SQL coding mistakes.

AI-written summary · about

chapters (8)

  1. 0:00SQL horror stories intro
  2. 3:04Bad bosses and ego
  3. 8:24Troublesome teamwork
  4. 11:44Vendor session
  5. 13:12Security failures
  6. 15:43Database recovery
  7. 18:17Corruption and neglect
  8. 19:24Final queries

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.