Encryption

TDE BYOK and Geo-Replication in Azure SQL DB

  • Article

Recently a customer asked me for help with setting up a test of an Azure SQL Database in the single database tier with Geo-Replication to work with Transparent Data Encryption (TDE) with a customer-managed key, also known as Bring Your Own Key (BYOK). It is very simple to do it when you use service-managed keys, […]

5 (3)

2020-07-21

1,224 reads

Stairway to TDE icon

Stairway level 3 : Configure Extensible Key Management Using Azure Key Vault

  • Stairway Step

In Level 1 of this Stairway series, we discussed how to configure TDE in a user database using a Database Master Key (DMK) and a certificate. Level 2 showed the steps to restore the backup of this database on another instance.  In this level, we will explain how to configure TDE in SQL Server with […]

5 (3)

2020-06-24

733 reads

SQL Server Transparent Data Encryption vs. NetLib Encryptionizer

  • Article

Between the legislation over the years (HIPAA, GLBA, GDPR, CCPA, etc.) and data breaches from large organizations that seem to pop-up in the news on a monthly basis, SQL Server database encryption is critical for our industry. SQL Server ships with a few options for a native encryption implementation (Column Level Encryption, Transparent Data Encryption, Data Masking, Always Encrypted), that all provide value in particular situations, but none of the options all seem to address all of the needs. What is the best way to encrypt our SQL Server data?

2019-12-26

Blogs

Creating a SQL Clone Agent and a First Image

By

In a previous post, I set up the SQL Clone server. This is really...

Availability Group issues fixed with Alerts

By

Learn how to use the SQL Server Agent Alerting system to capture Availability Group...

Availability Group issues fixed with Alerts

By

Learn how to use the SQL Server Agent Alerting system to capture Availability Group...

Read the latest Blogs

Forums

Why aren't the backups working?

By Rod at work

You've heard of "the accidental DBA", right? Well, I'm the accidental TFS admin. I...

Cannot insert duplicate key in object

By adonetok

In table tUSERI primary key was added in the column [Email]. I deleted a...

Random excessive CPU consumption

By DataGuy

Hi all. I'm in a bit of a quandary with one of our Analysis...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers