DevOps

Great resources for SQL Server DBAs and Developers learning about SQL Server DevOps with these valuable tips, tutorials, how-to’s, scripts, and more.

Title Author Date
Using Azure Blueprints to deploy Azure SQL Server and Database with Key Vault Secrets Ron L'Esteve2026-05-20
Azure DevOps CI CD using GitHub Repo and Visual Studio Azure SQL Database Project Ron L'Esteve2026-05-19
Database Version Control with Git in Azure DevOps Sebastiao Pereira2025-01-24
Automating SQL Deployments using GitHub Actions – Part 2 Eduardo Pivaral2024-07-01
What is Azure DevOps Olivier Van Steenlandt2024-06-21
GitHub Options to Prevent Saving Passwords in Application Code Eduardo Pivaral2024-05-20
GitHub Actions to Deploy Database Changes After Commit to Main Branch Eduardo Pivaral2024-04-30
Puppet to Schedule and Automate DevOps Tasks with PowerShell Alejandro Cobar2023-05-02
Automate PowerShell Script Execution with Jenkins for DevOps Projects Alejandro Cobar2023-04-04
Publish SQL Database Project without using SQL Server Data Tools Haroon Ashraf2021-05-03
Calculate Team Performance with LeadTime metric using JIRA and GitHub Maria Zakourdaev2021-04-16
Resolve Git Merge Conflict for SSIS Projects Koen Verbeeck2021-02-02
Gitflow Workflow Hotfix Branching for SQL Database Projects Haroon Ashraf2021-01-18
Create Azure DevOps Analytics Visuals with Power BI OData Queries Kenneth A. Omorodion2021-01-13
How to Resolve Merge Conflicts in Git for SSIS Projects Koen Verbeeck2021-01-07
Branching and Merging Strategy in Git for SSIS Projects Koen Verbeeck2020-12-21
Branching Gitflow Workflow SQL Database Projects Haroon Ashraf2020-12-08
Deploy CI/CD Changes for Azure Data Factory with Azure DevOps Ron L'Esteve2020-11-10
Sensitive Data Secured in Azure DevOps Ron L'Esteve2020-10-22
Azure Devops Metrics in Power BI for Analytics Kenneth A. Omorodion2020-10-06
Managing Azure Blueprints with PowerShell Ron L'Esteve2020-09-07
Using Azure DevOps CI CD to Deploy Azure Data Factory Environments Ron L'Esteve2020-08-04
Getting Started with Azure Blueprints Ron L'Esteve2020-07-14
How to Add SSIS Projects to Azure Devops for Version Control Koen Verbeeck2020-07-02
Git Stash SQL Server Database Code Changes using Visual Studio 2019 Haroon Ashraf2019-12-18
SQL Database Project Code Branching in Git Haroon Ashraf2019-10-31
Azure Boards for Project Management Ron L'Esteve2019-06-05
Deploy SQL Database from Azure DevOps with ARM and DACPAC File Ron L'Esteve2019-05-09
Continuous database deployments with Azure DevOps John Miner2019-03-27
Azure DevOps for Agile Projects John Miner2019-03-06
Continuous SQL Server Database Integration with Azure DevOps John Miner2019-02-06
Getting Started with GitHub for SQL Server Developers Nat Sundar2018-12-20
SQL Server Reference Data Best Practices – Part 2 Haroon Ashraf2018-07-27
SQL Server Reference Data Best Practices – Part 1 Haroon Ashraf2018-05-23
Adding Reference Data in Database Continuous Integration (CI) Pipeline Haroon Ashraf2018-04-03
Basic Database Continuous Integration and Delivery (CI/CD) using Visual Studio Team Services (VSTS) Haroon Ashraf2018-02-22
Getting Started with DevOps and SQL Server Daniel Calbimonte2018-02-20
Introduction to Team Foundation Server (TFS) Build for Business Intelligence (BI) Projects Ray Barley2015-04-23
Demystify the Database Project Folder Hierarchy with the Import SQL Script Wizard Rick Krueger2013-08-19
Create Visual Studio Database Project for a SQL Server Database Rick Krueger2013-07-26