Configure SSMS for Database Encryption

To configure Microsoft SQL Server and SSMS with the basic database settings needed for testing Always Encrypted in conjunction with YubiHSM 2, set SSMS to display the encrypted columns in clear text. Step 1 Click the Connect Object Explorer icon. The Connect to Server window appears. Click Options, select the *Always Encrypted tab, and seleck Enable Always Encrypted (column encryption). To make the… Continue reading Configure SSMS for Database Encryption

A Guide to Transparent Data Encryption in PostgreSQL

Introduction In the past decade, Data Security has become one of the biggest concerns for both small and large organizations. With more and more data breaches occurring every day, and legislators struggling to keep up with innovation, it is essential to protect sensitive data by all means necessary. Therefore, the first defense mechanism of every organization should… Continue reading A Guide to Transparent Data Encryption in PostgreSQL

Securing your data with Transparent Data Encryption

Information Technology security is getting more complex each time I visit the subject. This just makes it harder for Security Specialists, whose role is to ensure that all potential threats are mitigated across the myriad of hardware, firmware, and software that make up a modern Enterprise Infrastructure. Complexities of security The flexibility that modern companies… Continue reading Securing your data with Transparent Data Encryption

The Transparent data encryption in PostgreSQL

I have been working with the PostgreSQL community recently to develop TDE (Transparent Data Encryption). During this time, I studied some cryptography-related knowledge and used it to combine with the database. I will introduce the TDE in PostgreSQL by the following three dimensions. The current threat model of the database Encryption policy description and current… Continue reading The Transparent data encryption in PostgreSQL

Azure Database for PostgreSQL Single server data encryption with a customer-managed key

Azure PostgreSQL leverages Azure Storage encryption to encrypt data at-rest by default using Microsoft-managed keys. For Azure PostgreSQL users, it is a very similar to Transparent Data Encryption (TDE) in other databases such as SQL Server. Many organizations require full control on access to the data using a customer-managed key. Data encryption with customer-managed keys for Azure… Continue reading Azure Database for PostgreSQL Single server data encryption with a customer-managed key

SQL Server Encryption: Always Encrypted

Is ‘Always Encrypted’ SQL Server 2016’s most widely important new feature? It is significant that ‘Always Encrypted’ in SQL Server is in all editions of SQL Server. Because of the increasing importance of encryption to data governance, it allows encryption for the sensitive application data for everywhere beyond the application’s client connection, including network, server,… Continue reading SQL Server Encryption: Always Encrypted

How to configure Always Encrypted in SQL Server 2022 using SSMS, PowerShell and T-SQL

In an era of remote storage and retrieval of data, including the cloud, data security plays a vital role, especially since it’s vulnerable during the transit. Situations like database backup or copy from or to the cloud, there is always a risk of data exposure to outside world lurking around one corner or the other.… Continue reading How to configure Always Encrypted in SQL Server 2022 using SSMS, PowerShell and T-SQL

Enabling SQL Server Always Encrypted

Overview There are times when you must protect and secure data within SQL Server . SQL Server Always Encrypted is a feature which helps protect sensitive data, such as social security numbers or credit card numbers, providing confidential computing capabilities. Always Encrypted provides a separation between those who own the data and can view it, and those… Continue reading Enabling SQL Server Always Encrypted