Authors

Frank Gill

Frank Gill

Contributions by Frank Gill

Create Jupyter Notebook Files Using PowerShell

This post covers using the PowerShellNotebook PowerShell module to creates Jupyter Notebook files from markdown and T-SQL.  It also shows how to convert existing PowerShell and T-SQL notebooks to native code.

Frank Gill by Frank Gill

Running the Data Migration Assistant - Part Two - PowerShell

In the previous post, I introduced the Data Migration Assistant (DMA) from Microsoft.  In this post I will introduce PowerShell modules from Microsoft that can be used to run the DMA against an inventory of instances and databases.

Frank Gill by Frank Gill

Running the Data Migration Assistant - Part One - The GUI

This is the first in a series of three posts about the Data Migration Assistant (DMA).  It describes what the DMA is, how to get it, and how to use the GUI to run an assessment of SQL Server databases for upgrade or migration. 

Frank Gill 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