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/