Abstract:

In this all day training session you will learn the importance of getting both your application and database code into version control, how various tools can be used for automated continuous integration processes that will then feed into an automated release & deployment process for your database.

The demonstrations will take a database based application and deploy it in a Continuous Delivery pipeline utilising industry tools, such as SQL Server Data Tools (SSDT), Redgate SQL Toolbelt, Visual Studio Team Services (VSTS), Git source control, Octopus Deploy, Docker and the Azure platform. The demonstrations will showcase alternative methods that can help achieve a Continuous Delivery deployment pipeline.

DevOps has revolutionised software development and deployment, where companies have utilised Continuous Integration and Continuous Delivery to improve the speed and quality of their deployed applications in production.

DevOps does not just relate to Application Developers.

For too long Database Developers and Database Administrators have thought that the efficiencies and gains of implementing DevOps and agile principles are too hard for databases. Data is a key component of any application, changes in a database can affect the whole system, if the database is neglected this can result in it being the weakest link in a deployment pipeline.

Because application changes are not being synchronised with the database and the lack of automated versioned changes the efficiencies gained in application deployments can be lost when it comes to deploying to the database.

Modules:

Module 1

Introduce DevOps principles.

Module 2

Database Lifecycle Management, source control and connecting a database to it.

Module 3

Infrastructure as Code, Test Driven Development & Continuous Integration – building databases from code and automating builds using source control.

Module 4

How to implement Continuous Delivery across multiple staging environments.

Module 5

Using Containers and Azure in a database deployment pipeline.

Module 6

Creating a Database Deployment Pipeline with various DevOps tools.

Goals:

* Understand what DevOps is and how it can improve the quality of your software.

* Understand the challenges of database development using DevOps.

* Understand Test Driven Development and it can be applied to database code.

* Understand how to implement a Continuous Delivery process for databases using industry standard tools.

* Understand how to build a fully automated deployment pipeline with containers.

BIO: Hamish Watson (t | b)

Hamish is a Systems Management Specialist, VMware Expert and Microsoft Data Platform MVP with a passion for efficient database & application deployment using DevOps methodologies. His current role is contracting to SQL Masters Consulting as a DevOps Consultant.

He has 20 years in managing large scale systems built on the SQL Server platform. He has been managing SQL Server since SQL Server 2000 and pragmatic approaches to delivering business value to clients 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

Cancellation: