The Virtualization Virtual Group is dedicated to better management of SQL Servers in virtual environments such as Microsoft Hyper-V and vSphere.

Login to Subscribe

Meeting Details

SQL Server DevOps Simplified with Production Databases

Wed, May 08 2019 17:00 UTC

SQL Server DevOps Simplified with Production Databases

DevOps is based on building an application binary (immutable artifact) that supports a highly reliable, repeatable engineering process. In the case of SQL Server, however, a database is already in production, and isn’t simply replaced (as an app binary), but is upgraded. Current SQL Server DevOps methods use source control to build a “development” database, with schema and objects and static data needed for functional testing. "Near production data" is used in Staging, and finally production is upgraded. This approach involves complexity, and breaks the principle of working with immutable artifacts throughout the process. Our session introduces a new approach to SQL Server DevOps, with production databases used in all stages. Production database clones are delivered more quickly than "built" databases, are more easily integrated with source control, and produces higher fidelity outcomes. Learn how leading enterprises are simplifying SQL DevOps.


Paul Stanton

Co-founder of Windocks, Paul is a former Microsoft engineer who is focused on delivering solutions for SQL Server development and test, including SQL Server containers and database cloning.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids