Azure SQL Database tier built for very big databases (as much as 128 TB), offering quick scale operations and read replicas across which load is balanced.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Hyperscale in context, with comparison tables and the common traps.
Terms in this definition
- Azure SQL Database
Platform-as-a-service database offered as a single database or in an elastic pool, sized up to 4 TB or 128 TB on Hyperscale. SQL Agent, CLR and queries across databases aren't available.
- Archive
Offline access tier for blobs, cheapest to store yet dearest to access. Reading a blob means rehydrating it first, which can take as long as 15 hours.
- CRUD
Shorthand for create, read, update and delete, the four basic things you do with data. Data-plane roles in Azure Cosmos DB, for instance, authorise those operations on items.
- ELT
Extract, load, transform: raw data lands in the target system first and is transformed there. See ETL for the opposite order.
Related terms
- OLTP
Online transaction processing, workloads dominated by large numbers of small reads and writes, as handled by Azure SQL Database Hyperscale for instance.
- Serverless
Compute tier for single Azure SQL databases that scales automatically, pauses when idle and charges by the second. It is offered in General Purpose and Hyperscale, not Business Critical, and reserved capacity does not apply.