Manual database deployments can be time-consuming and error prone, making sure only approved changes are deployed to test, UAT and ultimately production. Azure Pipelines helps development teams and DBAs by providing a consistent process to deploy changes, as changes are checked into source control. This episode will touch on Azure Repos and Azure Data Studio, besides Azure Pipelines. 00:22 Introductions 00:57 Azure Data Pipelines introduction and when to use them 01:42 Getting started 02:32 Demo of the YAML files 03:41 Azure Repos 04:45 Pipelines in Action 06:56 Time to deployment 08:44 Pipelines in Azure DevOps 10:49 Understanding the Agent and the Build Agent 13:40 When to use each scenario 14:19 Tips and Tricks 15:07 Closing ✔️ Resources: Azure Pipelines Overview - https://learn.microsoft.com/en-us/azure/devops/pipelines YAML Schema - https://learn.microsoft.com/en-us/azure/devops/pipelines/yaml-schema Azure Pipelines Task Index - https://learn.microsoft.com/en-us/azure/devops/pipelines/tasks/reference Azure Pipelines Pipeline Variables - https://learn.microsoft.com/en-us/azure/devops/pipelines/build/variables About Erin Dempster: Erin is currently the Data Operations Team Lead at Trean Corporation in Wayzata, MN, USA. She has been working with SQL Server for nearly 20 years, both as a developer and a database administrator. Over the past several years, PowerShell and Azure have become areas of interest. She was awarded the Microsoft MVP in the Data Platform. Website: https://www.erindempster.com/ About MVPs: Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. They are always on the "bleeding edge" and have an unstoppable urge to get their hands on new, exciting technologies. They have very deep knowledge of Microsoft products and services, while also being able to bring together diverse platforms, products and solutions, to solve real world problems. MVPs make up a global community of over 4,000 technical experts and community leaders across 90 countries/regions and are driven by their passion, community spirit, and quest for knowledge. Above all and in addition to their amazing technical abilities, MVPs are always willing to help others - that's what sets them apart. Learn more: https://aka.ms/mvpprogram 📌 Let's connect: Twitter: Anna Hoffman, https://twitter.com/AnalyticAnna Twitter: Erin Dempster, https://twitter.com/em_dempster Twitter: AzureSQL, https://aka.ms/azuresqltw 🔴 To watch other MVP Edition episodes, see our playlist: https://aka.ms/dataexposedmvps To check out even more Data Exposed episodes, see our playlist: https://aka.ms/dataexposedyt 🔔 Subscribe to our channels for even more SQL tips: Microsoft Azure SQL: https://aka.ms/msazuresqlyt Microsoft SQL Server: https://aka.ms/mssqlserveryt Microsoft Developer: https://aka.ms/microsoftdeveloperyt #AzureSQL #SQLServer