All geek questions in one place

What are the available options for encrypting a SQL Server Express database?

We have a group of sellers who often travel with a laptop loaded with Sales data in a SQL Server Express database. What are the available options for encrypting a SQL Server Express database?

+3
source share
2 answers

What is your threat model? Are you trying to stop the random thief who stole a laptop or a specific hacker? Are you trying to protect only data or a circuit?

If you are using SQL Server Express 2005 or higher, it supports native asymmetric encryption . But if you are trying to stop a particular hacker, I think the best option would be to encrypt the entire drive using something like TrueCrypt , or BitLocker for Vista / Windows7.

+5
source

You might also consider using a transparent encryption solution for SQL Server called DbDefence . It is free for databases less than 77 MB.

+1
source

Source: https://habr.com/ru/post/1722566/

More articles:


All Articles