All topics and tags

Azure SQL Managed Instance

6 articles tagged Azure SQL Managed Instance.

  1. Azure SQL Database Backups: Point-in-Time Restore, LTR and Geo-Restore

    Set PITR retention and backup redundancy, add a long-term retention policy, and run point-in-time, deleted-database, LTR and geo-restores for Azure SQL Database and Managed Instance.

    Databases & HA13 min read
  2. Azure SQL Database vs Managed Instance vs SQL Server VM: How to Choose

    Compare Azure SQL Database, Azure SQL Managed Instance and SQL Server on Azure VMs on compatibility, high availability, limits, cost model and management, then pick one with a repeatable assessment.

    Databases & HA14 min read
  3. Azure SQL Entra Authentication: Entra-Only Mode and Managed Identity

    Replace SQL logins on Azure SQL Database and Managed Instance with Microsoft Entra ID: set the Entra admin, create users for groups and managed identities, then enable Entra-only authentication.

    Databases & HA11 min read
  4. Azure SQL Failover Groups: Configure Geo-Failover for Database and MI

    Create Azure SQL failover groups for SQL Database and Managed Instance, point apps at the listener endpoints, choose a failover policy and run planned and forced failover drills.

    Databases & HA13 min read
  5. Azure SQL Managed Instance Link: Near-Zero Downtime Migration Runbook

    Migrate a SQL Server database to Azure SQL Managed Instance with the Managed Instance link: prepare SQL Server and the network, seed with SSMS, check lag, then fail over and cut over.

    Databases & HA12 min read
  6. SQL Server 2016 End of Support: ESUs via Azure Arc or Migrate to Azure SQL

    SQL Server 2016 left extended support on 14 July 2026. Compare buying Extended Security Updates through Azure Arc, upgrading in place, and migrating to Azure SQL Managed Instance.

    Databases & HA12 min read