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,405 reads
Learn about restoring your keys from an Azure Key Vault in the event of a DR situation.
2026-05-13
1,405 reads
In this level we learn how to ensure our keys are backed up to the Azure Key Vault for safekeeping.
2026-04-22
806 reads
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,510 reads
Learn how to remove TDE from a database and return it to a normal state.
2026-04-15 (first published: 2020-08-26)
11,142 reads
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,945 reads
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,331 reads
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,339 reads
In this article, learn how to use the PowerShell DSC to patch your SQL Server instances.
2024-04-05
5,901 reads
Learn how you can install SMSS automatically using PowerShell DSC as this series continues.
2024-01-31
3,654 reads
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,997 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, true)
GO
See possible answers