Exam Ref 70-765 Provisioning SQL Databases by Joseph D'Antoni & Scott Klein

Author:Joseph D'Antoni & Scott Klein [D'Antoni, Joseph]
Language: eng
Format: epub
Publisher: Pearson Education
Published: 2017-12-04T00:00:00+00:00

Managing TDE using T-SQL

Transparent Data Encryption can be managed with T-SQL at the database level through a small handful of T-SQL statements and DMVs (dynamic management views). TDE can be enabled and disabled at the database level through the ALTER DATABASE command as follows:

ALTER DATABASE Database1 SET ENCRYPTION OFF

The sys.dm_database_encryption_encryption_keys DMV shows information about the database encryption state and associated encryption keys. A corresponding DMV for the SQL Data Warehouse exists that provides the same information: sysdm_pdw_nodes_database_encryption_keys.

Currently there are no T-SQL statements that allow you to manage TDE at the server level.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.