Automation, Builds & Containers for DevOps
the ABCD’s of deploying scalable database solutions in Azure.
In this all day training session that is based on using the Azure platform – you will learn the
importance of getting your database code into version control, how various tools can be used
for automated build processes that will then feed into an automated deployment process for
your database and applications.
Database upgrades are often the most complicated part of your deployment process, so
having a robust deployment path and checks before getting to production is very
The demonstrations will take a database and deploy it in a DevOps pipeline utilising many
industry tools, such as Git source control, SQL Server Data Tools (SSDT), Redgate tools,
Azure DevOps, docker containers and the Azure platform. Underpinned by Infrastructure as
Code using Terraform, DSC, and Ansible to deploy and manage your services.
The demonstrations will showcase alternative Open Source Software (OSS) methods that can
help achieve a Continuous Delivery deployment pipeline, including a clever pre-production
verification process for ensuring your production deployment will succeed.Modules:
Module 1 Introduce DevOps principles
Module 2 Introduce Azure SQL Database and Azure SQL Managed Instance
Module 3 Introduce Containers for databases and running SQL Server in Azure Kubernetes Service
Module 4 DevOps for the Database: Source control and connecting a database to it
Module 5 Infrastructure as Code & Continuous Integration: Automating database builds in Azure from source control
Module 6 Test Driven Development – why you need to unit test your database
Module 7 How to implement Continuous Delivery across multiple environments
Module 8 Creating a Database Deployment Pipeline using Azure , containers and DevOps
Module 9 How to deploy a product to multiple client sites with DevOpsTakeaways:
How DevOps can make a valuable difference in deploying database changes to your production systems.
DevOps tooling choices and what questions to ask while making the choice.
Why Azure is a great cloud basedcloud-based platform for your database and provides reduced cost and increased deployment agility.
Real-world use case for running SQL Server on docker containers in Azure.DEMOS:
Demo of multiple DevOps products involved in an end-to-end solution
Demo of building an end-to-end cloud basedcloud-based data platform
Demo of automated builds and automated deployments using Azure and DevOps
Hamish is a Microsoft Data Platform MVP with a passion for efficient database & application deployments using DevOps methodologies.
He has formed his own company – Morph iT – based in Christchurch, New Zealand and provides consultancy services for SQL Masters Consulting – who are based in Brisbane, Australia.
He has 20 years IT experience in managing and deploying large scale databases on SQL Server technologies. He has been managing SQL Server since SQL Server 2000 and pragmatic approaches to delivering business value to end users is his career passion.
Educating and helping others learn is a driver for Hamish and he is a PASS Chapter Leader, International speaker and a repeat guest lecturer at a local university.
John Martin is a Data Platform Engineer working in the financial sector as well as Director-at-Large for the PASS organisation and currently a Microsoft Data Platform MVP. Previously John has worked as a product manager for SentryOne and a Premier Field Engineer with Microsoft UK.
With over a decade of experience working with SQL Server and the Microsoft Data Platform technologies. John has gained a lot of insight and experience on how, and how not, to use SQL Server effectively.