Always Encrypted documentation

Find documentation about Always Encrypted

Always Encrypted overview

Overview

• What is Always Encrypted?

Always Encrypted concepts

Concept

• Key management for Always Encrypted
• Always Encrypted cryptography
• How queries against encrypted columns work

Always Encrypted Tutorials

Tutorial

• Getting started with Always Encrypted

Configure Always Encrypted

How-To Guide

• Configure Always Encrypted using PowerShell
• Configure Always Encrypted using SQL Server Management Studio

Manage Always Encrypted keys

How-To Guide

• Create and store column master keys for Always Encrypted
• Provision Always Encrypted keys using SQL Server Management Studio
• Rotate Always Encrypted keys using SQL Server Management Studio
• Provision Always Encrypted keys using PowerShell
• Rotate Always Encrypted keys using PowerShell

Configure Always Encrypted columns

How-To Guide

• Configure column encryption using Always Encrypted Wizard
• Configure column encryption using Always Encrypted with a DAC package

Query Always Encrypted columns

How-To Guide

• Query columns using Always Encrypted with SQL Server Management Studio
• Query columns using Always Encrypted with Azure Data Studio

Migrate data using Always Encrypted

How-To Guide

• Export and import databases using Always Encrypted
• Backup and restore databases using Always Encrypted
• Migrate data to or from columns using Always Encrypted with SQL Server Import and Export Wizard
• Bulk load encrypted data to columns using Always Encrypted
• Using Always Encrypted with Azure Data Factory

Develop applications using Always Encrypted

How-To Guide

• Develop applications using Always Encrypted