Tag: ReleaseAutomation
tSQLt – Automate Unit Test Execution with Azure DevOps Pipelines
In the previous data recipe, tSQLt for Data Warehousing, test your Stored Procedure, we created our first Unit Test to validate our SQL Server Stored Procedures. In this data recipe, we will dive into the process of Database Unit Testing automation with Azure DevOps. Recipe Overview Recipe Overview Preparation time: 15 minutes Ingredients Why? Before […]
Azure DevOps Pipelines – SQL Server Deploy – One to rule them all
In one of my previous blog posts, I used the SQL Server database deploy task to deploy my DACPAC to SQL Server. Unfortunately, this task became deprecated in Release Pipelines. In this blog post, I would like to share the alternative. Additionally, we will be moving from a Classic Release pipeline to a YAML pipeline. […]
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 Pipelines – Release your Tabular Model without Users & Roles
Problem statement A couple of weeks ago my team & I ran into an issue with SQL Server Analysis Services (SSAS), due to a network split between companies, We weren’t able anymore to manage our SSAS access into our SSAS Tabular Model. Since deploying a Tabular Model using Visual Studio is also overwriting members & […]