Skip to main content

Expert Insights

blog

SQL Server


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

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.

Paul Harris by Paul Harris

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

Paul Harris by Paul Harris