SimpleDatabaseDeploys_Abstract.txt

DevOps Flow Series, part 2 of 4

Title:
Simple database deployments with GitHub and SSDT

Abstract:
For many of us, database deployments are time consuming, painful and risky. 
The automated deployment of applications, and even servers, is now ubiquitous 
- but most of us have not applied the same principles to our databases.

In this demo heavy session, we'll script out our database source code locally 
using SSDT and commit it to GitHub. Then we'll build it automatically upon 
commit, and deploy it at the click of a button with GitHub Actions.

We'll also discuss some of the common blockers and how they can be resolved. 
For example, we'll discuss shared development databases, branching plans, testing and 
masking production data for development.

You'll leave this session with a better understanding of how to deliver 
working software more regularly and more reliably, enabling you to respond 
better to business demands.

Simple Abstract:
100% demos: We will create a new public repository in GitHub, script out a 
database using SSDT, and set up an automated GitHub Action to deploy our database.

More from the DevOps Flow series:
1. DevOps 101 for Data Folks:
   https://gist.github.com/Alex-Yates/efef91357c6bd0dc1fbe63f2eb464f68
2. Simple database deployments with GitHub, Azure DevOps Services and SSDT: 
   https://gist.github.com/Alex-Yates/43c7f4d51a651cd8b3dcdcb48843691f
3. Solving the dev database problem with GitHub, Docker and dbaclone:
   https://gist.github.com/Alex-Yates/8125be587e58863ad35e0845ab6ffd5a
4. Zero downtime database deployments
   https://gist.github.com/Alex-Yates/ac4c791bbd98eb3269f35db59cc30f88