Azure SQL Always Encrypted: running range queries on data the database can't read

adnan_hashmi · x · 2026-11-13

Microsoft's Azure SQL team explains how Always Encrypted lets SQL Server run real queries—including range comparisons and LIKE patterns—against data it never holds keys for. Encryption at rest only stops someone stealing the disk; it does nothing against administrators of the running server, since databases decrypt data into memory to operate. That gap matters greatly for health records and financial data where the cloud operator is in the threat model. The SIGMOD 2020 paper bluntly claimed SQL Server was the first and only industrial-strength database offering this protection.

Original post →

More from Infra

Infra channel →