The Agenda

Agenda Home
SQLBits 2024 runs from Tuesday 19th – Saturday 23rd March.
Database Administration

Automate Deployments with Azure DevOps

Description

Developing databases and Azure Data Factory pipelines is just the beginning. Once the code has been committed to source control, moving code between environments can be cumbersome in a manual environment. When multiple databases are involved or database changes need to be deployed with ADF pipeline changes, tracking the proper builds of each solution is critical. Otherwise, the quality assurance team may test incompatible builds, leading to wasted time and potentially allowing unsupported changes to be deployed together.

This session will introduce database developers and administrators to build and release pipelines in Azure Data Factory. Participants will gain hand-on experience, working with a demonstration database and a set of Data Factory artifacts to deploy to a target environment. Additionally, PowerShell will be used to do basic tests to ensure the database and ADF artifacts were deployed correctly. There are many nuances and advanced settings in DevOps, which will not be covered in this course.

Learning Objectives

Attendees should leave with a basic understanding of Azure Dev Ops build and release pipelines. With this basic knowledge, they will be able to return to their environments and create their own build and release pipelines for databases and Azure Data Factory artifacts. While not directly covered in the session, resources will be provided to show examples of other types of Azure solutions that can be deployed through Azure Dev Ops.

Previous Experience

Understanding of SQL Server database objects (schemas, tables, views, stored procedures, users, etc.) Experience with Visual Studio and Git repositories. Exposure to Azure Data Factory is nice

Tech Covered

Azure, Azure SQL Database, Managed Instance, deployment, Database Administration, Developing, Managing, DataOps & Automation