Overview
-
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.
Syllabus
-
Introduction
- Improve application development with the right DevOps tools
- What you should know
- DevOps review
- DevOps for databases
- VSTS overview
- VSTS details
- Deployment targets with VSTS
- SQL Server Data Tools (SSDT) overview
- End-to-end demo
- Takeaways
- 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
- Agents
- Hosted pools demo
- Private agent demo
- Deployment groups
- Pipelines
- Pipelines demo
- Takeaways
- Why Team Build?
- Build your database for SQL database
- Build your database demo
- Examine completed build demo
- Continuous integration
- Continuous integration demo
- Takeaways
- Why release management?
- Release your database to SQL database
- Release your database demo
- Examine completed release demo
- Continuous deployment
- Continuous deployment demo
- Takeaways
- 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
- 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
- Next steps
