Month: April 2023
Azure DevOps YAML Pipelines – Deploy to Azure SQL
In my previous blog post, we created an Azure DevOps YAML Pipeline to automate our Database Project Build process. In this blog post, we are going to create an Azure DevOps YAML Release Pipeline for Azure SQL. Quick Overview Prerequisites Step-by-step Example —Download Pipeline Artifact —Deploy Dacpac to Azure SQL —Adding the right trigger Considerations […]
Azure DevOps YAML Pipelines – Building Database Projects
In previous blog posts, I explained how to automate the Database Project Build & Deployment process using Azure DevOps (Release) Pipelines. These blog posts focused on setting up as easily as possible using the Classic Editor. In this blog post, I’m going through the steps of setting up a build pipeline using YAML. Quick Overview […]
Stop SSIS Package Execution
Problem Statement Today, I was working on a SSIS Package that executes a Python script for every day I want to retrieve the data. Since I was reloading data for a couple of months in my development environment, the process took quite some time. I developed my package in Visual Studio 2019 and deployed my […]
Automate your Database Deployments for SQL Server using Azure DevOps Releases
In my previous blog post, Automate your Database Deployments for Azure SQL using Azure DevOps Releases, I described how to automate your database deployments for Azure SQL. Now, in this blog post, we are going to take a look at how we can automate deployments for SQL Server. Since the setup is a bit different […]