Blog

blog

Resize a SQL Server Transaction Log File Using PowerShell

This post contains a PowerShell script that identifies SQL Server databases with a VLF count that exceeds the limit passed in.  It can output that list or resize log files identified to reduce the VLF count.

Frank Gill by Frank Gill

Accelerated Database Recovery - The Future of the Transaction Log

With SQL Server 2019, Microsoft is introducing a new feature called Accelerated Database Recovery (ADR).  ADR fundamentally changes the way SQL processes transactions, resulting in dramatically reduced time for crash recovery and rollback.

Frank Gill by Frank Gill