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.
Upgrading to Microsoft SQL Server 2014
Description
An upgrade these days is not always a simple case of backup and restore or upgrading the software in place as it used to be. Rigorous planning is needed to ensure a successful project, ranging from gathering the business requirements, understanding the scope and performing the discovery phase all the way through to the planning testing and migration.
In this session we will discuss how business requirements help drive upgrade approach. We will look at the free tooling that is available for SQL Server environment analysis and enumerate the upgrade paths for different version of SQL Server. Moving through the stages to identify what to look for and how to capture data on a pre-upgrade environment, and interpret the data to scale a new environment. We will address design for SQL Server on-premises and in Microsoft Azure VMs. Finally we will cover validating your upgraded SQL Server environment. We will look at the options for side-by-side and in-place upgrades, and approaches such as mirroring, log shipping, backup and restore, and detaching and attaching the files.
In this session we will discuss how business requirements help drive upgrade approach. We will look at the free tooling that is available for SQL Server environment analysis and enumerate the upgrade paths for different version of SQL Server. Moving through the stages to identify what to look for and how to capture data on a pre-upgrade environment, and interpret the data to scale a new environment. We will address design for SQL Server on-premises and in Microsoft Azure VMs. Finally we will cover validating your upgraded SQL Server environment. We will look at the options for side-by-side and in-place upgrades, and approaches such as mirroring, log shipping, backup and restore, and detaching and attaching the files.
Learning Objectives
Previous Experience
Tech Covered
Azure, backup