encryption Archives – {coding}Sight

Deploying a Certificate for Encrypted Connection SQL Server

September 16, 2020September 16, 2020 Kenneth Igiri Leave a comment

Total: 3 Average: 5

Introduction

Last year we got a requirement to ensure encrypted connections to our SQL Server instances. Before, we did not think it was necessary – all our instances were accessed by application services internally. Still, secure connections protect the instance and clients from attacks as man-in-the middles, so we did it.

Connection encryption differs from Transparent Data Encryption, but you need a certificate in both cases. In this article, we describe the procedure of setting up an encrypted connection for SQL Server instances.

Oracle Database Security – Encryption and Decryption

March 6, 2018April 11, 2018 Andreea-Elena Panait Leave a comment

Total: 18 Average: 4.1

Data encryption is very important because it’s a way to protect the current and the archived data in order to ensure its confidentiality. This prevents an unauthorized access and usage. In this article, I will briefly present some important aspects of data encryption and decryption.

Transparent Data Encryption and Always Encrypted

July 7, 2017June 23, 2018 Dejan Sarka Leave a comment

Total: 0 Average: 0

If you need to store confidential data in your database, you can use data encryption. SQL Server supports encryption with symmetric keys, asymmetric keys, certificates, and password phrases. I assume that you, the reader, are already familiar with these terms. In this article, I will focus on two out of many encryption options provided by SQL Server:

Transparent Data Encryption (TDE)
Always Encrypted (AE)

SQL Server Database Backup Encryption

May 8, 2016March 6, 2019 Andrey Langovoy Leave a comment

Total: 1 Average: 3

To manage the data security that has been backed up by the file system as a database backup files, SQL Server provides the backup encryption feature. In this article, we will talk about encryption options available in SQL Server for database backups. We will have a closer look at the usage details, benefits, and recommended practices for encrypting SQL Server database backup during the backup process. Read More