25th September 2017 - 27th September 2017
Who is it for?
This course is aimed at anyone responsible for SQL Server schema changes.
DevOps is about bringing dev and ops folk closer together, so whether you are a developer, a DBA or anyone else who plays a role in writing, testing or deploying SQL changes, this course will teach you how to deliver more frequently and more reliably as well as how to solve common technical (and cultural) problems.
Bring a laptop as you’ll be provisioned with a private sandbox VM where you’ll set up your own end to end DevOps pipeline. While Git, TeamCity and Octopus deploy will be provided on your VM, attendees can use their own GitHub/VSTS subscriptions if they prefer.
What you will learn
The course agenda is as follows:
Introduction to Database DevOps/Database Lifecycle Management (DLM)
Connecting a database to version control (with Redgate SQL Source Control)
Branching (and merging!) databases
Handling migrations when auto-generated scripts don’t work
Production drift monitoring and alerting with DDL triggers or DLM Dashboard
Building databases with PowerShell and Redgate DLM Automation
Connecting a build server to version control and automating builds
Continuous deployment to a shared integration database for testing
Introduction to unit testing with tSQLt
Integrating your CI builds with DLM Dashboard to verify all production versions have been through CI
How to automate production deployments (while keeping DBAs happy)
Managing deployments with PowerShell, NuGet and Redgate DLM Automation
Connecting a Release Management server to your build server and setting up one-click database deployments
Dry-run deployments and staging environments
Manual review processes, the dos and don’ts
You’ll understand how to manage database changes throughout their lifecycle, which will help you deliver more frequently and more reliably. You’ll also understand how to work much more effectively with other teams at your organisation.
Deployment failures will happen far less often – and you’ll be able to deal with them more easily when they do happen.Cost: £895 (to March 31 2017) £995 (from April 1st 2017) +VAT +VAT
Aldersgate House, 135-137 Aldersgate Street, EC1A 4JA
Cancellations must be submitted in writing, either via email or by post. Registrants whose cancellations are received at least 2 weeks before the beginning of the course are entitled to a full refund minus a £80 processing fee plus any credit card charges incurred. No refunds will be given to registrants who cancel less than 2 weeks before the beginning of the course or who fail to attend.
In the extraordinary case where the course is cancelled a full refund will be given to all paid registrants. Crossjoin Consulting will not refund any other amount paid by registrants to other companies, including travel expenses and hotel reservations.
Chris Webb's Introduction to MDX course was well-run, informative and good value. It gave me a good understanding of the key principles and ideas and how to apply them to real world situations. It was great environment to learn in, with Chris giving excellent practical exercises and having the depth of knowledge to answer to any group questions.