SQLBits 2024

Workflows of Highly Functional App & Data Engineering Teams

Explore best practices in enterprise data engineering, focusing on Schema Management, Standards Enforcement, Database Testing, & Automated Deployment. Navigate Microsoft's complex options to achieve change management, observability, & quality at scale. Goals: Master schema control, ensure engineering quality, & streamline delivery through automation.
How does a highly functional development team manage enterprise data engineering? They focus on the core principles of Schema Management, Standards Enforcement, Database Testing, and Automated Incremental Deployment. Microsoft brings an agonizing menu of choices to architects and engineers; they can be a challenge to wade through. This session can help. Let’s review how some of the world’s largest and most critical app & data engineering teams handle change management, observability, and quality at enterprise scale.

Goals: • Understand how enterprise teams manage schema control, including versioning, migrations, and updates, to ensure data consistency across all environments. • Explore how enterprise teams ensure engineering quality through automated testing, code reviews, and standards enforcement. • Learn how enterprise teams automate reliable delivery through continuous integration and deployment, reducing errors and improving efficiency.