22-25 April 2026

Azure DevOps trio

2022

TL; DR

Welcome to Azure DevOps trio, a tale about how a development team and an operations team have to bond together and start using Azure DevOps for Data Platform deployments.

Session Details

Welcome to Azure DevOps trio, a tale about how a development team and an operations team have to bond together and start using Azure DevOps for Data Platform deployments.

This session will cover the process of developing a CI/CD process, starting the process of getting the team on board and ending with making an actual release.

Usually this session is a duet. However, we have made it a trio especially for SQLBits to introduce a new speaker.

We will discuss
- the challenges of implementing DevOps
- setting up a database solution project
- getting started with source control
- testing your database releases using tSQLt
- setting up your Azure Devops pipelines
- using Azure DevOps with Azure Data Engineering services

After this session you will have the tools and knowledge to get started with DevOps and get your development process to the next level.

Feedback Link - https://sqlb.it/?7033

3 things you'll get out of this session

Speakers

Kev Chant

kevinrchant.com

Sander Stad

sqlstad.nl

Sander Stad's previous sessions

Streamlining Power BI with PowerShell
Power BI is a vital tool for data analytics, but managing workspaces, access, and data sets manually can be time-consuming and error-prone. This session explores how PowerShell automation simplifies and streamlines these tasks.
 
Saying no is OK
In the high-demand IT field, professionals often struggle with overcommitment and work-life balance. This presentation, "Saying No is OK," offers practical insights and strategies for IT professionals to assertively manage their workload and protect their well-being. Learn the art of saying no, how to prioritize, and maintain professionalism while achieving a healthier work-life balance. Join us for a transformative session that will empower you to succeed while setting necessary boundaries.
 
Unveiling the magic of CI/CD for SQL Server using GitHub Actions
In this expert session we unveil the magic of CI/CD for SQL Server updates using GitHub Actions.
 
Github and Azure DevOps Duet - SQLBits edition
A tale about how a development team and an operations team must bond together and figure out how to use GitHub and Azure DevOps together for Data Platform deployments.
 
Battle tested project planning with Azure Devops boards
Azure boards within Azure DevOps give you the capability to organise your project and analyse the it’s progress. Do you want your manager to stop bugging you about your project’s progress, come to this session?
 
Start to See With tSQLt
Unit testing with databases is fairly new and is not yet embraced within database development. We'll learn how we can implement setup a database project, implement basic unit testing with tSQLt
 
Solving the dev DB problem with Docker and dbaclone
Shared dev databases have a disastrous effect on quality and throughput. However, moving to self-service dev/test databases is hard due to storage and data privacy concerns. The solution? Docker and dbaclone.