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