
Shamir’s Secret Sharing in SQL Server
Explore Shamir's secret sharing and learn how to implement this cryptographic algorithm effectively within SQL Server.
Solve your SQL Server Encryption issues with these valuable tips, tutorials, how-to’s, scripts, and more for SQL Server Developers.

Explore Shamir's secret sharing and learn how to implement this cryptographic algorithm effectively within SQL Server.

Learn about zero knowledge proof and how to implement it in SQL Server to ensure privacy in blockchain and transaction systems.

Explore the Homomorphic Encryption Algorithm with SQL Server and learn how it secures computations on encrypted data without decryption.

Understand SQL tokenization's importance in safeguarding sensitive information while adhering to regulations and enhancing security.

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…
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.
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.
Learn how to suspend and resume the initial encryption when enabling TDE for a SQL Server database.
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.
In this tip we walk through the steps of how to configure your SQL Server to enable Always Encrypted with Secure Enclaves.
In this article we look at how to configure and enable transparent data encryption for a SQL Server database using PowerShell.
In this tip we cover how to update an expired SQL Server TDE certificate.
In this tip we cover what happens to a database using SQL Server TDE when the certificate expires.
Check a sample stored procedure and function for SQL Server credit card encryption and decryption.
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.
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.
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
Learn how to use SQL Server Integration Services 2016 Lookups With Always Encrypted Data with ADO.NET connection strings and cache connection manager.
Learn how to use SSIS to write to columns encrypted with the new Always Encrypted feature in SQL Server.
Read this tip to learn how to use the Always Encrypted feature when using SQL Server Integration Services (SSIS).
In this tip we look at how to safely store passwords in a SQL Server database.
Learn about SQL Server 2016 Always Encrypted concepts and examples including a C# demo to understand the state of your data.
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.
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?