Azure SQL or Azure Managed Instance for Database normalization

Kman 41 Reputation points
2021-02-05T13:20:26.173+00:00

Hi All. For Database Normalization 3NF I wanted to know in Azure which one is recommended to use Azure SQL Database or Managed Instance. I just wanted to know the pro and cons for each one.

SQL Server on Azure Virtual Machines
Azure SQL Database
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 100.9K Reputation points MVP
    2021-02-05T22:47:43.233+00:00

    Third normal form or not has no relation the choice between Azure SQL Database and Azure MI.

    I think Azure SQL Database would be your first choice, not the least from a price perspective. But you would go with Azure MI if you need things not supported in SQL Database. (CLR, Service Broker, Cross-DB queries, Agent to mention a few things.) Also, if you are doing a lift-and-shift from a on-prem solution, MI can be less pain than going to Azure SQL DB.

    But 3NF or not has nothing to do with it.

    1 person found this answer helpful.