For Azure Database for PostgreSQL and Azure Database for MySQL alike, the fully managed way to deploy, with fine control over settings and how the database is run.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Flexible Server in context, with comparison tables and the common traps.
Terms in this definition
- Azure Database for PostgreSQL
Azure's managed PostgreSQL. It grows by scaling up and by adding read replicas rather than multi-master writes; to spread writes horizontally you use its elastic clusters feature, based on Citus.
- Azure Database for MySQL
Managed Azure hosting for MySQL Community Edition relational databases, now in its flexible server form. Azure handles backups and patching, offers zone-redundant high availability, and it is often chosen for LAMP stack applications.
- Fully managed
An Android Enterprise setup for company-owned devices that one person uses only for work, with Intune in control of the entire device.
- CONTROL
Granting this on a securable gives all other permissions on it too, making it the most powerful SQL permission. At database scope that includes UNMASK and ALTER ANY MASK. Warehouse access through the Admin, Member or Contributor workspace roles carries it.
- OVER
Gives a T-SQL window function its window: PARTITION BY, ORDER BY and, if wanted, a ROWS or RANGE frame. Rankings and running totals can then be worked out while every row is kept.
- Schema
The middle part of a Unity Catalog name (
catalog.schema.table), grouping tables, views, volumes, functions and models inside a catalog. A grant on it covers everything in it now and later, and nothing inside can be reached withoutUSE SCHEMA.
Related terms
- Microsoft Entra administrator
On a PostgreSQL flexible server, an Entra user, group, managed identity or service principal granted privileges equal to the original server admin, including managing local and Entra roles. Multiple can be set.