I run web applications with PHP, SQLSRV and MS SQL (2014 web).
With the forthcoming GDRP legislation I am considering encrypting my sql databases. Please can anyone advise if ugrading to SQL Server 2016 (web) and using AlwaysOn Encryption is a possibility. I would like to not have to recode all my queries, but could easily change my connection strings.
I am also looking at row-level security as my database tables are shared across multiple clients, with an an identifiying "clientid" on each record to distiguish which record belongs to which client. Can anyone advise if this is possible and practical.