Video unavailable

SQLBits 2026

SQL Server Versioning Explained

Version store, Accelerated Database Recovery, Optimized Locking, and RSCI. What do these all have in common? Versioning. In this session the mysteries of SQL Server versioning will be unlocked.

Version store, Accelerated Database Recovery (ADR), Optimized Locking (OL), and RSCI. What do these all have in common? Versioning. In this session the mysteries of SQL Server versioning will be unlocked. You will learn the internals of how it all works, what to use and when, and examples including how to debug it. And we will bring the numbers so you will see exactly how your SQL workload will be affected by using versioning. You will walk aways not just learning how things work but details to help you decide whether you should use options like ADR or OL.

Speaker

Bob Ward is a Principal Architect for the Microsoft Azure Data SQL Server team which owns the development and servicing for all SQL Server versions. Bob has worked for Microsoft for 26 years supporting and speaking on every version of SQL Server.

Bob Ward's Sessions

Inside SQL Server 2025 Part 1

Inside SQL Server 2025 Part 2

SQL Server Versioning Explained

Inside the SQL Server Transaction Log - Part 1

Inside the SQL Server Transaction Log - Part 2

Keynote: Transform Data into Competitive Edge with Azure

A Deep Dive into SQL database in Microsoft Fabric

SQL Server 2025 Community Edition

SQL Server 2025 Engine Deep Dive

SQL Server 2025: The AI-ready enterprise database from ground to cloud

Meet the Azure Data Leadership team

SQL Server 2025 and AMD in the era of AI

SQLBits 2024 Opening Keynote

What You Should Know About Always On Availability Groups

Welcome to the world of SQL Copilots

Come see your SQL Perfmon in the cloud

The Microsoft Data Leadership Panel

SQL Server and Windows Server Better together on Azure

Meet the PG: SQL Leadership

Ask the Expert - Group A (Fri, 16:20 to 16:40)

Debugging SQL Server

The SQL Leadership Panel

SQL Server 2022 and the Wheel of Power

SQL Server 2022 hidden gems

The Kingdom of AdventureWorks Calls for Aid

Meet the PG: SQL Leadership

Platform Innovations with SQL Server 2022 + Intel

Introducing SQL Server 2022

How to Build Secure, Scalable, and Highly Available Applications with Azure SQL Database

SQL Server 2022: The hybrid data platform

AMA with the Microsoft Engineering team hosted by Bob Ward

Learn SQL through architecture

Meet the PG: Azure Data

SQL Server 2019: The Modern Data Platform

Inside SQL Server on Kubernetes

SQL Server to Azure SQL: Performance and Availability

Inside SQL Server 2019

Inside SQL Server Containers

Inside SQL Server 2019 Polybase

Experience SQL Server on Linux and Containers

Experience SQL Server 2017: The Modern Database Platform

Adaptive query processing in SQL databases

SQL Server 2016 It Just Runs Faster

Enhancements that will make your SQL Server roar-SP1 Ed.

Keep Your Environment Always On with SQL Server 2016

Troubleshooting the Memory of SQL Server

Deploying SQL Server with Microsoft Azure Virtual Machine

Windows Azure SQL Database Troubleshooting