22-25 April 2026 
Dev Ops for Data Intermediate
2016TL; DR
This extends the Devops for Data 101 session to enable you to handle more complex, real world problems such as more complex testing, handling different environments or client configurations, data replication, CDC and server level objects
Session Details
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:
This seminar covers the next set of skills to implement database lifecycle management (DLM)
You will understand how to:
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
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
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.
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
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
3 things you'll get out of this session
Speakers
Simon Sabin's previous sessions
Maximising everyone's super powers - Panel discussion
In this panel we will discuss approaches with leaders in the field who have first hand experience of managing neurodiversity in the work place. Welcome questions from the audience as to how everyone can maximise their and their teams super powers
Achieving PCI with SQL Server - Don't be the next Sony
This session covers all aspects of what you need to do, to enable the storage of card details in SQL Server and achieve PCI certification.
We will deep dive into the solutions for storing the data securely using SQL Servers encryption functionality
Performance tuning from the field
In this session we will look at some common practices I have seen in the field that cause performance problems. We will diagnose the cause of the problem and the resolution to the problem.
10 things you should never do with SQL Server
In this session we will look at some of the practices that you shouldn't follow when developing a SQL Server database. We will cover items such as query design, table design, indexes, constraints and more.
After this session you will have some practices that you know you should avoid in your SQL Server database if you want the best performance. If you have them you will know what you need to do to resolve them.