Articles

[SQL 4.1] Build Sheet: Migrating to a SQL Server Azure VM

Build the target properly, move a 2012-era estate onto it with the Arc portal migration experience or with backup to URL, register the IaaS extension, set the license type deliberately, and land the database at compatibility level 110 with a baseline before anything is raised.

[SQL 3.1] Build Sheet: Migrating to Managed Instance

Two real paths onto a managed instance: a native restore from URL for the old estate that nothing else will reach, and the Managed Instance link for anything from 2016 SP3 upward. Version floors, the certificate work the docs gloss over, and a cutover you can rehearse.

[SQL 2.1] Build Sheet: A First Azure SQL Database, Migrated

Provision a logical server with Entra-only authentication and no public endpoint, move a real line-of-business database off an ageing 2014 box, re-found its logins on Entra, and rebuild its overnight job as an elastic job. The database side, end to end, reproducible from the text.

[SQL 1] SQL Server in Azure: Four Options and One Decision

Azure SQL Database, Managed Instance, SQL Server on an Azure VM, and SQL Server enabled by Azure Arc are four points on one gradient of control. What each one actually is, who holds authority for patching and backups and the engine version, and why the decision is rarely about cost.

[BP 1.5] The Entra ID Quick Checklist

The whole Entra baseline compressed into a list you can run down in an afternoon. Every action the reasoned articles defended, grouped by the eight control-plane domains and tiered by obligation.