RousselTMLEARNING

Article · Microsoft Azure: from discovery to expertise

Azure databases

1. Relational #

Managed SQL Server, PostgreSQL, MySQL.

Choosing #

ServiceFor
Azure SQL DatabaseModern applications, serverless or provisioned, elastic
Azure SQL Managed InstanceMigrating SQL Server with near-complete compatibility
Database for PostgreSQL / MySQL (flexible)Managed open source engines, zone-redundant HA

Commands #

az postgres flexible-server create -g rg-data -n pg-app-123 --tier GeneralPurpose --sku-name Standard_D2ds_v5 \
  --high-availability ZoneRedundant --version 16 --public-access None
az sql db create -g rg-data -s sql-app-123 -n app --compute-model Serverless --edition GeneralPurpose --family Gen5 --capacity 2

2. Cosmos DB #

Global NoSQL.

Principles #

Cosmos DB is a globally distributed NoSQL database (NoSQL, MongoDB, Cassandra, Gremlin, Table APIs), with multi-region replication and multi-region writes. Throughput is provisioned in request units (RU/s) or serverless; the partition key determines scalability.

Cosmos DB consistency
Session consistency suits most applications.

3. Cache and best practices #

Speeding up and protecting.

Rules #

  • Azure Cache for Redis (or Azure Managed Redis) for sessions and load reduction.
  • Connect with a managed identity and Entra ID rather than passwords.
  • Private Endpoint, TDE encryption, automatic backups and point-in-time restore.
  • Choose the Cosmos DB partition key based on the most frequent queries.
Good practice: The Cosmos DB emulator (Docker image) lets you develop locally; it is used in the optional hands-on labs.

📄 Databases on Azure: Azure SQL, Cosmos DB, PostgreSQL and cache →

My progress

  • ⏱ Estimated time : ≈ 3 min

Sign in to track your progress and take notes. Sign in

💬 Questions about this lesson

No questions yet: be the first to ask for help or share your configuration.

Ask a question about this lesson →

Recommended Articles

Azure storage: storage accounts, Blob, Files, disks and redundancy

Store data on Azure: storage accounts, Blob (hot, cool, archive tiers, lifecycle), Files, Queue a...

Microsoft Entra ID, RBAC and Azure Policy: identities, permissions and governance

Manage identities and access on Azure: Microsoft Entra ID (users, groups, MFA, conditional access...

Azure best practices: landing zone, security, reliability and costs

Best practices for running Azure in production: landing zone and management groups, identities an...

Preparing for the Microsoft Azure Fundamentals certification (AZ-900)

Preparation guide for the AZ-900: format, the three domains and their weightings, notions to mast...

Preparing for the Azure Administrator Associate certification (AZ-104)

Preparation guide for the AZ-104: format, the five domains (identities and governance, storage, c...

Compute on Azure: virtual machines, App Service, Functions and containers

Choose and use Azure compute: virtual machines and scale sets (VMSS), App Service, Azure Function...

Understanding Azure: regions, resource hierarchy, tools and pricing

Microsoft Azure basics: geographies, regions, region pairs and availability zones, the hierarchy ...

Azure networking: VNet, NSG, peering, load balancing and hybrid connectivity

Design networking on Azure: virtual networks and subnets, network security groups (NSG), peering ...

Monitoring and protecting Azure: Monitor, Log Analytics, Defender, Key Vault and Backup

Operate Azure: Azure Monitor (metrics, activity logs, alerts), Log Analytics and KQL, Application...

Support us

♥ SUPPORT US

Support RousselTM Learning

Courses, articles, labs and certificates stay free with no intrusive ads. A voluntary contribution, of any amount you choose, pays for hosting, lab environments and new content.

Contribute with PayPal Any amount · card or PayPal accountLearn more
QR code PayPal
Or scan this QR code with your phone

Thank you, every contribution counts!