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.
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 important.
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.
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 DevOps
Takeaways:
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 based platform for your database and provides reduced cost and 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 based data platform
Demo of automated builds and automated deployments using Azure and DevOps
Biography
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.