Back to Browse

How to Enable TDE on a Restored Database in Azure SQL Managed Instance!

1.1K views
Dec 11, 2023
6:29

Do you need to learn how to secure your database? @ant to learn how to enable #TransparentDataEncryption, #TDE, on a database that you restored to #AzureSQL #ManagedInstance? Daniel Taylor, aka @DBABulldog , walks you through how to enable Transparent Data Encryption in one command! #Azure #Security #Secops Chapters 00:00 Intros 01:08 If you know us Jump here to do to enable TDE Managed Instance 01:09 Microsoft Windows Defender has identified TDE should be enabled 01:32 A look at the docs and unraveling the mystery 02:47 Azure Data Studio and a query to monitor and identify TDE components 03:30 Examining TDE in the portal and the different keys 04:02 What we are here for, let's enable TDE 04:52 Validate TDE is enabled with a query and Microsoft Defender for Cloud 05:54 Closing thoughts Transparent data encryption for SQL Database, SQL Managed Instance, and Azure Synapse Analytics https://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-tde-overview?view=azuresql&tabs=azure-TransactSQL Transparent data encryption (TDE) https://learn.microsoft.com/en-us/sql/relational-databases/security/encryption/transparent-data-encryption?view=sql-server-ver16 How to monitor and manage Transparent Data Encryption (TDE) in SQL Server https://www.sqlshack.com/how-to-monitor-and-manage-transparent-data-encryption-tde-in-sql-server/ /******************* /CONNECT WITH US!! /******************* Tales from the Field Twitter: https://twitter.com/TalesftField Linkedin: https://www.linkedin.com/company/100091910/ Blusky: https://bsky.app/profile/talesfromthefield.bsky.social Bradley Ball Twitter: https://twitter.com/SQLBalls Linkedin: https://www.linkedin.com/in/sqlballs/ Blusky : https://bsky.app/profile/sqlballs.bsky.social Daniel Taylor Twitter: https://twitter.com/dbabulldog Linkedin: https://www.linkedin.com/in/danieltaylor3/ Blusky: https://bsky.app/profile/dbabulldog.bsky.social Neeraj Jhaveri Twitter: https://twitter.com/neeraj_jhaveri Linkedin: https://www.linkedin.com/in/neerajjhaveri/ Blusky: https://bsky.app/profile/neerajny.bsky.social Josh Luedeman Twitter: https://twitter.com/joshluedeman Linkedin: https://www.linkedin.com/in/joshluedeman/ Blusky: https://bsky.app/profile/joshluedeman.bsky.social Andrés Padilla Twitter: https://twitter.com/nodestreamio Linkedin: https://www.linkedin.com/in/andrespadillaandrade/

Download

0 formats

No download links available.

How to Enable TDE on a Restored Database in Azure SQL Managed Instance! | NatokHD