SQL Friday #97 - Deborah Melkin - Database Deployment Methods Demystified

If you had to describe the database deployment process, you may say: We make changes in dev, magic happens, and then they appear in production. The technical part of that magic is what we’ll discuss.

In this session, we will explore the different ways that database changes can be applied - state based or migration scripts. We’ll look at how this impacts the various parts of the development lifecycle. We’ll examine some of the unexpected implications of how we deploy changes, including source control and database projects. This session isn’t just about implementing DevOps but about technical considerations regardless of how you deploy changes.

By the end of this session, you should have a clear understanding of the different ways to deploy your database changes, how they work, and most importantly, why you may want to implement those options.

About Deborah Melkin
Deborah Melkin has been working as a database professional with SQL Server for almost 20 years. She spends her days helping programmers with all aspects of database design, queries, performance, and deployment. In 2016, she began her blog, Deb the DBA. Soon after that, she began speaking at SQL Saturdays and user groups. Deborah is a board member of the New England SQL Server User group (NESQL). She was named as an IDERA ACE Class of 2020 and won Speaker Idol at PASS Summit 2019. Deborah is also a Microsoft MVP for the Data Platform.

In her spare time, Deborah can usually be found doing something musical.