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.
Database Administration
Architecting Scalable, Available, and Manageable SQL Server Deployments
Description
Whether you are running SQL Server on premises, in a public cloud, or as part of a hybrid solution that spans both, your solutions must meet three main criteria:
1. Perform well
2. Be up and running meeting the company's availability requirements
3. Be relatively easy to manage - including security
Deployments that are up but are slow, or ones that perform well but are down every other day are useless. Add to that solutions that are complex and hard to manage often break and cause downtime and/or performance issues no matter how good they look in a Visio diagram.
How do you balance performance, availability, manageability, and security to achieve all your goals in a single design for SQL Server? How do you migrate from A to B with minimal downtime? This full day will not only provide tips and tricks on how to achieve successful deployments based on real world experience, but show and discuss relevant features and technologies that you should be aware of no matter how you deploy and use SQL Server - Windows Server, Linux, physical, virtual, IaaS, or PaaS.
1. Perform well
2. Be up and running meeting the company's availability requirements
3. Be relatively easy to manage - including security
Deployments that are up but are slow, or ones that perform well but are down every other day are useless. Add to that solutions that are complex and hard to manage often break and cause downtime and/or performance issues no matter how good they look in a Visio diagram.
How do you balance performance, availability, manageability, and security to achieve all your goals in a single design for SQL Server? How do you migrate from A to B with minimal downtime? This full day will not only provide tips and tricks on how to achieve successful deployments based on real world experience, but show and discuss relevant features and technologies that you should be aware of no matter how you deploy and use SQL Server - Windows Server, Linux, physical, virtual, IaaS, or PaaS.
Learning Objectives
1. Understand the considerations for when to use – and when not to use – the public cloud for SQL Server
2. How to plan availability for SQL Server solutions that are hybrid, IaaS, or PaaS
3. How to ensure that you get the performance required from your SQL Server solutions
Previous Experience
A working knowledge of SQL Server and availability concepts
Tech Covered
Azure, security, SQL 2019, Testing, Azure SQL Database, Managed Instance, Database engine, deployment, AWS, Move to the cloud, gcp, Database Administration, Managing, Monitoring, Optimising, SQL 2022, Platform Agnostic, On Premises, Architecture & Infrastructure, SQL on Linux