Tag: AzureDevOps
-
Automating Database Solution Deployments – Introduction
As a database developer or administrator of a data warehouse or custom application database, deploying changes is a regular occurrence. Whether it is a bi-weekly, monthly, or even quarterly event, a repeatable method is needed, especially for less frequent releases. Even with well-defined written procedures, manual deployments could result in issues coming up. A new…
-
Azure Pipelines – Deploy SQL Changes with Service Principal
Automating deployments with Azure Pipelines comes with security challenges. One of those is deploying DACPACs for Azure SQL DB/MI. We’ll cover how to setup Azure DevOps and Azure SQL to be more secure, using a service principal.
-
Azure Dev Ops – Job-Focused vs Task-Focused
This is the first post in the series, Azure Dev Ops Odds and Ends. The starting page has information about the code environment I’m working with, as well as links to other posts in this series. The first step to consolidate builds into a single pipeline was to gather code from four repositories into a…
-
Azure Dev Ops Pipeline Odds and Ends
When one works in a smaller company, there is an expectation of wearing many hats. As the Data Operations Team Lead, I’m no different. In addition to working with SQL Server, Azure infrastructure, Azure Data Factory and more, I have started to tackle Azure Dev Ops. Specifically, I’m working to enhance, or streamline, existing build…