22-25 April 2026
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.

Speakers

Jerry Nixon

jerrynixon.com

Jerry Nixon's previous sessions

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.
 
A Deep Dive into DevOps Practices with Azure SQL
Explore the intricacies of DevOps practices tailored for Azure SQL in this demo-heavy session, highlighting both the inner and outer development loops. Embark on a journey through the essential principles of Database version control, Immutable Database Infrastructure, Schema Management, Testing, and Seamless CI/CD. Bid farewell to the notorious "But it worked on my computer!" dilemma by embracing robust DevOps practices, fostering trust and efficiency across your development cycles—from local environments to the expansive cloud. Navigate the array of Azure SQL tools for DevOps practices with potent command-line tools, and uncover seamless integration with industry-leading third-party tools such as GitHub Actions, Codespaces, Terraform, and extensions for popular IDEs like VS Code and Azure Data Studio.
 
A Deep Dive into Microsoft Fabric Data Warehouse
Deep Dive into Data Warehousing in Microsoft Fabric. Explore the intricacies of Microsoft Fabric Data Warehouse, unraveling its capabilities and demonstrating effective strategies for its utilization.