Level: Intermediate

Steve Jones

Data Platform MVP, MCSE, BA

Editor

SQLServerCentral

DevOps is a hot topic in today's software development world. However most of the knowledge and experience with DevOps is based around application software and ignores the database. This session will examine how the concepts and principles of DevOps can be applied to database development by looking at both automated comparison analysis as well as migration script management. Automated building, testing, and deployment of database changes will be shown.

You will learn:

• How to apply DevOps principles to the database in either state-based or migrations-based changes
• How to automatically build and test databases in a CI/CD environment
• How to automate database releases, and realize how it's different from deployment/releases made for other software