Always Encrypted and Confidential Computing
What you'll learn: How to protect sensitive data even while it's being processed, closing the final gap in encryption coverage.
The Missing Piece of Encryption
You've learned about encrypting data at rest (in storage) and in transit (during transfer). But what about data in use—when it's actively being processed in memory? Traditionally, databases must decrypt data to run queries, create reports, or perform calculations. This creates a vulnerability window where plaintext data sits exposed in RAM, accessible to administrators, malicious insiders, or attackers with memory access.
Always Encrypted Technology
Always Encrypted (Microsoft's term, though similar concepts exist across cloud providers) keeps data encrypted end-to-end, including during query execution. The database server never sees plaintext:
- Data is encrypted on the client side before transmission
- The database stores and processes encrypted values
- Only authorized client applications with the correct keys can decrypt results
- Even database administrators cannot see sensitive data
Think of it like a locked safe deposit box: the bank (database server) can move it, organize it, and retrieve it for you—but only you have the key to see what's inside.
Confidential Computing
Confidential Computing takes this further using hardware-based trusted execution environments (TEEs), such as Intel SGX or AMD SEV. These create isolated, encrypted memory regions where:
- Data remains encrypted in RAM during processing
- Even the operating system and hypervisor cannot access it
- Attestation proves the computation ran in a secure enclave
This enables scenarios like analyzing sensitive medical records or financial data without exposing them to cloud providers or system operators.
Key Takeaway: Always Encrypted and Confidential Computing protect data during active processing, completing the encryption lifecycle by eliminating the plaintext-in-memory vulnerability, crucial for zero-trust architectures and regulatory compliance.