DevOps for the Database with VSTS and Azure

Course details

Databases are critical to most line-of-business applications; they need to be tightly managed to perform well in a DevOps environment. This course targets developers and database admins who write code and work with SQL Server databases. Instructor Brian Randall shows how to put a database under version control and move through an automated release pipeline using Visual Studio Team Services (VSTS) and Azure. Learn how to build a SQL database using a continuous integration workflow, release the database via continuous deployment, and bake in quality from the beginning, by testing the database with a number of different tools. Plus, learn how to troubleshoot over a dozen real-world issues that admins encounter with SQL databases, from database drift to multi-environment deploys.

Learning objectives
VSTS and SSDT overview
Version controlling a database
Branching and merging
Local deployments
Agents
Pipelines
Building, releasing, and testing an SQL database
SQL Server database issues

Concepts

0. Introduction

01 - Improve application development with the right DevOps tools
02 - What you should know

1. Tooling Overview

03 - DevOps review
04 - DevOps for databases
05 - VSTS overview
06 - VSTS details
07 - Deployment targets with VSTS
08 - SQL Server Data Tools (SSDT) overview
09 - End-to-end demo
10 - Takeaways

2. Version Control Your Database

11 - Why version control
12 - Tracking your work
13 - New VSTS UI demo
14 - VSTS work items demo
15 - Team Foundation Version Control (TF VC) vs. Git
16 - TF VC and Git in VSTS demo
17 - Version control your database
18 - Create a SQL server and database demo
19 - Version control your database demo
20 - Branching and merging
21 - Local deployments
22 - Local deployments demo
23 - Dealing with drift
24 - SQL compare demo
25 - Version control key takeaways

3. Agents and Pipelines

26 - Agents
27 - Hosted pools demo
28 - Private agent demo
29 - Deployment groups
30 - Pipelines
31 - Pipelines demo
32 - Takeaways

4. Build Your Database

33 - Why Team Build
34 - Build your database for SQL database
35 - Build your database demo
36 - Examine completed build demo
37 - Continuous integration
38 - Continuous integration demo
39 - Takeaways

5. Release Your Database

40 - Why release management
41 - Release your database to SQL database
42 - Release your database demo
43 - Examine completed release demo
44 - Continuous deployment
45 - Continuous deployment demo
46 - Takeaways

6. Test Your Database

47 - Why test
48 - What makes testing databases different
49 - Good test data
50 - Testing locally with SSDT
51 - Testing locally with SSDT demo
52 - Testing as part of release
53 - Get tokenization task demo
54 - Add tokenization task to release demo
55 - Add test task to release demo
56 - Test locally with TSQLT
57 - Test locally with Slacker
58 - Takeaways

7. Real-World Issues

59 - Real-world issues overview
60 - Data motion
61 - Static data
62 - Static data demo
63 - Database drift at scale
64 - Testing at scale
65 - Versioning the database
66 - Apps and databases
67 - Add website demo
68 - Add webpage with data demo
69 - Deploy to Azure from Visual Studio
70 - Fix Azure connection string
71 - Deploy app and db from release management, part 1
72 - Deploy app and db from release management, part 2
73 - Multi-environment deploy demo
74 - Takeaways

Conclusion

75 - Next steps