In this session, the second of a multi-part series, we will cover the concepts and methodologies in SSDT that allow DBAs to work with source control, implement a continuous database development lifecycle, and implement proper change automation.
In this session, you will learn the methodologies and best practices of working with database development lifecycle and change automation (specifically using SSDT), understand the differences between state-based and migration-based deployments, learn how to strategically tackle common edge cases, and more.
Meet SSDT (SQL Server Data Tools), that comes with the SQL Database Project as an effective tool for integrating the database development with the software development lifecycle. Source control, version history, unit testing, and CI/CD: SSDT comes with an answer for all.
SSDT in general (SQL Server Data Tools), and the SQL Database Project specifically, are very effective tools for integrating the database development with the software development lifecycle. Source control, version history, unit testing, and CI/CD – SSDT has it all – and it’s completely free!
Implementing DevOps methodologies with databases is not an easy task, it becomes even more difficult when the DBAs in charge of development are not experienced enough with the world of Agile, DevOps, CI/CD, Change Automation, Development Lifecycle, and more scary-but-cool-sounding words.
We all know the database is a critical element of your software product. It’s high time for that fact to be reflected in your database development lifecycle!
Download Slides Deck
This session was delivered at the following events:
- Group By Conference 2021 (October 27) (YouTube recording)
- PASS Data Community Summit 2022 (November 18, 2022)
- Microsoft DBAs Club (September 25, 2024, Hebrew) (YouTube recording)
Interested?
If you want me to deliver this session at an event that you’re organizing, whether it’s an online or an in-person event, please fill out the form below. Thanks!