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.

The A to Z of Availability Groups

Description

Ever since it was introduced in SQL Server 2012, availability groups (AGs) have been a source of interest, curiosity, and confusion. We’ve hit a point where many are seriously evaluating and looking to use AGs, but they are deceptively easy to deploy. While AGs share some common traits with both database mirroring and clustered instances of SQL Server (FCIs), the feature is its own entity. This full day pre-conference session will focus on getting you up to speed with AGs in SQL Server 2012 and 2014. Some of the major topics include:
  • The real difference between FCIs and AGs – one of the sources of confusion since they both use an underlying Windows Server failover cluster (WSFC)
  • Planning a WSFC for an AG deployment, including things like networking and hybrid scenarios that involve the cloud
  • WSFC quorum for AGs
  • Failure scenarios and how to recover from them
  • Tips, tricks, and best practices for deploying AGs and their administration
If possible (dependent upon venue and cost), an AG lab may be possible during the day. Details will follow.

Learning Objectives

Previous Experience

Tech Covered

Azure, mirroring