DevOps for the Database with TFS 2018

Learn how to use Team Foundation Server 2018, SQL Server, and Git for development operations, including version control, deployments, release management, and more.

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

Conclusion

• Next steps