Page 1 of 2 12 LastLast
Results 1 to 15 of 30

Thread: Help Needed!!

  1. #1
    Join Date
    Mar 2003
    Posts
    10

    Unanswered: Help Needed!!

    Hi,
    I have been SQL developer for past 2 yrs, want to get into Administration(DBA) can any one suggest me some good articles on net and good books for this.

    TIA,

    sudheer.

  2. #2
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    Best book on the planet: Inside SQL Server 2000 by Kalen Delaney.

    Also:

    SQL Server Performance Tuning Technical Reference (Microsoft Press)
    Articles on:
    sql-server-performance.com
    sqlteam.com
    sqljunkies.com

    That should take you a long way.

    Learn to use profiler, performance monitor, and traces really, really well.

    Learn how to analyze execution plans, the locking and transaction processes for SQL Server, and when you're comfortable with that, come back for more.

    There's always more to learn.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Drop $49.00 for the full blown developer edition from M$

    Install it and use it...

    Nothing like hands on...

    And remeber, it's a matter of when, not if...

    Always be able to recover within minutes...

    That said...being a pure DBA is boring....

    Target being a systemn architect...whatever that means...

    Or wash windows...

    http://www.sqlteam.com/forums/pop_pr...isplay&id=7198
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    They call them Data Architects here. But from what I saw they have very little understanding of administration, mostly talk about database federation and project prosecution. Understanding internals of the engine they leave to us, but more often than none lack of understanding of the above leads to bigger things failing. Example of it would be as simple as selection of the wrong datatype, but it's so common, even in this forum.

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Ya mean like...

    CREATE TABLE Person (SSN int NOT NULL, ect
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  6. #6
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    That, and also:

    create...PhonePrefix int not null, PhoneSuffix int not null...
    YesNoFlag char(3) not null...

    3 TEXT fields in the middle of the table, followed by a dozen of INT's...

  7. #7
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Another reason for cross-over knowledge for both Admins and Architects, as well as for cooperation between the two.

    By the way, my rule for developers is: "If you don't add it, subtract it, multiply it, or divide it, it ain't a number."
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  8. #8
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    My rule is (which nobody here agrees with), - you can't be a DBA without a good solid background in development, a couple of "real" systems still running and your name popping in the "About" dialog box.

  9. #9
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    I'd say you can be a decent DBA without development experience, but not a good DBA or a great DBA.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  10. #10
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Originally posted by rdjabarov
    They call them Data Architects here. But from what I saw they have very little understanding of administration, mostly talk about database federation and project prosecution.
    shoot 'em

    they may be "data architects" in title, but they are not in fact
    Example of it would be as simple as selection of the wrong datatype, but it's so common, even in this forum.
    hang 'em, then shoot 'em
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  11. #11
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    That is so cruel. Being a knee-jerk liberal, I believe that everyone can be reformed. I think some sort of long-term institutionalized treatment, possibly in conjunction with electro-shock therapy, might be effective.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  12. #12
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I'd rather have a bottle in front of me than a frontal lobotomy

    But that's just me....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  13. #13
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    no way

    data architects have to be able to think

    i oughta know, i are one

    put these guys out of their misery, i say

    where i do have compassion, though, is for DBAs trying to climb the evolutionary ladder to Data Architect

    first of all, most of them can make the step up easily, being able to think and all, and secondly, you give them a break for wanting to

    but as you may suspect from phrases like "database federation and project prosecution" there is a much higher bullsh1t factor in data architecture, being, as it unfortunately is, closer to management, which is permeated with the stuff

    one thing i'll say for DBAs, they usually enjoy a life far removed from management, to the detriment of neither and the greater good of all concerned
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  14. #14
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Well, the reason why I said that development background is a must, because before one can administer anything, they need to be able to say that they own it. Without knowing how to develop it you can't say that it's "your baby". And without it being "your baby" I, for example, can't care less how it works and whether it works at all.
    But even before all this comes to play, one needs to be able to understand the business that an application is running for, and a specific business need that it serves. blah-blah-blah (place holder for words that the author can't come up with to express what he "really" thinks about it, - a lot of passion )

  15. #15
    Join Date
    Feb 2004
    Posts
    193
    I have another question along the lines of the original post. I just accepted a job as a Data Analyst/Computer Programmer Friday. I begin my new job April 22nd after 16 very long months of looking. The technologies they will use are SQL Server, MS Access(which they are outgrowing, hence SQL Server) and VB. I am not sure if it is VB.net or VB6 but when I spoke to the owners they mentioned that as I advance there are possibilities for an eventual DBA position. It is a small company that deals w/ a ton of healthcare related data. I see it as a great opportunity. Anyway, the issue is when I see posts from the Oracle DBA's their suggestion is to be able to "break and recreate the database". What does that mean exactly?

    Thanks again. I really love this board.

    ddave

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •