Databases

Free study notes

Sections from the books on databases, free to read:

• Choosing an Azure SQL deployment option: SQL Database, Managed Instance or SQL Server on VMs

  How to pick between Azure SQL Database, Azure SQL Managed Instance and SQL Server on Azure VMs from compatibility and management requirements. AZ-305

• Azure SQL high availability and business continuity: zones, failover groups, geo-replication

  Zone redundancy, active geo-replication and failover groups for Azure SQL, with the RPO and RTO each design gives. AZ-305

• Azure Cosmos DB consistency levels explained

  The five Cosmos DB consistency levels, what each guarantees, and the latency and availability trade-offs. AZ-305

• Always Encrypted, TDE and dynamic data masking compared

  Where each Azure SQL data protection feature works and who it protects data from. SC-500

Glossary

Search the series glossary for SQL, or browse all 2,575 terms.

Books that cover databases

Ultra Transcenders AZ-305: Designing Microsoft Azure Infrastructure Solutions

Choose the right design, and explain why.

Buy on AmazonStudy notes

Free with Kindle Unlimited

Ultra Transcenders SC-500: Implementing End-to-End Security Controls for Cloud and AI Workloads

Know which control enforces it, and why.

Buy on AmazonStudy notes

Free with Kindle Unlimited

All topics