Using the Azure Pipeline to Build and Deploy a Database Project | Data Exposed: MVP Edition
Ғылым және технология
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 - learn.microsoft.com/en-us/azu...
YAML Schema - learn.microsoft.com/en-us/azu...
Azure Pipelines Task Index - learn.microsoft.com/en-us/azu...
Azure Pipelines Pipeline Variables - 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: 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: aka.ms/mvpprogram
📌 Let's connect:
Twitter: Anna Hoffman, / analyticanna
Twitter: Erin Dempster, / em_dempster
Twitter: AzureSQL, aka.ms/azuresqltw
🔴 To watch other MVP Edition episodes, see our playlist: aka.ms/dataexposedmvps
To check out even more Data Exposed episodes, see our playlist: aka.ms/dataexposedyt
🔔 Subscribe to our channels for even more SQL tips:
Microsoft Azure SQL: aka.ms/msazuresqlyt
Microsoft SQL Server: aka.ms/mssqlserveryt
Microsoft Developer: aka.ms/microsoftdeveloperyt
#AzureSQL #SQLServer
Пікірлер: 7
Is there a sperate video which goes through setting the actual pipeline up?
Trying to do this but really hard finding a walk though on making the yaml file. All videos I keep coming across already have the pipeline configured. I guess I will pause the vid and try copying what I see.
Great stuff! Thank you!
Hello, thanks for the tutorial. I would like to know how is created the DACPAC file exactly, is it during the commit ? Or do we have to publish the project ?
We generate differential script instead of dacpac so it can be reviewed before deployment. And in the deployment we use sqlcmd to apply script
@bibuserafim4670
5 ай бұрын
Sharing is caring xD?
I would use a deployment job for the publishing of the DACPAC rather than a simple task. You have more options and better visibility this way.