Workflows of Highly Functional App & Data Engineering Teams
summary
Maps data into a bronze/silver/gold medallion and shows concrete tooling for each step: use Azure Data Factory for orchestration, store schema as a SQL Server database project producing DACPACs, run linting with tsqllint, build & publish with SQL Publish and SQLCMD, and test with tsqlt and an xUnit test runner. Pipelines deploy to ephemeral SQL containers (SQL on Linux) for CI, reviewers inspect generated incremental scripts, and a beverage customer gains an estimated 8% revenue uplift (~$440M) from these changes.
AI-written summary · about
chapters (8)
- 0:00Welcome
- 2:36Medallion strategy explained
- 10:02Bronze silver gold realities
- 22:05Declarative SSDT development
- 37:53CICD pipelines for database deployments
- 47:47SQL Server testing automation
- 58:14Data API Builder workflows
- 1:00:22Database change management
related talks
51mWorkflows of Highly Functional App & Data Engineering Teams
50mWorkflows of Highly Functional App & Data Engineering Teams
48mConnecting the dots of Azure SQL DevOps
01h 09mAzure SQL Database Development Inner and Outer Loops
56mDataDevOps for the Modern Data Warehouse on Microsoft Azure
50mA Deep Dive into DevOps Practices with Azure SQL
01h 00mDevOps for Your Relational Database Foundations
22mAdvanced Azure DevOps With Containers and Pipeline As Code