Home   |  Articles   |  Resources   |  Humor   |  Feedback       

  Login   Register 

Ads Via DevMavens


Top 10 Signs you hired the wrong SQL DBA

Posted by on Friday, February 06, 2004

What not to look for when you are hiring a SQL DBA or When to consider replacing your DBA

    10. They can’t understand why changing column names break the application

      9. Think performance tuning = buy better hardware

      8. Believe a Stored Procedure which compiles is production ready

      7. Forcefully argue that indexing every field in the databases is the best way to increase performance (right after buying better hardware)

      6. They prefix all stored procs with ‘sp_’ – so as to be consistent with the Microsoft naming convention

      5. Thinks 9 hours to copy one million records across databases is ‘good performance’

      4. Thinks a stored procedure is the best way to copy one million records across databases.

      3. Is convinced that the error generated by trying to insert a duplicate primary key value, is a bug in SQL

      2. Thinks adding a new column to a table is a four step process: create a new table, copy  all the data over, drop the old table, and rename the new table.

      1. Believe that adding a foreign key constraint with the ‘Enforce Relationship’ checkbox unchecked is the best of both worlds, it defines relationships without having to deal with ‘those pesky constraint errors’ when modifying data.

 


 


Comments:

RE: Humor
By MajorCats on 6/25/2004
OMG, this isnt funny. Been there, done that.

Top 10 Signs you hired the wrong SQL DBA
By gregdyck on 12/8/2004
Or how about the one where the dba creates the tables before the application is designed and you're stuck with an incongruent model that is a pain to work with. Not to mention that the table and column names do not fit the design and purpose they are used for, you the designer are brushed off because the dba has the "big picture" you are forced to work with it. He even creates some extra tables you have no use for because he thinks they might be used some day.

Copyright 2004 OdeToCode.com 


My view of Microsoft is that they had two goals in the last 10 years: to copy the Macintosh and to copy Lotus' success in the applications business. And they accomplished those goals. Now, they're kind of lost.
--Steve Jobs
The Blogs
Subscribe to the OdeToCode blogs for the latest news, downloads, new articles, and quirky commentary.
Contribute Code
Privacy
Consultancy