Azure SQL Database Fundamentals

Understand the core concepts and architecture of Azure SQL Database.

What is Azure SQL Database?

Azure SQL Database is a fully managed Platform as a Service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and provides 99.99% availability. Azure SQL Database is built on the SQL Server engine, offering familiar functionality.

Key Concepts

• Managed Instance: Offers near 100% compatibility with on-premises SQL Server, suitable for lift-and-shift scenarios.
• Single Database: Provides a fully managed, relational database service that supports common standards, including relational data, JSON, XML, and spatial data.
• Elastic Pool: A cost-effective solution for managing and scaling multiple databases that have varying usage demands and