| Why can't we just get along? |
|
| Wednesday, 01 March 2006 | |||||
|
In many IT organizations, there is tension between the PeopleSoft administrators and developers and the Database Administrators. The DBA's don't want the crazy developers and administrators building their own tables because who knows what kind of DDL parameters they may enter or forget to enter. Developers hate trying to track down a DBA for every little index, column, or table. Administrators hate having to wait for the DBA to build tables during the periodic migration window. One of my fondest memories was during crunch time of a 7.5 to 8.3 HRMS upgrade. We had tons of deliverables and very little time, and the client PeopleSoft production administrator was also the upgrade architecture team lead. Maybe she HAD ignored a request or two from the DBA to analyze all of the 7.5 production SQL to make sure it worked with the COST-based optimizer, because EVERYBODY who knows ANYTHING knows that COST-based kicks RULE-based's butt every time. But there weren't any big problems with performance and we were upgrading and moving to cost based anyway, so what was the big deal? Well, we were on the way to a meeting when we got a call from a user. Payroll had been running 12 hours and things weren't looking good. After a little digging, we discovered that the DBA had switched the production database from rule-based to cost-based just prior to the payroll cycle. He was totally unapologetic, and relucantly switched the DB back to RULE based only after threats from his boss. Fortunately for us he was moved off of PeopleSoft support shortly thereafter. So besides a ropes course or a team building retreat in the mountains where DBA's and PeopleSoft Techies all sing kum-by-yah around the campfire, how do we get some trust between all of the parties involved? Well, I have no idea. But here are some things that everybody should understand:
That's it for now. Please post a comment and let me know what I missed or what you might not agree with.
|
|||||
| Last Updated ( Thursday, 02 March 2006 ) | |||||
| < Prev | Next > |
|---|
