Saving Yourself with Accelerated Database Recovery

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!