Restoring Azure Key Vault Keys and Validating SQL Server TDE Recovery: Level 7 of the Stairway to TDE
Learn about restoring your keys from an Azure Key Vault in the event of a DR situation.
2026-05-13
1,258 reads
Vishnu Gupthan
- Website: http://www.powershellacademy.com
Backing Up Azure Key Vault EKM Key: Stairway to TDE Level 6
In this level we learn how to ensure our keys are backed up to the Azure Key Vault for safekeeping.
2026-04-22
738 reads
Configure Extensible Key Management Using Azure Key Vault - Level 3 of the Stairway to TDE
In this third level of the Stairway, we examine how to store your encryption certificate in the Azure Key Vault.
2026-04-15 (first published: 2020-06-24)
9,347 reads
Removing TDE from a Database: Level 4 of the Stairway to TDE
Learn how to remove TDE from a database and return it to a normal state.
2026-04-15 (first published: 2020-08-26)
10,976 reads
Restore a Backup of a TDE Database to Another Server: Level 2 of the Stairway to TDE
In the second level of the stairway to TDE, we examine how you can restore your databases on another instance after moving the encryption certificate.
2026-04-15 (first published: 2020-05-20)
55,260 reads
Transparent Data Encryption Using Certificates and EKM - Level 1 of the Stairway to TDE
The first level of the Stairway to TDE will explain how the feature works and how to set this up on one of your instances and databases.
2026-04-15 (first published: 2020-04-29)
12,066 reads
Updating a Cryptographic Provider for EKM with Azure Key Vault - Level 5 of the Stairway to TDE
This next level of the Stairway to TDE shows how to upgrade your EKM cryptographic provider.
2026-04-15 (first published: 2024-07-17)
1,128 reads
SQL Server Patching Using PowerShell DSC
In this article, learn how to use the PowerShell DSC to patch your SQL Server instances.
2024-04-05
5,712 reads
Install SSMS using Powershell DSC
Learn how you can install SMSS automatically using PowerShell DSC as this series continues.
2024-01-31
3,511 reads
Advanced SQL Server installation using Powershell DSC
Introduction In the previous article, we learned how to install a SQL Server instance with basic parameters like InstanceName, Features, SourcePath, SQLSysAdminAccounts, etc using Powershell DSC. In this article, we'll discover how to enhance our SQL Server installation with additional configurations. We'll cover things like setting up service account credentials, custom installation directories, configuring TempDB […]
2023-11-22
5,774 reads
Blogs
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
A Guatemalan's Guide to Drinking Coffee Properly
My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most...
Forums
Alamat Kantor BCA KCU Subang Telp:08218154374
Hub Via Wa:628218154374 Alamat Jl. Otto Iskandardinata No.37, Karanganyar, Kec. Subang, Kabupaten Subang, Jawa...
Alamat Kantor BCA KCU Purwakarta Telp:08218154374
Hub Via Wa:628218154374 Alamat Bank Bca Kcu Purwakarta, Jl. Jendral Sudirman No.85, Nagri Tengah,...
Alamat BCA KCU Soekarno Hatta Telp:08218154374
Hub Via Wa:628218154374 Alamat Jl. Soekarno-Hatta No.240, Kb. Lega, Kec. Bojongloa Kidul, Kota Bandung,...
Question of the Day
The Range of Customers
I have this data in the OrderHeader table in a SQL Server 2025 database (ordered by CustomerID ASC):
orderid orderdate customerid complete 3 2025-05-10 00:00:00.0002 1 21 2024-01-10 00:00:00.0003 1 15 2023-10-28 00:00:00.0004 1 13 2025-03-08 00:00:00.0006 1 11 2024-04-02 00:00:00.0007 1If I run this query, how many rows are returned?
SELECT * from dbo.OrderHeader where customerid between 3 and '6'See possible answers