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
()
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
()
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
()