Question : I was wondering if SQL server 2008 R2 has any default security if you’re using it via ODBC […]
Tag: encryption
How to Oracle DBLink encryption
Question : I have the environment that I explain below and I need to encrypt the data that is sent […]
SQL Server 2019 setting Force Encryption with a script
Question : I have to update 50+ servers to use encrypted connection strings. Is there a way to script setting […]
How to change SQL Server master key password?
Question : I created a master key, then a certificate and encrypted my database. CREATE MASTER KEY ENCRYPTION BY PASSWORD=’A […]
How can I decrypt data on a replicated MSSQL database?
Question : I have a database which uses a symmetric key to encrypt a credit card field. There is a […]
How do I check that the database master key encryption is valid?
Question : I have a scenario where I’m restoring a db from one server to another. On the source server, […]
Is network traffic encrypted when writing remote backups using SQL Server TDE?
Question : They do say there is no such thing as a “stupid question”, so here goes: I understand that […]
How to stop decrypting data after opening master key in SQL Server?
Question : I have implemented data encryption using SQL Server symmetric key encryption technique using a certificate, master key with […]
searching against decrypted column
Question : I’m using Postgres on AWS RDS. My application is encrypting selected columns in a table using AWS KMS […]
Open source & cheap ‘data at rest’ encryption solutions
Question : So I am exploring some options about database encryption. The best options are commercial (TDE). I am looking […]