No More SOX

SQLServerCentral is supported by Red Gate Software Ltd.

Home Tags Articles Editorials Forums Scripts Videos Blogs QotD Books Ask SSC SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us

Popular Topics

Home

Members

Calendar

Who's On

Home » SQLServerCentral.com » Editorials » No More SOX

25 posts, Page 3 of 3

No More SOX

Author

Message

Jeff Moden

Posted Monday, June 01, 2009 8:54 PM

SSChampion

Group: General Forum Members
Last Login: Yesterday @ 11:25 PM
Points: 20,175, Visits: 13,708

wldhrs (6/1/2009)

Jeff Moden (5/31/2009)

"Its the Law"

A four word reason "It's the law".

I soooo dislike misuse of the apostrophe in possessive case, particularly of the verb "to be".

Probably a left over attitude from misuse of a comma causing a microcode load failure in the 308x.

Whistling

We can certainly tell what you consider to be most important. What does that have to do with the subject at hand? Nothing. Get over the typo.
Whistling

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

"Data isn't the only thing that's supposed to have Integrity."

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #727103

Mario Measor

Posted Tuesday, June 02, 2009 5:46 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, June 02, 2009 5:38 AM
Points: 2, Visits: 5

I have been working as a software developer for a little over a year now for a company that is SOX compliant. I do think some of the steps required are annoying, but without the checks and balances, you wouldn't have a clue what some of these people did to the data and/or code.

Sometimes I feel like I spend just as much time tracking changes and updating sharepoint issues, but two months down the road when someone asks me why, I can go back to the issue and get an idea of what I was thinking back then.

I am come to believe that it is one of those necessary evils to keep some of the irresponsible people in check. I would like to say I don't need it myself, but without it I would eventually be lost in code changes.

Post #727344

Datamama

Posted Thursday, June 04, 2009 12:48 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, March 17, 2010 2:30 PM
Points: 3, Visits: 17

Jeff,

WOW - you nailed it !!

I'm a long time data architect and shared your 'experiences' with developers, managers and business 'types' who have no concept of the need for auditibility and data integrity.

Thanks for laugh and btw - every great DBA I have ever worked with sounds just like you.

Josie

Post #729221

geerobg

Posted Thursday, June 04, 2009 7:38 PM

Grasshopper

Group: General Forum Members
Last Login: Thursday, March 18, 2010 11:37 AM
Points: 14, Visits: 41

I absolutely love sox, both from a design and architectural point of view. Many lower level developers misunderstand the purpose of sox. It's not about audit logging infinitum, but rather the separation of business process oriented system access. If a system is well designed around logical business process it will lend itself wonderfully to the constraints of sox rules. Those that bemoan sox are generally trying to retro-fit a poorly designed system.

Granted it's not sexy, but with internal audit moving up the corporate power ladder and filling a very large seat at the decision making table, we've been able to dramatically trim the sales cycle as CFOs scramble toward compliancy.

They thought we were crazy when we ploughed our crop under, but we built it and they did come.

Post #729367

Jeff Moden

Posted Thursday, June 04, 2009 7:49 PM

SSChampion

Group: General Forum Members
Last Login: Yesterday @ 11:25 PM
Points: 20,175, Visits: 13,708

Datamama (6/4/2009)

... and btw - every great DBA I have ever worked with sounds just like you.

Josie

Heh... thanks Josie Blush

. Every good one I've worked with sounds the same way. When I first started out, I didn't use to be that way and thought those types of DBA's were being a bit annoying and "controlling". Then, I lived through a couple of crises with them that could have easily been prevented. One of those easily preventable crises took 40 people 10 days to repair. It changed my whole outlook especially since I was up and at 'em for most of those 10 days. Tongue

--Jeff Moden

Post #729369

« Prev Topic | Next Topic »

25 posts, Page 3 of 3

«««1 2 3

Permissions