Benefits and Usage of Database Resources

https://www.youtube.com/watch?v=4sQOF9fSOAU&list=PLlVtbbG169nED0_vMEniWBQjSoxTsBYS3&index=20

SQL Server

  • Fixed schema

Azure SQL DB

  • PaaS

Azure SQL Managed Instance

  • Runs inside your vNet

  • Great compatibility with on-prem SQL

Microsoft also exposes MySQL and PostgreSQL as managed offerings

PostgreSQL has something called CITUS, which is a hyperscale offering that shards data across multiple servers

Cosmos DB

  • Multiple models

  • Multi consistency

    • Document - SQL, MongoDB

    • Column - Cassandra

    • Table

    • Graph - Gremlin

PreviousBenefits and Usage of Storage AccountsNextData Movement and Migration Options

Last updated