• To be honest, we don't have an Administrative DBA. We just have a small team of 3 DBAs who do it all, Operational, Development and Administration. Yes, a lot of small things had to temporarily fall by the wayside, but that's what project planning is for. It helped us schedule things so we could do the important operational tasks and still get our SOX compliance done. Also, we had business analysts and a project manager to fall back on for a lot of our reports documentation.

    Once you get into the grove of documenting reports, it's not as hard as you think. Adopting the attitude that documentation gets written up *before* reports can be designed does help somewhat (plus prevents some of the inevitable "scope creep").

    But if you don't do it because you're too busy, you will get bitten by the SOX bug. It's not just companies that can be fined, if I understand the law. Managers can get get hit with pretty hefty fines for violating SOX, plus they can lose their jobs. If you don't have time for documenting the reports and don't have access to a BA, ask your manager to hire a temporary BA for the project. Mentioning the monetary implications of not completing SOX should help shake loose some funds for project.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.