January 29, 2004 at 9:43 am
Always an admirer of your work Steve, but you have way too much time on your hands. If you have some free time I have some servers that can use your expertise.
Dying at The AP
Zach
ps. just joshing you.
John Zacharkan
January 30, 2004 at 11:53 am
I love this article Steve. These are the kinds of things I like to think about and discuss.
At one point I was preaching a DBA ten commandments. One that I included was "Thou shalt know thy data" -- meaning, it isn't enough just to maintain integrity, security, and availability, but also to have a detailed understanding of what the data is. Not just from a modeling perspective, but from an actual content and usage perspective.
That point was often argued -- what does everyone think?
February 2, 2004 at 1:55 am
"Thous shalt know thy data"
Good up to a point, however some databases contains thousands of tables.
I think that a good general rule for all IT personnel (and in particular DBA's) is to learn about the business of the company that employs you.
I've worked with people who have become really high flyers and they have all put particular effort into
July 7, 2010 at 2:27 pm
Steve, not sure where this can relate in but how would you address the issue of data deletion from a DBA perspective?
In the aspect of a Database containing legal information on criminals...
i.e.
1. User enters in data on a person that was incorrect, i.e. totally wrong or for a different person. This should be removed?
a. Enter in a DOB that was from another person, this should be removed as the history woudl reflect this person used an "alias" DOB and would be incorrect as the person did not provide this information.
b. User selects the incorrect person and books them into jail in the system. This should be deleted as the person should not have another booking on their record that was not theirs.
2. User enters in something erroneous, but on the correct person, this should be corrected with a clarification entry?
a. User enters in one thing and meant another. Entry should be "edited" by user and a clarification entry made so that the correct information is saved as the current value, yet the history is retained.
b. User enters in something that flows via an interface to another legal system. As far as I am concerned, when this data leaves our system and flows to the other department and was on the right person, if it was in error the other system should reject it.
Thoughts? Thanks
June 21, 2025 at 1:14 am
Mr. Jones,
I was wondering if anything came from this article. I have been working on a "DBA Code of Ethics" myself and was hoping for some collaboration from other DBAs. I have created a preamble "oath" for all DBAs to memorize and swear to. It's followed by 10 articles defining the duties and responsibilities of a DBA. Here is the oath.
The Database Administrator's Oath
"I solemnly pledge to uphold the highest standards of professional conduct in the stewardship of data and database systems. First and foremost, I will protect the data entrusted to my care, safeguarding its integrity, availability, accuracy, and confidentiality. I will serve the public good, respect privacy rights, and maintain the trust placed in me by stakeholders, colleagues, and society. I will continuously develop my skills and knowledge, act with transparency and accountability, and use my expertise to benefit rather than harm. This oath I make freely and upon my honor."
Here is the preamble and the 10 articles (commandments) of a DBA that I have so far.
Preamble:
"First and foremost, protect the data – for in doing so, we protect the trust, privacy, and rights of all those whose lives are touched by the information systems we steward."
Article I. Data Protection: The Sacred Trust
Article II. Privacy: Respecting Individual Rights
Article III. Integrity: Maintaining Truth and Accuracy
Article IV. Availability: Ensuring Accessible and Reliable Systems
Article V. Professional Conduct: Upholding Excellence and Ethics
Article VI. Accountability: Taking Responsibility for Actions
Article VII. Continuous Learning: Embracing Lifelong Development
Article VIII. Ethical Decision-Making: Navigating Complex Challenges
Article IX. Social Responsibility: Serving the Greater Good
Article X. The Commitment to Excellence
I was just wandering if anyone is interested in picking this suggestion up again and going forward with it?
Thanks.
Aubrey W Love
aka: PailWriter
https://www.aubreywlove.com/
Viewing 5 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply