SQL Server DevOps Tips
All Tips
- Creating a Visual Studio Database Project for an existing SQL Server Database
- Demystify the Database Project Folder Hierarchy with the Import SQL Script Wizard
Administration
Azure Data Factory
- Deploy Azure Data Factory CI/CD Changes with Azure DevOps
- Using Azure DevOps CI CD to Deploy Azure Data Factory Environments
Azure DevOps
- Azure DevOps CI CD using GitHub Repo and Visual Studio Azure SQL Database Project
- Azure DevOps for Agile Projects
- Continuous database deployments with Azure DevOps
- Continuous SQL Server Database Integration with Visual Studio and Azure DevOps
- Creating Azure DevOps Analytics metrics in Power BI using Pre-Built Analytics Views
- Deploy SQL Database from Azure DevOps with an ARM Template and DACPAC File
- Getting Started with Azure Blueprints
- Managing Azure Blueprints with PowerShell
- Using Azure Blueprints to deploy Azure SQL Server and Database with Key Vault Secrets
Data Model
- Git Stash SQL Server Database Code Changes using Visual Studio 2019
- SQL Database Project Code Branching in Git
Deployment
- Create and Publish SQL Database Project without using SQL Server Data Tools (SSDT) in Visual Studio
- SQL Server Code Deployment from the File System with a Custom Stored Procedure
Development
- Adding Reference Data in Database Continuous Integration (CI) Pipeline
- Basic Database Continuous Integration and Delivery (CI/CD) using Visual Studio Team Services (VSTS)
- Branching with Gitflow Workflow for SQL Database Projects
- Gitflow Workflow Hotfix Branching for SQL Database Projects
- SQL Server Reference Data Best Practices - Part 1
- SQL Server Reference Data Best Practices - Part 2
Integration Services
- How to Add SQL Server Integration Services Projects to Azure Devops for Version Control
- How to Resolve Merge Conflicts in Git for SSIS Projects
Overview
Project Management
Reporting
- Create Azure DevOps Analytics Visuals with Power BI OData Queries
- Measuring Team Performance: Calculate LeadTime metric using JIRA and GitHub data
Security
Source Control
- Branching and Merging Strategy in Git for SSIS Projects
- Resolve Git Merge Conflict for SSIS Projects
System
