Category: Automated Deployments

  • Visual Studio SQL Server Database Project – Lookup Data

    Visual Studio SQL Server Database Project – Lookup Data

    Lookup tables are defined and populated early in development to support other development efforts. Functionality at other layers in the solution can be driven off lookup values. Deploying lookup data and keeping it consistent between environments is critical to reducing issues.

  • Visual Studio SQL Server Database Project – The Basics

    Visual Studio SQL Server Database Project – The Basics

    Visual Studio has long had a solution to manage a database’s schema, SQL Server Database Projects. Initially a part of the SQL Server Data Tools add-on, it’s now a feature in the Visual Studio installer for 2022 (and since 2019). Building the projects results in a DACPAC being generated. This is consumed by sqlpackage.exe to…

  • Automating Database Solution Deployments – Introduction

    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

    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.