Encryption

Solve your SQL Server Encryption issues with these valuable tips, tutorials, how-to’s, scripts, and more for SQL Server Developers.

Title Author Date
Tokenization in SQL Server: The Security Layer You Forgot Sebastiao Pereira2026-05-09
Shamir’s Secret Sharing in SQL Server Sebastiao Pereira2026-03-04
Zero Knowledge Proof (ZKP) in SQL Server Sebastiao Pereira2026-02-18
Homomorphic Encryption Algorithm in SQL Server Sebastiao Pereira2026-01-20
SQL Server Column Encryption and Decryption​ with Code Examples Rick Dobson2024-12-18
SQL Server Always Encrypted – Enabling, Querying and Modifying Data Aaron Bertrand2023-05-09
How to Encrypt a Stored Procedure in SQL Server Aubrey Love2023-01-18
SQL Server TDE Initial Scan Suspend and Resume Options Filip Holub2022-09-07
Setup Encrypted Connections to SQL Server and Oracle using TLS Pablo Echeverria2022-04-26
Enable Always Encrypted with Secure Enclaves in SSMS Filip Holub2020-03-18
Configure SQL Server Transparent Data Encryption with PowerShell Filip Holub2020-02-13
Updating an expired SQL Server TDE certificate Simon Liew2017-08-08
Does SQL Server TDE still work with an expired certificate Simon Liew2017-07-25
SQL Server Credit Card Encryption and Decryption Eli Leiba2017-06-21
Exporting and Importing SQL Server Always Encrypted Certificates for Client Access Thomas LaRock2017-04-19
SQL Server Function to Encrypt Integer Values Eli Leiba2017-02-03
Where Does SQL Server Store Its Certificates K. Brian Kelley2016-04-26
SSIS 2016 Lookups With Always Encrypted Data Koen Verbeeck2016-03-08
Writing Always Encrypted Data with Integration Services 2016 Koen Verbeeck2016-03-01
Reading Always Encrypted Data with SSIS 2016 Koen Verbeeck2016-02-22
Storing passwords in a secure way in a SQL Server database Sergey Gigoyan2015-09-29
SQL Server 2016 Always Encrypted Aaron Bertrand2015-09-15
Finding Encrypted Data in a SQL Server Database K. Brian Kelley2015-01-14
How much overhead does encryption add to a SQL Server query Dallas Snider2014-04-02
Masking Personal Identifiable SQL Server Data Rick Dobson2013-11-13
Encrypt and Decrypt SQL Server Stored Procedures, Views and Functions Derek Colley2013-05-30
SQL Server Column Level Encryption Example using Symmetric Keys Nitansh Agarwal2011-11-22
Locking Down PII Data in SQL Server (Part 2 of 2) Alan Cranfield2011-06-24
Identifying PII Data to Lock Down in SQL Server (Part 1 of 2) Alan Cranfield2011-06-23
SQL Server Encryption Symmetric vs. Asymmetric Keys K. Brian Kelley2009-11-23
How to simulate transparent data encryption TDE with SQL 2000 and 2005 Matteo Lorini2009-11-19
Using authenticators with SQL Server encryption K. Brian Kelley2009-05-27
SQL Server Encryption Key Management between Dev, Test and Prod Tim Cullen2009-02-17
SQL Server 2008 Transparent Data Encryption getting started Ray Barley2008-06-06
Implementing Transparent Data Encryption in SQL Server 2008 Edwin Sarmiento2008-05-28
Natively Encrypting Social Security Numbers in SQL Server 2005 Tim Cullen2007-11-30
SQL Server Encryption Certificates Overview Tim Cullen2007-08-29
Managing SQL Server Master Keys for Encryption Tim Cullen2007-08-20