Dave & James’ Excellent Database Adventure: From Code Errors to Reliable Releases

on YouTube ↗20m

" summary

A runnable workflow shows how bad local scripts become reliable releases by enforcing versioning, formatting, testing and docs: code moves from SQL Source Control into a dev branch, is formatted and snippeted with SQL Prompt, compared and deployed via schema compare, and validated with SQL Test TSQLt unit suites; auto-generated docs produce 384 pages in seconds; demos show selective deploys, test failures surfacing coverage, and the process preventing repeated production blowups.

AI-written summary · about

" chapters (14)

1. 0:00Introduction
2. 1:03Database workflow challenges
3. 3:53Poor practices consequences
4. 6:01Solutions to key challenges
5. 6:23Version control with SQL Source Control
6. 7:27Code formatting with SQL Prompt
7. 9:52Committing changes to version control
8. 10:55Environment awareness in SQL Prompt
9. 11:37Code analysis and team collaboration
10. 12:19Deploying changes between environments
11. 14:26Unit testing with SQL Test
12. 16:30Automating documentation with SQL Doc
13. 18:39Additional tools and resources
14. 19:00Summary

" related talks

• 20mExcellent Database Adventure: From Code Errors to Reliable ReleasesDave, James Hemson · SQLBits 2022
• 50mBringing DevOps to the DatabaseSteve Jones · SQL Server Virtual Conference 2021
• 36mUnlocking the Benefits of Database DevOps and AutomationKellyn Gorman · PowerShell + DevOps Global Summit 2025
• 23mShift-Left: A DevOps and Database StoryKevin Kline · SQLBits 2024
• 01h 00mDevOps for Your Relational Database FoundationsBrian A. Randell · NDC London 2021
• 23mShift-Left: A DevOps and Database StoryKevin Kline · SQLBits 2022
• 36mHow to make your daily routine, code and database more efficientMarcin Przepiorowski · Riga Dev Days 2019
• 31mDevOps Practices for the Database TeamPramod Sadalage · DevOpsDays Chicago 2017