SQLBits encompasses everything from in-depth technical immersions to the enhancement of valuable soft skills. The full agenda will be announced in the spring; in the meantime check out the timetable and content we cover below.
2024 Training Days
Presenting 2024’s selection of training days, encompassing a deep dive into a range of subjects with some of the best data trainers in the world.
- 08:00 Registration opens and breakfast served.
- All training days run simultaneously across the venue from 09:00 – 17:00 with co-ordinated breaks.
- All training days include regular refreshment breaks and a lunch stop to rest, recharge, and chat to fellow delegates.
- No evening events planned, but if you’re staying over the night beforehand, why not join us in the Aviator on Monday night to meet the training day speakers for an informal drinks reception.
Dev Ops for Data Intermediate
Description
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
Learning Objectives
Previous Experience
Tech Covered
high availability, CDC, SSDT, DevOps