Shamir’s Secret Sharing in SQL Server
Explore Shamir's secret sharing and learn how to implement this cryptographic algorithm effectively within SQL Server.
Encryption
Solve your SQL Server Encryption issues with these valuable tips, tutorials, how-to’s, scripts, and more for SQL Server Developers.
Zero Knowledge Proof (ZKP) in SQL Server
Learn about zero knowledge proof and how to implement it in SQL Server to ensure privacy in blockchain and transaction systems.
Homomorphic Encryption Algorithm in SQL Server
Explore the Homomorphic Encryption Algorithm with SQL Server and learn how it secures computations on encrypted data without decryption.
Tokenization in SQL Server: The Security Layer You Forgot
Understand SQL tokenization's importance in safeguarding sensitive information while adhering to regulations and enhancing security.
SQL Server Column Encryption and Decryption with Code Examples
Problem I was recently assigned to work on a team who will implement column-level encryption and decryption solutions in SQL Server. Please introduce the basics of SQL Server column encryption and decryption features. Also, provide a series of T-SQL samples…
SQL Server Always Encrypted – Enabling, Querying and Modifying Data
Learn how to use Always Encrypted to encrypt SQL Server data along with some of the changes that have been made since its first release in 2016.
How to Encrypt a Stored Procedure in SQL Server
In this article, we cover how to encrypt a SQL Server stored procedure and how SQL Server hides the source code for these objects once encrypted.
SQL Server TDE Initial Scan Suspend and Resume Options
Learn how to suspend and resume the initial encryption when enabling TDE for a SQL Server database.
Setup Encrypted Connections to SQL Server and Oracle using TLS
In this article we look at how to setup encrypted connections to SQL Server and to Oracle using TLS 1.2 along with the step by step process.
Enable Always Encrypted with Secure Enclaves in SSMS
In this tip we walk through the steps of how to configure your SQL Server to enable Always Encrypted with Secure Enclaves.
Configure SQL Server Transparent Data Encryption with PowerShell
In this article we look at how to configure and enable transparent data encryption for a SQL Server database using PowerShell.
Updating an expired SQL Server TDE certificate
In this tip we cover how to update an expired SQL Server TDE certificate.
Does SQL Server TDE still work with an expired certificate
In this tip we cover what happens to a database using SQL Server TDE when the certificate expires.
SQL Server Credit Card Encryption and Decryption
Check a sample stored procedure and function for SQL Server credit card encryption and decryption.
Exporting and Importing SQL Server Always Encrypted Certificates for Client Access
The exporting and importing of SQL Serer certificates is not a familiar task for most DBAs, so in this tip we look at how this should be done.
SQL Server Function to Encrypt Integer Values
You need a simple and fast tool to encrypt and decrypt integer values without having to deal with complex encryption keys, certificates and other complex encryption methods. In this tip we cover a simple approach to encrypt integers.
Where Does SQL Server Store Its Certificates
My security team was recently performing security scans and they noticed that when they attempted a connection to my SQL Servers, they were getting self-signed certificates. Where does SQL Server store these certificates? Also, why were they seeing self-s
SSIS 2016 Lookups With Always Encrypted Data
Learn how to use SQL Server Integration Services 2016 Lookups With Always Encrypted Data with ADO.NET connection strings and cache connection manager.
Writing Always Encrypted Data with Integration Services 2016
Learn how to use SSIS to write to columns encrypted with the new Always Encrypted feature in SQL Server.
Reading Always Encrypted Data with SSIS 2016
Read this tip to learn how to use the Always Encrypted feature when using SQL Server Integration Services (SSIS).
Storing passwords in a secure way in a SQL Server database
In this tip we look at how to safely store passwords in a SQL Server database.
SQL Server 2016 Always Encrypted
Learn about SQL Server 2016 Always Encrypted concepts and examples including a C# demo to understand the state of your data.
Finding Encrypted Data in a SQL Server Database
I've recently taken over a SQL Server and I have been asked if there is encrypted data in any of the user databases. In this tip we look at how to figure this out.
How much overhead does encryption add to a SQL Server query
From visual inspection alone, one can deduce that decrypting an encrypted column using the DecryptByKey function in a SELECT statement will take longer than selecting the column stored in plain text, but how much longer does it take?