Please enable JavaScript.
Coggle requires JavaScript to display documents.
4.2 Implement Azure SQL Databases - Coggle Diagram
4.2
Implement Azure SQL Databases
Relational Databases
Data is stored as a collection of data items with a predefined relationship between them
Data is stored in rows & columns.
Each row has a unique key.
Each column of a row holds the values of an entity or object.
ACID Compliance
A
C
I
D
PaaS Managed Database offerings
Azure
SQL Database
Azure
Synapse Analytics
(
Big Data analytics and enterprise data warehousing
)
Open-Source Engines
MySQL
PostgreSQL
MariaDB
Azure SQL Database
Types
Elastic pools
Managed instance
Single database
Purchasing Models
DTUs (Database Transaction Units) model
vCore (Virtual Core) model
Settings
Database Server
A
database server
is a logical construct that acts as a database container
Logins, firewall rules, auditing, backups and security policies apply at a server level, but
you can overwrite them for individual databases
Public endpoint
Backups
Automated Backups
Long-Term Backup Retention
(LTR)
Manual backups
Automatically encrypted at rest using transparent data encryption (TDE).
Read scale-out
Security
Server-level
Database-level
Azure private link
Access control
Data protection and encryption
Advanced threat protection
Auditing
Azure SQL Database Managed Instance
High availability
Auto-failover group
Migration ?