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.
2024-10-09 (first published: 2020-08-26)
10,622 reads
Vishnu Gupthan
- Website: http://www.powershellacademy.com
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.
2024-07-17
852 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.
2024-06-26 (first published: 2020-06-24)
8,728 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.
2024-06-26 (first published: 2020-05-20)
53,449 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.
2024-06-26 (first published: 2020-04-29)
11,358 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,204 reads
Install SSMS using Powershell DSC
Learn how you can install SMSS automatically using PowerShell DSC as this series continues.
2024-01-31
3,272 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,281 reads
Install SQL Server using Powershell Desired State Configuration (DSC)
This article shows the basics of using PowerShell Desired State Configuration to install a SQL Server.
2023-05-29
7,519 reads
Scheduling SQL Scripts Using Jenkins
Learn how a Jenkins server can be used to schedule SQL scripts to execute against SQL Server.
2020-12-22
28,408 reads
Blogs
Catching Up On SQLOrlando
By Andy Warren
Somehow two years have elapsed since my last update; hopefully it won’t be that...
Advice I Like: Pyramid Schemes
By Steve Jones
If someone is trying to convince you it’s not a pyramid scheme, it’s a...
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
Forums
Switch partition: NULL boundary id
I have table: t1 in schema1 with 19 billion records. I have another table...
Minimally Viable Security
Comments posted to this topic are about the item Minimally Viable Security
Encoding NULL
Comments posted to this topic are about the item Encoding NULL
Question of the Day
Encoding NULL
What is returned from this code in SQL Server 2025?
SELECT BASE64_ENCODE(NULL)See possible answers