Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
To enable Transparent Data Encryption (TDE), you must be an administrator or a member of the dbmanager role.
Follow these steps to enable TDE:
ALTER DATABASE [AdventureWorks] SET ENCRYPTION ON;
Follow these steps to disable TDE:
ALTER DATABASE [AdventureWorks] SET ENCRYPTION OFF;
Note
A paused dedicated SQL pool must be resumed before making changes to the TDE settings.
To verify encryption status, follow the steps below:
SELECT
[name],
[is_encrypted]
FROM
sys.databases;
A result of 1
indicates an encrypted database, 0
indicates a non-encrypted database.
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Certification
Microsoft Certified: Azure Database Administrator Associate - Certifications
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.
Documentation
Transparent Data Encryption (TDE) for dedicated SQL pool (formerly SQL DW) in Azure Synapse Analytics
Transparent data encryption (TDE) - SQL Server
Learn about transparent data encryption, which encrypts SQL Server, Azure SQL Database, and Azure Synapse Analytics data, known as encrypting data at rest.
An overview of transparent data encryption for Azure SQL Database, Azure SQL Managed Instance, and Azure Synapse Analytics. The document covers its benefits and the options for configuration, which includes service-managed transparent data encryption and Bring Your Own Key.