DevOps for the Database with VSTS and Azure

Apply DevOps principles to your database workflow. Learn how to build an automated CI/CD release pipeline for SQL databases with Visual Studio Team Services and Azure.

Introduction

• Improve application development with the right DevOps tools
• What you should know

1. Tooling Overview

• DevOps review
• DevOps for databases
• VSTS overview
• VSTS details
• Deployment targets with VSTS
• SQL Server Data Tools (SSDT) overview
• End-to-end demo
• Takeaways

2. Version Control Your Database

• Why version control?
• Tracking your work
• New VSTS UI demo
• VSTS work items demo
• Team Foundation Version Control (TF VC) vs. Git
• TF VC and Git in VSTS demo
• Version control your database
• Create a SQL server and database demo
• Version control your database demo
• Branching and merging
• Local deployments
• Local deployments demo
• Dealing with drift
• SQL compare demo
• Version control key takeaways

3. Agents and Pipelines

• Agents
• Hosted pools demo
• Private agent demo
• Deployment groups
• Pipelines
• Pipelines demo
• Takeaways

4. Build Your Database

• Why Team Build?
• Build your database for SQL database
• Build your database demo
• Examine completed build demo
• Continuous integration
• Continuous integration demo
• Takeaways

5. Release Your Database

• Why release management?
• Release your database to SQL database
• Release your database demo
• Examine completed release demo
• Continuous deployment
• Continuous deployment demo
• Takeaways

6. Test Your Database

• Why test?
• What makes testing databases different?
• Good test data
• Testing locally with SSDT
• Testing locally with SSDT demo
• Testing as part of release
• Get tokenization task demo
• Add tokenization task to release demo
• Add test task to release demo
• Test locally with TSQLT
• Test locally with Slacker
• Takeaways

7. Real-World Issues

• Real-world issues overview
• Data motion
• Static data
• Static data demo
• Database drift at scale
• Testing at scale
• Versioning the database
• Apps and databases
• Add website demo
• Add webpage with data demo
• Deploy to Azure from Visual Studio
• Fix Azure connection string
• Deploy app and db from release management, part 1
• Deploy app and db from release management, part 2
• Multi-environment deploy demo
• Takeaways

Conclusion

• Next steps