From the course: Microsoft Azure Solutions Architect Expert (AZ-305) Cert Prep by Microsoft Press

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Understanding Azure SQL options

Understanding Azure SQL options - Azure Tutorial

From the course: Microsoft Azure Solutions Architect Expert (AZ-305) Cert Prep by Microsoft Press

Start my 1-month free trial Buy for my team

Understanding Azure SQL options

“

- [Instructor] Within Azure, there are several different kinds of SQL, Azure SQL, Azure SQL Managed Instance, or even traditional Microsoft SQL running on a virtual machine. We're going to ignore that last option for now and just concentrate on Azure SQL and Azure SQL Managed Instance. Azure SQL Database was first introduced and abstracted a way, more of the underlying infrastructure and is much more granular in the options you can choose especially when it comes to scaling. Because of this, some applications may not be compatible with Azure SQL Database, therefore we have Azure SQL Managed Instance. This offers less flexibility than Azure SQL Database, but it does offer near 100% compatibility with older legacy databases. We can see on the table, some of the main differences between Azure Managed Instance and Azure SQL Database. As well as those listed here, another big difference is how they are actually integrated…

Contents