Best practices to save personal data

Question

User-284642143 posted

I have an ASP .Net form which collects a lot of personal and sensitive details. The site would be using https, SQL 2012 as the DB (VS 2013) but wondered what are the best practices to follow and save this data on the database and what .Net encryption (if any) should i use to ensure the data is saved in a "safe" format?

Answer 1

User475983607 posted

SQL server 2012 has an encryption feature which encrypts data at rest.

https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/sql-server-encryption?view=sql-server-2017

Answer 2

User-284642143 posted

Thanks. Will take a look at that link however would you know if this adds more programming or is it just having SQL 2012 setup with encryption?

Answer 3

User475983607 posted

Thanks. Will take a look at that link however would you know if this adds more programming or is it just having SQL 2012 setup with encryption?

SQL encryption requires configuration.  Please read the docs.