Azure SQL Server DBA

Azure SQL Database Specifics (Logical Server & Limits)

Question

Azure SQL Database logical server versus SQL Server instance: what is the administrative boundary?

Answer

A logical server is an Azure control-plane container for SQL Database databases, logins, firewall policy, and server-level metadata. A SQL Server instance provides instance-scoped engine features. Use a logical server for database PaaS; use Managed Instance when instance scope is required.

This is 9 of 19 free samples for Azure SQL Server DBA.

More Azure SQL Server DBA topic samples