- Feature Articles
- CodeSOD
- Error'd
- Forums
-
Other Articles
- Random Article
- Other Series
- Alex's Soapbox
- Announcements
- Best of…
- Best of Email
- Best of the Sidebar
- Bring Your Own Code
- Coded Smorgasbord
- Mandatory Fun Day
- Off Topic
- Representative Line
- News Roundup
- Editor's Soapbox
- Software on the Rocks
- Souvenir Potpourri
- Sponsor Post
- Tales from the Interview
- The Daily WTF: Live
- Virtudyne
Admin
The funny thing is that you can infer from the DBAs still working for Burt is that they are happy to be in an environment where any little change requires so much planning that it's a surprise that anything gets done. The DBAs most likely are content to sit at their desk all day and do everything but actual work.
Admin
"Hey, lets get together at my desk and make sure we all agree on everything before going into the pre-meeting."
I only wish I was quoting Dilbert.
Admin
Fields with a maximum length in a database? Why would people use a system like that?
Admin
Was it only me who read CMNF instead of CMDB?
Admin
Admin
Sorry this comment is late, I was in a meeting.
Admin
Admin
Admin
If I wasn't important I would just sneak in and hide in the corner without making a sound, ergo I must be important.
Admin
During my short stint as a DBA I never called a meeting to discuss changes in the DB architecture. I just implemented the requested change, then cleared my calendar for all the meetings about why the applications suddenly didn't work any more.
Did I mention that it was a short stint? It was.
Admin
That's called "going to medical school", and it's essential to getting a job in Accident & Emergency.
Admin
If you are truly important, the meetings will come to you.
They may bring donuts, or they may bring pitchforks and torches. It all depends on what is on the agenda.
Admin
I'm sure glad I work for Bert, not Burt.
Admin
At one company I was at, the managers held a meeting to discuss why efficiency was so low. They came to the conclusion it was because they were having too many meetings. The solution was to hold a meeting to discuss what to do about it.
Admin
Where I work, some of us just ignore timesuck meetings when we have work to do. We claim "too busy, have clients to keep happy" and we get away with it, every time. Our clients pay us well, and the bosses not only know this fact, but also know why they pay us well.
Admin
That was the latest example to me that for managers, their "work" is having meetings. If they aren't in a meeting, they aren't "working".
Admin
Admin
That's why you always have to hire managers in pairs. If you end up with an odd number of managers, then a worker has to meet with the odd manager out.
Admin
Admin
Sounds like some naughty DBA didn't go through proper IT best practices and ended up with:
-A Database that was set to FULL recovery mode when it shouldn't have.
-Some jerky developer/admin wrote bad code which kept the transaction open thus stopping the log from being truncated.
-A DBA setup some sort of HA solution which locks the log file.
TRWTF: -No alerts on log file growth. This causes a lot of performance issues if not addressed in many RDBMS.
-No Alerts on full disk space or full log files.
Admin
Admin
Admin
Admin
I'm quite surprise to see that the problem is actually solved AFTER the meeting is hold.
Admin
The best reason for being late to a meeting is, of course, that you've only just got out of a meeting that was running late (it overran because they had to backtrack and re-cover old ground because someone was late to it).
Admin
Actually, there was an alert, but I missed it because my boss had called me into a meeting to discuss the meeting schedule.
Admin
That is brilliant! I've set up recurring daily meetings for every meeting room in the building. Thank you, thank you!
Admin
You're obviously a fan of the conference call then.
https://www.youtube.com/watch?v=zbJAJEtNUX0
Admin
Burt's next meeting will be with his boss and a representative from Human Resources. The next meeting after that will be called a Job Interview.
Addendum (2014-06-18 10:25): Actually, in between these two meetings, there will be a meeting called a Welfare Qualification Interview.
Admin
Amongst all the angst about meetings, everyone missed an important point -- the DBAs are responsible for the database, probably the most important asset the company owns. We, as developers, like to think of the DB as an extension/component of our software. It's not -- and the DBAs correctly examine change requests for effects beyond the scope of our immediate needs.
For example: Adding an index adds disk space requirements; slows down the write operations; requires additional backup resources (tapes?); might have implications for database mirroring. Creating the index might lock the table involved.
The value of the database, and the availability of the database, is quite high; and shouldn't be jeopardized by ad-hoc requests from developers.
Admin
I was alerted to the issue and got to work on opening the three tickets and making the two phone calls so I could get the ball rolling on a fix. Those are literal numbers.
And then I started getting IM's and phone calls demanding updates about what I was doing to fix the problem.
So the updates were "I am currently updating various managers and directors regarding the status of the issue. When I have finished with these updates, I will return to the process of opening the necessary tickets so that we can get started fixing the issue."
They weren't as amused as I was.
Admin
I have actually been in a few of those... it's like wtf really? Why can't we just do it now instead of discussing when we should discuss it....
Admin
Admin
I really, really dislike DBAs. Hopefully, the column being changed from 25 to 50 was not typed as character (which allocates that amount of storage) but was instead typed as varchar which meanss that the amount of storage used depends on the size of the actual data, the data is just constrained to a maximum of 50 characters on insert/update.
Another time, on the first day after adding several hundred users to a user base of less than 100, login times went off the cliff, it was taking a user 20 minutes just to login. Our dba(s) were wanting to balance the table space between drives, talked about buying faster hardware, etc. I suggested adding an index to the user security table and was told it would not help. After a few minutes, I convinced the dba(s) to add the index, login time went down to seconds.
And I really dislike managers who try to solve problems through group think, if these meeting take more than 5 minutes, it is obvious that the first step is to actually define the problem. A nightly batch job was still running after several hours when it had been running in less than 5 minutes. Checking the logs showed that the time had been increasing each day for several weeks which coincided with a program revision. I got into trouble for stepping out to actually check the logs rather than sit with the headless chickens who were busy discussing possible causes of the slow running job.
Admin
The physical database is not a critical part of the business, the data inside the database is the business critical piece.
Indexing can be overdone, but having application performance where things are taking minutes/hours instead of seconds is unacceptable.
When the application/data is unusable due to performance, locking users out in order to add an index is a reasonable course of action, the users can not use the application/data anyway.
Anything that prevents users from adding and updating the business critical data is an issue, pretending that developers are making ad-hoc changes for the sake of a change is a sham. These developers are trying to make sure that the business can continue getting the data that is so valuable.
As far as disk storage cost, really, still beating that drum?
Admin
Gosh, it sounds like you're working in an amateur shop that hires bottom of the barrel talent, from what you're describing. I'm not sure how you even ended up working there!
Admin
Unless the developer has a good background in database design, knows index consolidation, knows how to check index statistics/usage/management, then they have no place being the word of authority on what gets indexed how.
By merely showing that 1 query all of a sudden performs better by changing an index, MIGHT mean that is the proper course of action but doesn't guarantee it, at all.
A lot of problems arise over time when people who don't know index internals have the authority to dictate how things get indexed.
IF you don't know index internals, I don't care what your opinion is about indexing or your 1 scenario. Just as you shouldn't give a damn what my opinion is on how you should write your code using what constructs/assemblies/languages, etc. You know your job, and the good DBA knows theirs. To pretend you know each others is not helpful.
By the way, damn right storage cost is still an issue. Just as you pointed out, it's not just the 'physical disk the database stays on' that's the only issue. Physical hard drives might be cheap (by the way, they aren't, not SAS or enterprise SSDs, they are actually quite expensive) but the cost to host them and the cost to access the data adds up. I realize you're not writing the check but let's not pretend it's not a constraint.
Admin
Right; however, the question is when should these concerns be taken into account, and whose responsibility is it? I, personally, would much rather see the roles of "database schema/query/... developer" and "production database caretaker" split apart, as the two jobs require a...fairly different set of traits, even though they both involve (different instances of, of course ;) the same software for the most part.
Also: does every last drop of data in the DB need to be on super-expensive SSDs or SAS drives? I suspect not...
CAPTCHA - suscipere: The database was suscipere to outages caused by the DBAs having to babysit the darn thing all the time.
Admin
Actually I have worked in multiple shops over the last 30 years that either used Oracle (90%) or Informix. I have had the pleasure of working with several highly competent DBAs and the misfortune of working with less than qualified DBAs. The majority of my work has been as a system integrator/developer where the majority of the application was written and designed by an external vendor as a commercial product; most of the development that is done is either reports/queries, simple screen modifications or performance tuning related to the database.
the less than capable DBAs have made the following statements or errors.
Admin
And during peak hours, of course.
Admin
Admin
Windows Update has a few orders of magnitude less entropy than a rogue/witless DBA.
Admin
And this bad apple got the boot fast and hard I would hope? Working with a sucky insert IT job here past help desk is always a pain the rear. Sticking with a company that doesn't know the difference/puts up with it is TRWTF IMO.
Not saying you did or didn't, but just any highly skilled I.T. engineer can get a good job at the drop of a hat.
Admin
And this bad apple got the boot fast and hard I would hope? Working with a sucky insert IT job here past help desk is always a pain the rear. Sticking with a company that doesn't know the difference/puts up with it is TRWTF IMO.
Not saying you did or didn't, but just any highly skilled I.T. engineer can get a good job at the drop of a hat.
Admin
Did the company have proper CM policies in place? If so, was the idiot held responsible for ignoring them? If the company didn't have proper CM policies distributed, then was the idiot pointy haired boss held responsible?
Admin
The plan to fix a problem in 4 steps:
By the way, if blame is to be assigned, it only shows up in the last step. Now get out there and solve the problem!
Addendum (2014-06-21 14:07): Whoops. It looks like I used training twice. More/better docs? Better policies? More thorough training? Hardware repairs/upgrades? Yeah, that's more along the lines.
Admin
Admin
The DBA manager's actions are not within the guidelines of the fair labor standards act (in USA). Managers here cannot 'lock down' employees.
Admin
It's a long-standing management worldview that holding a meeting about a problem is equivalent to solving the problem.
For example, I was on a development project that ran over the time allotted by management (which was approximately 1/5 the time the development team had estimated), and management attempted to solve this problem by daily meetings where they grilled each developer on what they had done in the last day.
The developers (who had been told that their primary reward for the 80-hour work weeks they were now expected to put in was to keep their jobs) weren't complete fools and didn't respond with "Yesterday, I spent 3 hours explaining to you what I did the day before, and then spent another 10 hours doing my job. I haven't seen my family in months."
When the project was sorta-completed (in 2/5 of the time the development team had said they needed, without any truly glaring bugs), management patted themselves on the back for "maintaining tight control of the project" which they were certain was why it had been completed at all. The managers involved were promoted, while the development team received nothing at all for their 80-hour work weeks. For some reason that management couldn't understand, approximately 2/3 of the development staff quit within the next year.
Admin
one of the comments reminded me of a story: a manager tried to improve meeting attendance by establishing a FINE system: (minutes late*number of people in meeting) dollars. but less than a week later, the SAME manager was an hour late to a meeting with 100 people...