|
|
|
SSC-Dedicated
           
Group: Administrators
Last Login: Today @ 3:30 PM
Points: 31,436,
Visits: 13,751
|
|
|
|
|
|
SSCrazy
      
Group: General Forum Members
Last Login: Wednesday, April 24, 2013 5:02 AM
Points: 2,365,
Visits: 1,825
|
|
hi where is this article? clicking on temp does not take me anywhere
"Keep Trying"
|
|
|
|
|
SSCommitted
      
Group: General Forum Members
Last Login: Today @ 7:27 PM
Points: 1,559,
Visits: 1,398
|
|
|
|
|
|
SSC Journeyman
      
Group: General Forum Members
Last Login: Monday, July 23, 2007 4:05 AM
Points: 97,
Visits: 1
|
|
| Excellent article. I must admit I'd be pretty OK and on top of things. However I am still printing you article and pinning it to my wall as a 'little reminder' not to be complacent. We use SecureWord for passwords and Foglight and Spotlight for monitoring. These tools can make you lazy though. When I inherited the DBA role, I found every single connection used sa with a blank password. We are now fully SOX compliant with database roles in place etc. Having said all that I sat the 70-228 exam and failed. No score for section 1 and around 75% correct on all other sections. The exam crashed after 20 minutes into it. Another story. Got no resit and all that. Even though I failed the exam, I personally rate myself as a very proactive and technically strong DBA. Thanks again. Derek
|
|
|
|
|
SSCrazy
      
Group: General Forum Members
Last Login: Thursday, May 16, 2013 2:10 PM
Points: 2,668,
Visits: 688
|
|
Nice article Steve, I actually fail to be amazed now on how many ( interviewed ) dba's wouldn't get past some of your points - I won't go into what I've found in my travels either!!! It was a good slant to look at DBA skills in this manner.
The GrumpyOldDBA www.grumpyolddba.co.uk http://sqlblogcasts.com/blogs/grumpyolddba/
|
|
|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:03 AM
Points: 175,
Visits: 324
|
|
Good article. Social and communication skills are necessary, such as being able to explain to an executive "why anyone cared about the objects in the database".
|
|
|
|
|
Grasshopper
      
Group: General Forum Members
Last Login: Monday, April 29, 2013 1:42 PM
Points: 12,
Visits: 74
|
|
I worked at a company that prided itself in being the world leader in "communications interception" technology (i.e. wire taps++)
They routinely configured systems to backup the database to the local drive.
No tape backups.
Insane.
|
|
|
|
|
SSC Journeyman
      
Group: General Forum Members
Last Login: Monday, July 23, 2007 4:05 AM
Points: 97,
Visits: 1
|
|
| I agree. No tape backups is nuts ! We backup remotely to disk and then to tape. Tapes are stored off site. We also log ship to a DR site. And I don't think we are paranoid !!! You know this article really go me thinking on my own day to day activities and could I work under pressure ! I have worked in the past under extreme pressure, ie migrating to JDE, server migrations etc. But do I actually analyse dbcc reindex correctly and regularly etc. Anyway thanks again. Derek
|
|
|
|
|
SSCrazy
      
Group: General Forum Members
Last Login: Today @ 6:51 AM
Points: 2,726,
Visits: 2,928
|
|
Nice article. However I never see any DBA get fired who had made the mistake on your list. In my last job, the junior DBA actually called herself 'GOD' because she said she was in charge of everything.
|
|
|
|
|
SSC-Insane
         
Group: General Forum Members
Last Login: Today @ 4:55 PM
Points: 21,357,
Visits: 9,540
|
|
Everything being coffee and pizza ?
|
|
|
|