CODEWITHSUNDEEP
sql-serverazureencryptionazure-keyvault
GRVPrasad
GRVPrasad

Reputation: 1142

How to encrypt the data columns in SQL using Azure Key Vault?

My requirement is:

  1. Data from Azure Blob will load into Azure SQL server with 10 columns.
  2. I need to encrypt the data for 3-4 columns in Azure SQL server.
  3. Is it possible with Azure Key Vault?

Is this possible or is there any other secure way to do encryption in Azure SQL?

Upvotes: 1

Views: 1871

Answers (2)

silent
silent

Reputation: 16108

Yes, it's called Always Encrypted (also: Column-based Encryption). See here how to implement it: https://learn.microsoft.com/en-us/azure/sql-database/sql-database-always-encrypted-azure-key-vault?tabs=azure-powershell

Upvotes: 1

Sajeetharan
Sajeetharan

Reputation: 222522

BTW it is Key Vault not Key Volt, From the docs Definition

Azure Key Vault is a tool for securely storing and accessing secrets. A secret is anything that you want to tightly control access to, such as API keys, passwords, or certificates.

Is it possible with Azure Key Volts?

No

If you want to encrypt data columns of SQL server you need to use Encryption at Rest

Upvotes: 1

Related Questions