Home Automation Trojan Horse

My Hub

SmarthThings has been my hub for home automation for years. I got it well before Samsung bought it. It very much had a RadioShack feel…with the GitHub integration that was supported by a large community. I am still very much sold on the product.

Buyer Beware

However, their is definitely a “buyer beware” on buying products that integrate with it or any of the other major platforms.

Not all integrations are created equal.

Copy Database from Azure Managed Instance

Background

There is a fair amount of documentation how to restore a database from a conventional Microsoft SQL Server instance to a cloud-based, Azure SQL Managed Instance.

The reverse is not true.

Short answer is that you cannot restore from Azure SQL Managed Instance to a self-hosted instance. In my situation, I need to a backup to send to a vendor who only had the self-hosted kind.

Prerequisites

Install SQLPackage.exe. The download is available on Microsoft’s website.