Problems displaying this newsletter? View online.
Database Weekly
The Complete Weekly Roundup of SQL Server News
Hand-picked content to sharpen your professional edge

Azure Resource Mover

Microsoft recently held the 2020 Ignite conference. Just like in previous years, there were many announcements introducing new services and expanded capabilities of existing ones, especially in Azure.

Ahead of Ignite, I was asked to take a test drive of one of the new features, Azure Resource Mover (in preview). It’s easy to move a resource group to another subscription or move a resource to another resource group, but it hasn’t been easy to move a resource to another Azure region. This problem is now solved with Azure Resource Mover which allows you to move a resource such as a VM or Azure SQL Database to another region, and it figures out the dependencies for you.

Why would anyone want to move a resource to another region? Well, it might make sense to move resources closer to end users to decrease latency, maybe the organization has been part of an acquisition or merger and now they need to consolidate resources, or maybe a new region you have been waiting for has opened. There could be many reasons to move a resource to another region, and this new service makes it easy to do. You may be wondering about cost, however, and using this service is free.

I recently wrote a blog post about my experience if you would like to see more details of the process, but I’ll provide an overview here. Instead of using the Azure Portal for the move, you can also use PowerShell or Azure CLI.

  1. Launch the Azure Resource Mover page
  2. Set the subscription, source, destination
  3. Choose the resource to move
  4. Check for and add the dependencies
  5. Modify destination resource settings as required, for example, resizing the VM
  6. Prepare, initiate, and move the resources
  7. Clean up old resources, or keep them in place if you wish

Note that it will take some time, maybe even days, to move a large VM. I’ve never tried to move a VM using the old process, but Microsoft says this new service significantly reduces the time required.

I also moved an Azure SQL Database. There was one big difference: I had to make sure that the target SQL Server service was in place. I already had one in the target region, so I just moved the database into that.

Azure Resource Mover is just one of the many announcements from the 2020 Microsoft Ignite conference!


Kathi Kellenberger

Join the debate, and respond to the editorial on the forums

Redgate University
The Weekly News
All the headlines and interesting SQL Server information that we've collected over the past week, and sometimes even a few repeats if we think they fit.
Vendors/3rd Party Products

Welcome to Redgate Deploy and cross-platform database DevOps

As organizations realize the advantages they can g...


Failing SQL Agent Jobs – Part 4

Here we are, another Tuesday!! It is time for our Fourth and final installment in the Failing SQL Agent Jobs series

5 Ways to Make SQL Server Backups

Last time we discussed 5 backup types for SQL Server. Now I want to introduce you to five ways to make backups in SQL Server...

How SQL Server stores data types: sql_variant

This post looks at a curious data type that isn’...

Find and Modify File Growth Settings for All Databases

I have a client who is challenging me in a lot of ...

sp_RestoreScript 1.7 Released

sp_RestoreScript 1.7 has been released. For information and documentation please visit Changes in 1.7 New Parameters @IncludeCopyOnly – 1 – Copy only backups are included0 – Copy only... The...

Azure DevOps

Running Container Workloads in Microsoft Azure

Containers are being used by more and more organizations to automate build pipelines in their CICD processes. In this article, Mahendran Purushothaman shows how to automate the creation of Docker containers and a Kubernetes cluster in Azure.

Azure SQL Database

Azure SQL Database Compatibility with SQL Server

A long time ago, in early days of the Azure SQL Database in 2015, I wrote this article in which I tried to compare the SQL Server and Azure... The...

Deploying a Database on Azure SQL

Total: 2 Average: 5Introduction Azure SQL Database is a Platform as a Service (PaaS) offered by Microsoft Azure. Hence, you need the Azure subscription to use this SQL Database....

Conferences, Classes, Events, and Webinars

PASS Virtual Summit 2020 Conference Sessions

Whether you are a SQL Server Database Administrato...

Hidden Treasures of SQL Prompt

It is sometimes best to think of SQL Prompt as if it were a Treasure Island. You tend to come across the good things by setting out to discover them. Join us to discover the hidden gold within SQL Prompt.

VMworld 2020 – Top 10 Database Sessions (Part 2)

Whether you are a SQL Server Database Administrato...

We’re ready for the Virtual DevOps Enterprise Summit. Are you?

The DevOps Enterprise Summit, Las Vegas, is back from October 13 to October 15 and, even though it’s virtual this time around, it still promises to be engaging and...


Parse parameter default values using PowerShell – Part 2

Aaron Bertrand continues explaining the evolution ...

Data Science

The Social Impact of Artificial Intelligence and Data Privacy Issues

Like any technology, AI can be used for evil instead of good. Shree Das explains several examples and what should be done to prevent the misuse of data.

DevOps and Continuous Delivery (CI/CD)

How We Ended up with Git

Git is used by many teams for version control. In this article, Dino Esposito takes a look back at the history of source control and how git became the popular tool it is today.

ETL/SSIS/Azure Data Factory/Biml

Custom deployment parameters in Azure Data Factory - Forget Me Not

Last week one of my Azure Data Factory deployment pipelines...

Machine Learning

Five Key Features for a Machine Learning Platform

Click to learn more about co- author Ion Stoica. Click to learn more about co- author Ben Lorica. Machine learning platform designers need to meet current challenges and plan...


What is Oracle ASM to Azure IaaS?

Kellyn Pot'Vin-Gorman explains Oracle Automatic Storage Management and why it’s impossible to do a comparison to Azure IaaS.

Why choose Oracle?

Oracle has been established as one of the top database systems used in enterprises throughout the world. In this article, Cynthia Dzikiti describes her career as an Oracle application...

Performance Tuning SQL Server

Plansplaining, part 11. Merge plans

Welcome to part eleven of the plansplaining series. You will have noticed that this is no longer a monthly series.

Efficiently polling remote data sources

In this article, Edward Pollack describes some of ...

Computed Column Performance in SQL Server

Computed columns may be the cause of hard to track down performance issues. In this article, Robert Sheldon reviews the issues and some ways to get around them.

Starting SQL: Eager Index Spools

Most of the time when the optimizer t...

Capture Execution Plans Only For Long Running Queries

I love questions. Most of all, I love questions I can answer. I spotted this question recently: How can I use Profiler to capture execution plans for queries over...


SQL Server PolyBase Introduction

n this 28th article for SQL Server Always On Availability Group series, we explore the high-availability for the SQL Server PolyBase(SSB) external tables using AG groups.


Power Query installation.

While I was preparing to work in the new (for me) ...

Power BI announcements from Microsoft Ignite (Roundup | Sept 28, 2020)

Thanks for watching this week's Power BI news roun...

Power Query installation.

While I was preparing to work in the new (for me) ...

Power BI FastTrack Recognized Solution Architect 2021 Nominations Open

Are you really, really good at designing Power BI ...

Power BI tips from the Pros – LIVE /w Chris Finlan (Sept 26, 2020) (Member Chat 2nd Half)

Join us live as we answer your questions about Pow...

Exporting Data From Websites For Use In Power BI Using Power Automate UI Flows

As a Power BI developer I know how Power Query makes it easy to get data from web sources, but I also know there are limits to what it...

Professional Development

I Want PASS to Survive

I want PASS to survive. I can say that unequivocally, because this organization has been a part of my career, my job, and my life for twenty years. Many... The...

SQL Server Security and Auditing

Be careful with securityadmin

Over the last week, I’ve seen two discussions where the securityadmin server role was suggested.

Security News and Issues

Tackling Data Breaches Through Information Security Systems

While the terms “Data Security” and “Data Breach” have been around for a long time, they acquired a lot of traction a few years ago with the...


Starting SQL: Unparameterized Strings In Dynamic SQL

Roaster It doesn’t take much to let a bad perso...

Virtualization and Containers/Kubernetes

Installing the Northwind Sample Database on your SQL Server Instance

This post shows how to run a SQL Server Instance on about any computer using Docker Containers.

The SQL Server and Containers Guide

I’ve been blogging about running SQL Server in D...

Running Express Edition in a Container–#SQLNewBlogger

Another post for me that is simple and hopefully s...

RSS FeedTwitter
This email has been sent to {email}. To be removed from this list, please click here. If you have any problems leaving the list, please contact the This newsletter was sent to you because you signed up at Note: This is not the daily newsletter list, and unsubscribing to this newsletter will not stop you receiving the SQL Server Central daily newsletters. If you want to be removed from that list, you can follow the instructions on the daily newsletter.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.


- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -