This week, I am honored to be speaking at the most excellent 8KB conference. If you aren’t aware of this conference, it’s ran by several members of the SQL Community. It is designed to be a deep dive internals conference. While it started out as internals of SQL Server, over the years it has grown and expanded into other concepts so if you like nerding out to technology, this is a conference that you do not want to miss.
Plus, it’s free to attend as everything is online! This years schedule is set to knock your socks off, plus you’ll get to hear me speak!
Check out this schedule
That schedule is chaulked full of deep-dive goodness and even though I"m speaking, I’ll be attending all of them to learn all that I can!
My Session
I’m going to be doing a deep dive into the internals of how Accelerated Database Recovery (ADR) works. ADR was originally released with Azure SQL Database and subsequently SQL Server 2019. It’s a phenomal feature that, in my opinion, was one of those game changers that really helped to improve the life of database administrators everywhere.
Here’s my abstract -
Accelerated Database Recovery - A Deep Dive Behind the Magic
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.
With the release of SQL Server 2019, a new talisman was conjured that will save us all from hearing about future horror stories. Accelerated Database Recovery or also known as “ADR”. This new mystical feature changes the way transaction rollback performs and will undoubtedly prove invaluable in your arsenals of magical tricks!
In this session, we’ll show you the secret behind it!
You will -
- Learn about new components of the transaction log
- Discover the magic behind ADR
- Determine when you wouldn’t want to implement it
Don’t be the protagonist in a rollback horror story! After all, the time you save might be your own!
Come join us
If you want to nerd out on the internals of things, make sure you register!
I’ll see you online on Thursday @ 1730 UTC (1:30PM EST)!