Monthly Archives: December 2018

Read-Write Secondary in 2019

By |2020-06-25T08:29:42-05:00December 20th, 2018|I'm Your DBA Blog|

Microsoft just keeps knocking it out of the park lately.  The most recent announcement to catch my eye is that in SQL Server 2019, they are introducing Read-Write Secondaries for Availability Groups.  Meaning the end user doesn't have to know the listener name, they can be pointing to a secondary server directly by name and,

Accelerated Database Recovery

By |2020-06-25T08:31:32-05:00December 9th, 2018|Articles, Azure SQL|

Accelerated Database Recovery (ADR) is poised to be one of the biggest updates to SQL Server in the last few years.  ADR introduces in-line row versioning, which allows long running transactions (such as an offline clustered index rebuild, or a large insert/update/delete statement) to be rolled back immediately.  This will help with a few things