22-25 April 2026
SQLBits 2013

Moves Like Jagger: Upgrading to SQL Server 2012

Upgrading SQL Server is one of the most challenging and risky operations that you will perform as a DBA. Make the wrong move, and you could be heading for the exit. In this diverse session, we'll take an in-depth look at moving to SQL Server 2012.

Upgrading SQL Server is one of the most challenging and risky operations that you will perform as a DBA. Make the wrong move, and you could be heading for the exit. In this diverse session, we'll take an in-depth look at moving to the SQL Server 2012 platform and review the upgrade strategies available for a smooth and successful move.

We'll cover preparing and reporting for upgrade, upgrade strategies, performing the upgrade, and how to know the upgrade was successful. And we'll explore some advanced scenarios, including SQL Server 2012 on Server Core, preparing for AlwaysOn availability groups, upgrading your SQL failover cluster, and storage migration. After this session, you too can have “moves like Jagger

Speakers

Mark Broadbent

tenbulls.co.uk

Mark Broadbent's previous sessions

2 Fast 2 Furious - designing for speed, concurrency, and correctness (20 min edition)
Learn how to design for speed, concurrency, and correctness and avoid common database development pitfalls.
 
Introduction to continuous integration and delivery with Azure DevOps (20 min edition)
Learn how to use Azure DevOps for your development and CICD processes
 
SQL Server Always On for Dummies
In this session, we will explain how to plan for, deploy, and manage Availability Groups from the ground up in easy to understand examples and demos.
 
Persistence is Futile-Implementing Delayed Durability
In this session, we will investigate how SQL Server implements transactional durability in order to understand how Delayed Durability bends the rules to remove transactional bottlenecks and achieve improved throughput.
 
Ye Olde Cluster Curiosity Shoppe-Clustering Tips & Tricks
Welcome to the strange and mysterious world of SQL Server Failover Clustering and enter Ye Olde Cluster Curiosity Shoppe where we will reveal a miscellany of top tips, tricks and advice gained from nearly two decades of installing and troubleshooting
 
Moves Like Jagger: Upgrading to SQL Server 2012
Upgrading SQL Server is one of the most challenging and risky operations that you will perform as a DBA. Make the wrong move, and you could be heading for the exit. In this diverse session, we'll take an in-depth look at moving to SQL Server 2012.
 
Enter the Dragon: SQL 2012 on Server Core
In this session we shall demonstrate configuration, installation and administration of SQL Server 2012 on Server 2008R2 Core. We shall discuss Command line and PowerShell configuration, Installation of SQL, Remote Administration and Clustering.
 
SQL Server Clustering for Dummies
Are you uncomfortable with the idea of SQL Server Clustering? Do you currently use it and are scared to go near your Clustered Instances and their physical hosts? Stop worrying and learn the "Dark Art" of SQL Server Cluster administration.
 
READPAST & Furious: Transactions, Locking and Isolation
In this session we will investigate SQL Server concurrency and reveal some very surprising and thought provoking behaviors.
 
Thinking outside the Box. Learning a little about a lot
Generalize your skills so you can specialize on SQL Server.