Excellent Database Adventure: From Code Errors to Reliable Releases
summary
Demonstrates turning messy, hand‑edited databases into a repeatable release pipeline: check schema into SQL Source Control, apply team formatting and snippets with SQL Prompt, use comparison (deploy or script) via SQL Compare, run TSQLt tests through SQL Test and catch failures before production, and auto‑generate docs with SQL Doc — the demo commits, colors prod/dev tabs to avoid mistakes, runs tests, and produces 384 pages of documentation in under a minute.
AI-written summary · about
chapters (14)
- 0:00Introduction
- 1:03Database workflow challenges
- 3:53Poor practices consequences
- 6:01Solutions to key challenges
- 6:23Version control with SQL Source Control
- 7:27Code formatting with SQL Prompt
- 9:52Committing changes to version control
- 10:55Environment awareness in SQL Prompt
- 11:37Code analysis and team collaboration
- 12:19Deploying changes between environments
- 14:26Unit testing with SQL Test
- 16:30Automating documentation with SQL Doc
- 18:39Additional tools and resources
- 19:00Summary
related talks
20mDave & James’ Excellent Database Adventure: From Code Errors to Reliable Releases
50mBringing DevOps to the Database
36mUnlocking the Benefits of Database DevOps and Automation
23mShift-Left: A DevOps and Database Story
01h 00mDevOps for Your Relational Database Foundations
48mApplying effective Source Control to your Database System
01h 10mContinuous Integration for the BI Developer
48mDevOps Discovery: Navigating the Database Landscape