Encryption

SQLServerCentral Article

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, […]

(3)

You rated this post out of 5. Change rating

2020-07-21

2,539 reads

Technical Article

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?

You rated this post out of 5. Change rating

2019-12-26

Blogs

Reverse Engineering a Physical Model Diagram

By

I recently wrote about a logical diagram with Redgate Data Modeler. That was interesting,...

Prepping for Certification, Part 3 of ?

By

After I have understood the details for a certification test (part 1), including format...

SQL Training Black Friday Deals

By

If you're looking for particular "Black Friday" deals, here is what I've seen advertised...

Read the latest Blogs

Forums

Best analysis approach to reduce data type length in multiple tables

By Lord Slaagh

Hello SSC, I hope everyone is having a happy and safe holiday season! I...

Do you separate data/log files and TempDB files on different disks using AWS EC2

By WebTechie

Hello,   I am receiving multiple direction on deploying SQL Servers in AWS EC2. ...

Service account being in local admin in AWS EC2 environment?

By WebTechie

Hello, I am working with a company on their database administration.  I am trying...

Visit the forum

Question of the Day

A New Operator

In SQL Server 2025, what does this code return?

SELECT '1' || '0'
 

See possible answers