• Sarbanes-Oxley (SOX) does require separation of responsibilities. Application developers are not allowed to "fix" production data. I can't disagree with this.

    But I never forget the quote

    Stamp's Statistical Probability The government [is] extremely fond of amassing great quantities of statistics. These are raised to the nth degree, the cube roots are extracted, and the results are arranged into elaborate and impressive displays. What must be kept ever in mind, however, is that in every case, the figures are first put down by a village watchman, and he puts down anything he damn well pleases.

    (Attributed to Sir Josiah Stamp, 1840-1941, H.M. collector of inland revenue.

    As DBA, I do validity checks as far back to the source as I can on data I protect, and I am always interested in analyzing the data I am protecting. I was a data analyst, not a programmer, before I was a DBA. And I am a good DBA, with a good understanding of how much time any database operation (and human operation) should require. I "get" the SQL Server DBMS. Some programmers know all the trees and don't get the forest.

    _________________
    "Look, those sheep have been shorn."
    data analyst replies, "On the sides that we can see.."