Introduction
Welcome
()
What you should know
()
1. Tooling Overview
DevOps overview
()
DevOps for databases
()
Team Foundation Server (TFS) 2018 overview
()
SQL Server Data Tools (SSDT) overview
()
Supporting tools
()
End-to-end demo
()
2. Version Control Your Database
Why version control?
()
Tracking your work
()
Team project setup: Demo
()
Backlog: Demo
()
Team Foundation Version Control (TFVC) vs. Git
()
Version control your SQL Server database
()
Sample database installation
()
Version control your SQL DB with Git: Demo set up
()
Version control your SQL DB with Git: Demo import database
()
Version control your SQL DB with Git: Demo set up another user
()
Version control your SQL DB with Git: Demo share changes
()
Version control your SQL DB with TFVC: Demo set up and import
()
Version control your SQL DB with TFVC: Share changes
()
Branching and merging
()
Local deployments
()
Local deployments: Demo
()
Dealing with drift
()
Dealing with drift: Demo
()
3. Build Your Database
Team build
()
Agents
()
Pipelines
()
Build your database for SQL Server
()
Agents and pipelines: Demo
()
Build your database for SQL Server: Demo
()
Continuous integration
()
Continuous integration: Demo
()
4. Release Your Database
Why release management?
()
Agents and pipelines?
()
Deployment groups
()
Deployment groups: Demo
()
Release your database to SQL Server
()
Release your database to SQL Server: Demo
()
Continuous deployment
()
Continuous deployment: Demo
()
Multiple deployment groups: Demo
()
Multiple environments: Demo
()
5. Test Your Database
Why test?
()
Database testing frameworks
()
Testing locally with SSDT: Demo
()
Testing as part of release
()
Sharing unit projects with a team: Demo
()
Testing and release: Demo
()
6. Real-World Issues
Real-world issues overview
()
Data motion
()
Static data
()
Data motion and static data: Demo
()
Database drift at scale
()
Testing at scale
()
Versioning the database
()
Apps and databases
()
Add website to project: Demo
()
Deploy app to shared dev: Demo
()