SQL Horror Stories

on YouTube ↗21m

" summary

A rapid set of real incidents: a preventative‑maintenance script rollout is blocked until a manager is reframed by reputation and then deployed, saving hours of firefights; backups prove unusable so recovery requires rolling back to a 10 days old copy and exporting corrupted tables; corruption checks via DBCC CHECKDB are non‑optional; ransomware destroys keys because a TDE certificate on C drive breaks recovery. Tools named: Ola scripts, DPA, SolarWinds observability.

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

• 21mSQL Horror StoriesKevin Kline · SQLBits 2022
• 21mSQL Horror StoriesKevin Kline · SQLBits 2019
• 38mProtecting Database Backups From Ransomware and Malicious IntentRon Ekins · DevDays Europe 2024
• 51mDatabase Incident Management: When Everything Goes WrongJosh Varner · Percona Live 2022
• 54m10 Deadly Sins of SQL Server ConfigurationScott Sutherland · AppSec California 2015
• 47mDisaster Recovery Strategies for SQL ServerAndrew Pruski · SQLBits 2022
• 51mDatabase Disasters and How to Find ThemChristophe Pettus · PGConf NYC 2022
• 20mDave & James’ Excellent Database Adventure: From Code Errors to Reliable ReleasesDavid Ong, James Hemson · SQLBits 2019