SQL Server development workflow: from design to deployment

This session walks SQL Server developers through a complete database development workflow, from designing schema changes to testing and deploying them safely, using SQL Toolbelt Essentials. Most database teams don't struggle with SQL itself. The friction comes from process: schema changes made without a clear picture of what's already there, inconsistent code quality across a team, databases left outside version control, and deployments that feel riskier than they should. This session covers all four, with a live demo in SSMS for each one. 00:00 Introduction: what it means to be in control of your database 01:04 The four process problems in database development 02:14 Database design: planning schema changes with Redgate Data Modeler 12:12 Writing and reviewing SQL as a team with SQL Prompt 22:41 Version control and visibility with SQL Source Control 33:47 Testing and deployment with SQL Compare, SQL Data Generator, and SQL Test 45:07 Why these four problems compound, and where to start Tools shown: Redgate Data Modeler, SQL Prompt, SQL Source Control, SQL Compare, SQL Data Compare, SQL Data Generator, SQL Test, and SQL Multi Script, all included in SQL Toolbelt Essentials. Try SQL Toolbelt Essentials free: https://rd.gt/4gHZXVW ✅ Subscribe to our YouTube channel to get notified on the latest video from us: https://youtube.com/@redgate For more updates follow us on: LinkedIn: https://www.linkedin.com/company/red-gate-software Website: https://www.red-gate.com/