SQL Server Performance

"The Self-Taught DBA" Article

Discussion in 'Getting Started' started by Mustang302, Jun 14, 2007.

  1. Mustang302 New Member

    Hello All-

    I've been in the IT field for about 6 years now and have dabbled with mySQL before but never done full blown DBA work. I am currently one of the system admins for the company i work for and my boss has asked me if i wanted to start learning SQL and taking care of the databases. He has given me about 6 months to learn as much as i can before making me responsible of the databases.

    So far, i have found many articles online but nothing that is really "step by step" on how to learn what i want to know, it all seems to be basic stuff on how to run simple queries and im wanting to learn all there is to know to become a beginner, intermediate and then advanced DBA. I came up on this "The Self-Taught DBA" article and thought it was a good read, but the books that the author suggests seems to be outdated and are for Server 2000. Can anyone compile a new list of books that are newer versions? I am also looking for any training videos that don't cost an arm and a leg, or any "step by step" articles that wont confuse the hell out of me, heh. Ive done my searches on these forums before posting this and ive read and read, and been to sqlcourse.com, sql-tutorials.net and similar websites suggests by other members but like i said they are very very basic.

    Thanks again

    Jim
  2. FrankKalis Moderator

    First book as always is BOL. <br />Also get your hands on the "Inside SQL Server 2005" book series. And further<a target="_blank" href=http://www.amazon.com/gp/product/0321447743>http://www.amazon.com/gp/product/0321447743</a> . Subscribe to the SQL Server blogs run by the dev team members on MSDN and persuade your boss to spend some well-invested money to get some seminars. Presumably held by Solid Quality Learning. <br /><br />And in any case of uncertainty, check back here. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br />Contributing Editor, Writer & Forum Moderator<a target="_blank" href=http://www.sql-server-performance.com>http://www.sql-server-performance.com</a><br />Webmaster:<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a>
  3. Madhivanan Moderator

  4. satya Moderator

  5. FrankKalis Moderator

    Satya, he did so already but asked for an updated for SQL Server 2005. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br />Contributing Editor, Writer & Forum Moderator<a target="_blank" href=http://www.sql-server-performance.com>http://www.sql-server-performance.com</a><br />Webmaster:<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a>
  6. FrankKalis Moderator

  7. satya Moderator

    [<img src='/community/emoticons/emotion-1.gif' alt=':)' />] can't see the forest for the trees.<br /><br />Then in addition to Frank's reference you could take help of<a target="_blank" href=http://msdn2.microsoft.com/en-us/library/ms169620>http://msdn2.microsoft.com/en-us/library/ms169620</a>(SQL.90).aspx (BOL)which has plenty of information for HOW-To topics too.<a target="_blank" href=http://sqlserver-qa.net/blogs/tools/archive/2007/04/18/how-do-i.aspx>http://sqlserver-qa.net/blogs/tools/archive/2007/04/18/how-do-i.aspx</a> on HOW DO I.<br /><br /<a target="_blank" href=http://sqlserver-qa.net/blogs/tools/archive/2007/05/09/35-off-on-sql-server-2005-books.aspx>http://sqlserver-qa.net/blogs/tools/archive/2007/05/09/35-off-on-sql-server-2005-books.aspx</a><br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</i></font id="size1"></font id="teal"></center>

Share This Page