DPS 2020 Training Class - Database DevOps - by Alex Yates


DPS 2020 Training Class – Database DevOps – by Alex Yates

Visit DPS 2020 More Training Classes Book Now

Pre-Con Title

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


Data Administration


#DevOps #Deployment




Alex Yates


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.


Day 1:

  • Cloning a Git repo in GitHub
  • Introducing Octopus Deploy, and configuring the hand-off from GitHub Actions

Day 2:

  • Exploring database source code and understanding how it gets deployed
  • Configuring Octopus Projects to deploy database updates
  • Further extensions (various options, depending on time available.)

Attendee Pre-requisite (if any)


Create a free account in advance for the following services:

  • AWS
  • GitHub
  • Octopus Deploy (Cloud edition)


  • If you would like to run the code locally (optional) install the following on your dev machine:
  • SQL Server Developer Edition (Either a full instance or using Docker is fine)
  • (If using SSDT) Visual Studio (Community edition is fine)
  • (If using Redgate) Redgate SQL Change Automation PowerShell cmdlets
  • PowerShell
  • Your prefered IDE for working with SQL Server (SSMS, Azure Data Studio etc)
  • Git

Is this class being recorded?

Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion.

Additional Comments from Instructor/Speaker

No special instructions/comments from the Speaker

Additional Comments from the Organizers

DPS 2020 Pre-Con price increases on the 1st of every month. This month’s pricing is the lowest. Book Now and save.

Pre-Con Trainings are instructor-led, demo-based, 8 hours (4 hrs each day).

Due virtual mode delivery, Pre-Cons are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the pre-con material (PDFs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

More Questions?

Visit FAQ page.

BooK Now

Book Now

Leave a Reply