Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Using the Azure Pipeline to Build and Deploy a Database Project | Data Exposed: MVP Edition

Microsoft Developer
588K subscribers
<__slot-el>
<__slot-el>
10K views 1 year ago #SQLServer #AzureSQL
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/azu... YAML Schema - https://learn.microsoft.com/en-us/azu... Azure Pipelines Task Index - https://learn.microsoft.com/en-us/azu... Azure Pipe …...more
...more
Using the Azure Pipeline to Build and Deploy a Database Project | Data Exposed: MVP Edition
69Likes
10,126Views
2023Sep 26
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/azu... YAML Schema - https://learn.microsoft.com/en-us/azu... Azure Pipelines Task Index - https://learn.microsoft.com/en-us/azu... Azure Pipelines Pipeline Variables - https://learn.microsoft.com/en-us/azu... 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,   / analyticanna   Twitter: Erin Dempster,   / 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

Follow along using the transcript.

Microsoft Developer

588K subscribers