The Agenda

Summary

This seminar extends the Devops for Data 101 session to build out your automated solutions that are repeatable and reliable. We will look at the more complex, real world problems such as more complex testing, handling different environments or client configurations, data replication, CDC and server level objects.

Create/rebuild environments for development and testing on demand. Promote changes between environments and understand what and why the database has changed.

Improve your build and release cycle through automation and testing to minimise downtime and increase confidence in releases. If you haven’t already have started on the DLM journey, then it is advised that you attend the DLM 101 course first to give you the foundations for this course.

Why should I attend
You meet any of the following criteria:

• Attended the 101 and want to complete your knowledge in order to deal with the common deployment scenarios
• Currently have source control but lack deployment automation
• Have database releases that are too slow and/or unreliable
• What to create dev/test environments on demand from scratch
• Have multiple environments/clients with different configurations
• Have a database solution that consists of more than a single database

Breakdown of Content
This seminar covers the next set of skills to implement database lifecycle management (DLM)

• Combining deployment patterns to handle complex deployments
• Options for managing static and setup data
• Packaging your database and versioning
• Creating environments on demand
• Composite/shared schemas for large teams
• Generating code from your schema, i.e. CRUD procs
• Managing complex data movements
• Improving your deployment time
• Non database objects, sql agent jobs, linked servers, logins.  

What you will achieve by the end of the day
You will understand how to:

• Completed an automated build and deployment using VSO
• Understand whats needed for most database deployments
• Promote database builds through environments
• Deploy complex objects incrementally
• Manage refactoring and data movements

Pre-requisites
Experience of Source Control and SSDT Knowledge of modifying SQL Server objects

Speakers
The day will be led by a number of speakers from sabin.io including Simon Sabin and Simon D'Morias