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.

by Frank Gill Sep 8, 2020

Running the Data Migration Assistant - Part Three - Jupyter Notebook

This is the third in a series of blog posts on Microsoft's Data Migration Assistant.  It covers running the DMA using PowerShell from a Jupyter Notebook.

by Frank Gill Sep 3, 2020

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.

by Frank Gill Sep 2, 2020

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. 

by Frank Gill Sep 1, 2020

Using relog to Import Perfmon Logs to SQL Server

This post shows how to use the relog utility to import perfmon log files into a SQL Server database quickly and easily.

by Frank Gill Jul 24, 2020

Firewall Settings for Connecting to Azure SQL Databases from an Azure VM

This post describes an issue a client experienced connecting to an Azure SQL Database from an Azure VM through a third-party firewall.

by Frank Gill Jun 26, 2020

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.

by Frank Gill Jan 3, 2020

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.

by Frank Gill Jan 3, 2020

Azure Backup for SQL Server 2019

How to backup your important data stored in SQL is something on the minds of many IT professionals. Recently, Azure announced a new feature for backing up SQL servers running in VMs on Azure.

by Paul Harris Nov 27, 2019

New Additions to Azure Infrastructure as a Service - Microsoft Ignite 2019

Last week, the yearly Microsoft Ignite conference occurred in Orlando, Florida. At this conference, Microsoft brings together developers and IT Professionals to learn what is coming next with Microsoft’s product offerings. Let’s discuss some of the new developments in the IaaC world

by Paul Harris Nov 14, 2019