Data management is becoming increasingly important can be quite daunting, whether it’s a transactional database for a core enterprise application or a data warehouse that pulls together data from multiple sources. Not only do you have an application and/or database schema(s) that change over time, but it is likely there are integrations between systems, and reports that provide valuable information. That’s a lot to keep track of and coordinate deployments.
This series will break down the components needed to successfully manage development and deployments within your data environment. This list will grow over time to cover more topics, but these are the initial building blocks that can help any organization manage change. Because there is not a single solution to manage database code, this series will explore multiple tools, allowing you, the reader, to decide what will work best in your environment.
Visual Studio SQL Server Database Projects
- Building Block #1 – Manage Database Schemas with Visual Studio SQL Server Database Projects (SDK-Style)
- Building Block – Deploy database schema changes from Visual Studio SQL Server Database Projects
- Building Block – Maintain Development Standards with T-SQL Code Analysis
- Building Block – Break Up Large Schemas Across Multiple Projects
Support Deployment Automation with Azure Services
- Building Block – Retrieve Azure Key Vault Secrets with PowerShell
Azure DevOps Solutions
- Building Block – Automate Database Schema Changes using Azure Pipelines
- Building Block – Manage Azure Data Factory Code in Azure DevOps
- Building Block – Deploy Azure Data Factory Changes with Azure Pipelines
- Building Block – Deploy Microsoft Fabric Changes (Power BI) with Azure Pipelines
GitHub Solutions
- Building Block – Automate database schema changes using GitHub Actions
- Building Block – Deploy Azure Data Factory Changes with GitHub Actions
Leave a Reply