| Author |
Topic |
|
dcwebman
Starting Member
11 Posts |
 Posted - 2006-04-20 : 11:49:27
|
| I am supposed to learn how to be a backup for our DBA and probably take over the job. To do that I am in the middle of taking Micrsoft's course "2072A Administrating a Microsoft SQL Server 2000 Database". We are still using 2000 and don't plan on upgrading to 2005 for awhile so that's why it's 2000.Anyway, the course is good for the DBA stuff but I guess I was expecting to get more out of it like how to use Enterprise Manager to create tables, indexes, relationships, etc. The instructor said that would be more of a design course of which he didn't know any. So that leads me to finding a book to fill in the missing pieces. I want to stay with the SQL 2000 arena, so what is the best book out there to fill in the missing pieces I'm looking for to be a full DBA?Thanks,Jeff |
|
|
michaelxvo
Starting Member
47 Posts |
Posted - 2006-04-20 : 14:10:28
|
| I did a lot of research to find a real book teaching about being a DBA. Finally, I found it and I would suggest this book. It covers many details of SQL server 2000.SQL SERVER FAST ANSWERS FOR DBA AND ADMINISTRATORSWEBSITE: http://www.joesack.com/OR AMAZON WEBSITEhttp://www.amazon.com/gp/product/1590595920/sr=8-6/qid=1145556392/ref=sr_1_6/104-7852797-2371914?%5Fencoding=UTF8 |
 |
|
|
dcwebman
Starting Member
11 Posts |
Posted - 2006-04-20 : 18:32:33
|
| I looked at the table of contents to that book and it seems like it covers what I need. I'm not sure how much depth it goes into each topic though since it says "How to" at the beginning of each section. Is it a brief topic or does it give enough info?Even though it hasn't gotten great reviews, I'm also looking at MS Press's "Microsoft SQL Server 2000 Administrator's Companion" by Garcia, Reding, Whalen, DeLuca. That one seems like it covers everything a DBA needs to know. Anybody have any experience with that one?Thanks,Jeff |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-04-20 : 23:20:25
|
| >> how to use Enterprise Manager to create tables, indexes, relationships, etcI would advise against that. Does your company allow it?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-04-20 : 23:27:16
|
| I have found that the "howto" books all basically suck. Look into getting the ken henderson books, get kalen's inside sql 2000 book. that will be a good start.the best thing you could do is stick around here and learn. -ec |
|
|
|
dcwebman
Starting Member
11 Posts |
Posted - 2006-04-21 : 07:21:11
|
quote:
Originally posted by nr
>> how to use Enterprise Manager to create tables, indexes, relationships, etcI would advise against that. Does your company allow it?
Actually I think our dba uses a 3rd party tool and then creates a script. But I need to understand more thoroughly all that stuff, the concepts, regardless of what tool to use. |
|
|
|
michaelxvo
Starting Member
47 Posts |
Posted - 2006-04-21 : 13:36:36
|
| you can open the link directing to amazon website to read reviews from people who actually bought the book. I see 5 stars grading. Personally, I have this book in electronic file. It is the only ebook that I put my precious time sitting down for 3 weeks (one hour a day) print over 1000 pages front and back into paper sheets and put in the binder because I think it is worth my time |
|
|
|
druer
Constraint Violating Yak Guru
314 Posts |
Posted - 2006-04-21 : 13:52:49
|
| A free way to learn is to use Enterprise Manager to build some tables, create some indexes, build some defaults, build some relationships and have the SQL Profiler turned on. Then you'll see the actual T-SQL commands that get executed behind the scenes. Then take some of the commands out of the profiler, put them in the Query Analyzer window and make some slight changes to them. The Enterpise Manager knows "how to" and will document exactly what it is doing via the Profiler. (he-he). |
|
|
|
|
Design SQL 2000 DBA book?