The SQL Server community is showing a great interest in contains at present, and spinning up containers inside continuous integration pipelines is one of the best ways to use these. Jenkins is a continuous integration engine that has been open sourced, has tremendous third party plugin support, will run on any platform that supports Java and most importantly has very mature support for pipelines-as-code, The focus of the session will be on creating a DACPAC using msbuild and deploying it to SQL Server running inside a container. As the session progresses this simple pipeline will evolve to support: – Multi branch pipelines – tSQLt testing – parallelism – docker volumes.
