Saving Yourself with Accelerated Database Recovery

2022

TL; DR

The horror stories of rolling back long transactions are now gone thanks to Accelerated Database Recovery. In this session we'll look deep under the hood of ADR and see how it works.

Session Details

We have all heard the stories. Horror story after horror story being regaled from database administrators all over the world of waiting for hours or sometimes days for a rollback operation to complete. DBA's hoping beyond hope that the rollback finishes soon before someone else gets the notion to reboot the server. Thankfully, with the release of SQL Server 2019, comes the one feature that will save us all from hearing about future horror stories. Accelerated Database Recovery or also known as "ADR". This great enhancement in SQL Server, which changes the way that we view transaction rollback, will undoubtedly prove invaluable in your arsenals of tricks! Buckle up. We're gonna go deep into the guts of ADR in this session. You are - • A total nerd to who likes to know how things work • Are not afraid to dive deeper into the internals of SQL Server • Are not afraid of tools like profiler, extended events, or debugger tools You will learn - • How to enable it • What the components are • How ADR works under the hood • When you wouldn't want to implement it Don't be the protagonist in a rollback horror story! Learn ADR and save the day! After all, the time you save might be your own!

3 things you'll get out of this session

John Morehouse's previous sessions

Mastering SQL Server Performance & Optimization Strategies

Everyone wants their database to go faster, whether it's reducing ETL process hours, shortening report runtimes, or optimizing critical OLTP queries. Learn how to master tuning techniques, regardless of the scale, in this full length training day.

Soaring to New Heights with Accelerated Database Recovery

In this deep technical session, we will uncover the mechanisms of accelerated database recovery that allow for a much smoother flight in the journey of database recovery.

Azure Infrastructure - What Not to Do

This session will high light things I've seen in Azure SQL implementations that have caused issues. Attendees will learn from the mistakes of others to ensure a smooth Azure flight of their own.

Banishing Slow Queries with Intelligent Query Processing

An overview of the performance enhancing Intelligent Query Processing features in SQL Server 2019 as well as including some new SQL Server 2022 items,

Tales from the Field - How to Avoid Burnout

In the fast paced "always plugged in world" we all live in today, getting burned out is something that you will most likely experience. That feeling of emotional and physical exhaustion that leaves you overwhelmed, trapped, defeated and stagnant can be unbearable. Taking the time to learn how to avoid burnout can be game-changer for your mental health, motivation, and productivity. In this 20 minute session, we will discuss ways to help prevent that burn out.

Switching Careers: From PT to IT

The biggest risk in life is not taking one. Would you switch careers in the middle of the pandemic to a field that you have no experience in? That is exactly what Yuki did: he was on the brink of starting his doctorate for physical therapy when he decided to make the last minute change to become a DBA. Yuki and his mentor, John Morehouse, both found themselves in unique positions on opposite ends of their careers with a long road ahead of them. Listen to Yuki's unique journey of becoming a DBA and hear John's advice on how to mentor someone from early days.

10 Productivity tools in 20 minutes

You are busy, we are busy, everyone is busy. These are the tools that two busy consultants use to improve their productivity. We want to tell you about the tools that we use; that maximise our time, simplify our life, reduce our key strokes and generally make us appear more amazing. So that you can use them too. We have 20 minutes, so we wont go into much detail but we have some good quick stories to tell.

There is a time and a place for everything

There is a time and a place for everything. John and Rob, being consultants, often say "Well, it depends" Lets talk about some of the times when the "rules" may not fit

Designing Azure Data Disaster Recovery Strategies

Unfortunately, disasters can affect cloud technologies and if you are't prepared for it, the results can be painful. Let's discuss ways to implement Azure SQL disaster recovery techniques to help protect your data!

Getting Started with Learning Azure

Join three Microsoft Data Platform MVPs to discuss the best approach with building your Azure skills. You will learn the best approaches to gaining the skills you need to function in a cloud world.