Authors

Frank Gill

Frank Gill

Contributions by Frank Gill

Migrating SQL Server to Azure: What Should You Migrate?

Once you have answered the question "Why should I migrate SQL Server to Azure?", you need to determine what you will migrate.  This post contains methods for inventorying your SQL Server estate and figuring out what to migrate.

Frank Gill by Frank Gill

Why Migrate SQL Server to Azure

When making the decision to move SQL Server workloads to Azure, there are a series of questions that need to be answered.

  • Why are you migrating to Azure?
  • What are you going to migrate to Azure?
  • Where will you migrate in Azure?
  • How will migrate to Azure?
  • When will you migrate to Azure?

The answer to the first of these questions is extremely important to answering the others.  In my experience, it is often neglected.

Frank Gill by Frank Gill

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

SQL Server Availability Groups and Automatic Seeding

Microsoft released Availability Groups (AG) as a feature in SQL Server 2012. Prior to SQL Server 2016, there were two methods of adding a database to a new AG replica. You could provide the Add Database to Availability Group wizard a file share accessible by the primary and secondary replicas.  SQL Server would run FULL […]

Frank Gill by Frank Gill

RIP @sqlsoldier

Today I learned that Robert Davis, aka @sqlsoldier, passed away. Among other things, Robert literally wrote the book on SQL Server mirroring. I met him briefly at SQL Saturday Oregon, but interacted with him frequently via the #sqlhelp hashtag. He was often one of the first people to reply to my many questions about the […]

Frank Gill by Frank Gill

PowerShell Function to Automate Availability Group Failover

I’ve been working with Availability Groups (AG) since their release in SQL Server 2012 and have always wanted to leverage PowerShell to administer them.  Recently I received a request to develop an automated process for failing Availability Groups over gracefully prior to server patching.  Believe it or not, but a hard shutdown of the primary […]

Frank Gill by Frank Gill