Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqldbanoob
Starting Member
1 Post |
 Posted - 2007-08-28 : 09:58:09
|
| Hi. I want to be a SQL DBA and have been reading stuff on my own. I need help getting started though. if any of you can suggest what I should focus on learning or if there are any websites that has good details for the steps on how to perform tuning, mirroring, clustering, all the duties of a SQL DBA. I could really use the help and I appreciate any help given. thanks. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-08-28 : 10:50:17
|
| a little known site with great help_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-08-31 : 20:44:25
|
quote:
Originally posted by sqldbanoob
Hi. I want to be a SQL DBA and have been reading stuff on my own. I need help getting started though. if any of you can suggest what I should focus on learning or if there are any websites that has good details for the steps on how to perform tuning, mirroring, clustering, all the duties of a SQL DBA. I could really use the help and I appreciate any help given. thanks.
I can recommend books that have helped me: Beginners Guide to Transact SQL (Wrox)Gurus Guide to Transact SQL - Ken HendersonAdmin 911 SQL Server 2000SQL Server 2000 UnleashedAlso, I am finding that the DBA job is a pretty even blend of SQL knowledge and Admin knowledge. Something that was extremely helpful for me was the advice to use Query Analyzer commands rather then the GUI as much as possible for flexibility and reliability, you also learn much more in the process even when it is easier to just click the mouse! I would also recommend printing out or at least keeping close by a reference with all the system tables, functions, DBCC commands ( for older stuff ) and system global variables so you can grab them quickly and learn them through immersion. Finally, I would just recommend taking on projects and completing them utilizing the resources I mention. Also, as stated before, this site is an awesome resource! Especially check out the FAQ and try and help solve the puzzles that people post each day, it is great practice! ------------------------Future guru in the making. |
|
|
|
Kristen
Test
22859 Posts |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2007-09-04 : 08:49:22
|
quote:
Originally posted by sqldbanoob
Hi. I want to be a SQL DBA...
First you must submit your application and processing fee to the United International Brotherhood Of Database Administrators.Which is located in my basement.e4 d5 xd5 Nf6 |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-04 : 09:10:52
|
 |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-09-04 : 09:30:24
|
quote:
Originally posted by blindman
quote:
Originally posted by sqldbanoob
Hi. I want to be a SQL DBA...
First you must submit your application and processing fee to the United International Brotherhood Of Database Administrators.Which is located in my basement.e4 d5 xd5 Nf6
Don't forget the secret initiation ritual."Thank you, sir! May I have another?"CODO ERGO SUM |
|
|
|
|
|
|
|
|
things a SQL DBA should know about?