Who Watches the Data Watchers? T-SQL Tuesday #30

Chris Shaw (B|T)  is hosting this month’s T-SQL Tuesday and he has asked us to discuss DBA Ethics.

For a good portion of my career I was responsible for the payroll data of hundreds of customers. In the beginning it seemed a very solemn responsibility, but I quickly got involved in the day to day and payroll data was just data. We kept it safe and made sure only the right people had access, but this is true of all of our data, right? Our main application was from a third-party vendor and it was a locally installed application that used SQL Server as the back end. About 1 in 4 new clients would ask the same question when we would set them up with the payroll software.

How do I keep the IT department/DBA from seeing the payroll data?

Continue reading