Alex Yates

Build Your Own End To End SQL Server Deployment Pipeline (For Under $1 A Day)

Trainer(s): Alex Yates
Provider: DPS 2020 (Data Platform Summit)
Duration: 6 Hours 46 Mins
Subtitles: No
Regular Price: USD 218
Offer Price: USD 54.5 (75% OFF)
Discount Code: HAPPY75
(GST + Internet Transaction Fee additional)
Subscription Period: Lifetime Access

Abstract: Automated deployments enable teams to deliver value faster, more reliably and for less money. If your database deployments are still slow, manual and error prone, and your business wants to remain competitive, building an automated database deployment pipeline should be a high priority.

However, this can be difficult because it requires a working knowledge of various technologies, as well as an understanding about how to glue them all together. For example, folks need to understand database technologies, scripting languages, source control tools and CI/CD architectures, as well as all the necessary networking. To create a truly successful deployment pipeline it often requires collaboration between multiple specialists with a generalist to guide them.

This session is both for the aspiring generalists who wants to understand the big picture and for the specialist who wants to learn to better collaborate with their colleagues. We will focus on the high-level outcomes, without going too deep on any specific technology. Therefore, this session should be accessible to anyone, regardless of speciality or experience.

Attendees will create their own end to end deployment pipelines for SQL Server using GitHub, Octopus Deploy and AWS. While attendees tool choices and hosting providers might vary, this session will focus on universal concepts and should be valuable to folks even if they use different tools, such as Jenkins, Azure DevOps or Azure. Folks will be using their own software and licences with 100% free / trial software/services and will be able to host their infrastucture using their own AWS account, on free tier eligible VMs. The cost of running the infrastructure will be no more than a few cents per hour.

By the end of this class, all attendees will understand how to create an end to end database deployment pipeline, and they will take away their own hosted pipeline which they’ll be able to spin up and tear down whenever they like.


    1. Cloning a Git repo in GitHub
    2. Introducing Octopus Deploy, and configuring the hand-off from GitHub Actions
    3. AWS 101: Building a basic set of infrastucture and SQL instances from code, using Octopus Deploy
    4. Exploring database source code and understanding how it gets deployed
    5. Configuring Octopus Projects to deploy database updates
    6. Further extensions (various options, depending on time available.)

Note: This recorded class is available in the format of a video course. Content is presented in modular videos. Learn more.