Databases

• Multiple database services to store a wide variety of data types and volumes.
• Have global connectivity and instant data availability

Azure Cosmos DB

• 📝 Globally distributed (= multiple regions) database service
• Supports schema-less data, stores JSON
• 💡 Good for Always On applications to support constantly changing data.
  • Helps with failover during regional disaster
  • Transparent multi-master replication, 99.999% high availability for both reads and writes
• 💡 Good for data used by & maintained by users around the globe.

Azure Cache for Redis

• Caches frequently used and static data to reduce data and application latency

Azure SQL Database Options

• Azure Database for MySQL: Fully managed and scalable MySQL
• Azure Database for PostgreSQL: Fully managed and scalable PostgreSQL
• Azure Database for MariaDB: Fully managed and scalable MariaDB
• SQL server on VMs: Host SQL servers in own VPNs

Azure SQL Database

• Relational database as a service (DaaS)
• Based on the latest stable version of the Microsoft SQL Server database engine.
• High-performance, reliable, fully managed and secure database

Azure Database Migration Service

• Allows to migrate existing SQL Server to Azure
• Performs all of the required steps.
• Minimal downtime
• Uses the Microsoft Data Migration Assistant
  • Generate assessment reports that provide recommendations

Azure Synapse Analytics

• Formerly SQL Data Warehouse
• 📝 A cloud data warehouse for the enterprise
• Characterized by high resiliency through automatic scaling.
• Massive parallel processing (MPP) to run complex queries quickly across petabytes of data