In this one-day workshop we will go through everything a Data Platform professional needs to deploy SQL Servers using GitHub.

Which is co-presented by a major contributor to dbatools and a dual-category MVP who has gained a couple of the new GitHub certifications for Azure partners.

We will cover:
• Work with Branches within GitHub
• Setup GitHub runners
• Deploy SQL Server infrastructure and database updates using GitHub Actions
• Use security best practices
• Test your deployments
• Perform automation within GitHub
• Build your own action
• Use newer GitHub features

Even though this session is based on SQL Server, a lot of the GitHub concepts you learn can be used with other applications and services as well.

During this workshop you will create multiple repositories in your own GitHub account. So that after the workshop there will be yours to keep.

We will send out information beforehand on how to create a GitHub account if you do not have one already.

A local instance of SQL Server is preferred. However, we will also support deploying SQL Server as a virtual machine in Azure.

An Azure Account is preferred for some of the exercises so that you can setup your own Azure Key Vault along with secrets. We will demo this as well though.

During the course of the day, we will also show some demos highlight some things at an organization level.

At the end of this workshop, you will have everything you need to deploy SQL Server using GitHub. Plus, you will have gained knowledge that can help you gain the new GitHub certifications for Azure partners.