I inherited a DBA position not so long ago, and even having worked with SQL for the past 20 years it is a different ball game. Anyway, here is my pain 🙂
We need to start hiding sensitive data information . This HAS to be done at the SQL level, as we do not have access to our software sources. I was reading on the web and Data Masking seemed to be the solution, BUT we are running 2014 SQL 🙁
Data encryption does not seem to be a solution (for what I have read) What other options are out there, and keep in mind that I am a newbie at this.