SSMS + Pipelines | Data Exposed
Microsoft Developer walks through setting up Azure DevOps Pipelines for SQL projects created from SSMS Database DevOps or the VS Code SQL database projects extension, including build, code analysis, and iterative deployments to Azure SQL Database with security basics like firewall rules and passwordless auth.
Overview
In this Data Exposed episode, the focus is on taking SQL database code that is already checked into Azure DevOps and turning it into a repeatable database CI/CD process.
Key areas covered:
Building SQL projects in Azure DevOps Pipelines
- Configure Azure DevOps Pipelines to build SQL projects.
- Use the pipeline as the next step after committing database code from:
- SSMS Database DevOps
- VS Code SQL database projects extension
Code analysis on incoming changes
- Run code analysis as part of the pipeline for incoming database code.
- Use analysis results to catch issues earlier in the workflow.
Iterative deployments to Azure SQL Database
- Deploy changes iteratively to Azure SQL Database from the pipeline.
- Establish a foundation for database CI/CD that can be extended over time.
Security considerations for database CI/CD
- Protect the database with firewall rules.
- Use passwordless authentication for pipeline-to-database access.
Resources
Related links
- Data Exposed playlist: https://aka.ms/dataexposedyt
- Microsoft Azure SQL channel: https://aka.ms/msazuresqlyt
- Microsoft SQL Server channel: https://aka.ms/mssqlserveryt
- Microsoft Developer channel: https://aka.ms/microsoftdeveloperyt