AZ-900 Certification Notes

Chapter 7.2 - Azure SQL

Managed Service

Azure SQL is in effect a database as a service. As with other fully managed services, Azure will take care of your hardware and infrastructural level needs. That includes servers, storage, network, and everything else infrastructure-related. Azure SQL sits on top and provides you with the business logic and functions you need. Think of Azure SQL as a fully fledged database solution, where Azure is managing all the parts that don't have anything directly to do, with managing the data in the database.

Migration

• Frictionless Process
  • No changes needed to on-prem databases
• Cost Saving
• Lower Total Cost of Ownership

Built-in Machine Learning

• Optimization
  • Suggestions on how to optimize and improve performance of Azure SQL instances
• Warnings
  • You will get warnings of degrading instances, and if anything out of the ordinary is happening

Cloud Benefits

• Scalability
  • Scale your Azure SQL instances and get high availability as well
• Space
  • Manage huge databases up to 100 Terabytes
• Security
  • Benefit from the built-in security features of the Azure cloud platform

SQL Database vs. SQL Managed Instance

• Azure SQL Database
  • Most like traditional SQL Server
• Azure SQL Managed Instance
  • Aimed at migrating from on-premises