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.

Automation, Builds & Containers for DevOps

Volg deze organisator en blijf op de hoogte van komende evenementen