Session room

The Agenda

Agenda Home

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.

Build Your Own SQL Server HADR Test Lab (on your Laptop!)

Description

Are you struggling to understand SQL Server High Availability?
Would you like to build your own test environment?
Would you like to practice fail-overs, adding or removing Availability Group Replicas, Cluster Storage Migrations or play with Hybrid deployments -all from the comfort of your own arm-chair?

Have no fear, for in this demo rich pre-conference I will explain how you can build your own "High Availability" environment in the safety of your own laptop *1, home network or work test network.

We will start from nothing and configure your lab from the ground up until we have a fully functional working Virtualized Domain, Availability Group Replicas and even a multi-instance SQL Server Failover Cluster and then start playing with them to destruction.
By the end of the day you will not only learn the fundamentals of SQL Server High Availability, but will also understand more advanced topics such as:
  • Deployment and builds
  • Cluster troubleshooting.
  • Hybrid deployments and Interoperability.
  • Availability Group Monitoring and Performance.
  • Virtualization for High Availability.
  • New features in Windows 2016/ SQL 2016
*1 Please note that deployment on a single host is for testing purposes only (in case that wasn't obvious!)


Take aways:
Attendees to this session will receive access to a set of scripts, notes and a pre-built Hyper-V time-limited virtual lab for your own testing and enjoyment.


Audience:
Attendees will not be expected to have prior knowledge of High Availability, Virtualization, and Operating System configuration and Networking, but a basic understanding of these concepts will lessen the learning curve when we come to implement those things.

Learning Objectives

Things I will need

Tech Covered

performance, high availability