November 14, 2003 at 9:07 am
I am a newbie who has been through SQL Server 2000 once.
I am finding this book does not cover some of the detail I now need e.g.
Restoring databases
No mention of how to restore master, that database has to be in single mode, how to get in single mode. Why I can't get in single mode etc. etc.
Also could do with more in depth coverage of DTS, ActiveX scripting, profiler, debugger etc. etc.
Any recommendations.
November 14, 2003 at 11:39 am
Have you searched through the book section on this site?
You might find something valuable.
For DTS you might want to take a look at http://www.sqldts.com .
There is also a site called SQLBooks on http://www.sqlbook.com .
What do you mean by '..through SQL Server 2000 once'?
The 'Inside SQL Server 2000' book by Kalen Delaney?
If so, I think this book has another intention. It does not focus on how to programm SQL Server, but rather what happens behind the scenes and under the hood. And for this purpose it's #1 for me.
HTH
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
November 14, 2003 at 12:04 pm
A book that covers the basics very well is SQL Server 2000 DBA Survival Guide. Most books don't cover DTS or ActiveX scripting in much detail though. You might need to get a DTS-specific book.
For more advanced topics, I like SQL Server 2000 for Experienced DBAs. It covers a lot of things that you don't see much in most SQL Server books. (Clustering, performance monitoring, advanced troubleshooting)
JM
November 14, 2003 at 1:53 pm
I enjoyed SQL server 2000 Perf Tuning a Technical reference by Whalen, Garcia, Deluca Thompson inter alia.
One other way is to read the recommendations from amazon.com barnes and noble etc... and from some of the many good user websites out there ( have worked for me)
It may be of benefit to explore the articles on sqlservercentral
Mike
November 15, 2003 at 2:56 pm
Sorry, I typed too fast - I should have written SQL Server 2000 Unleashed
November 17, 2003 at 4:57 pm
I also thought Delaney's book was pretty good, but it is not a 'How-To' manual, more of a book to help you understand WHY things work the way they do...
Others to consider are:
Ken England's "SQL Server 2000 Performance Optimization and Tuning"
-and-
Alan Hirt's "SQL Server 2000 High Availability"
I have heard good things about "Professional SQL Server 2000 DTS" from WROX press, but have not yet read it.
-Dan B
November 27, 2003 at 4:01 am
Thanks for the replies. I read the reviews and based on these and also the described content of the books, I decided that the one which sounded like it most fitted my requirement was:
Microsoft SQL Server 2000 Data Transformation Services (DTS) by Timothy Peterson
I am currently awaiting deliver by Amazon UK
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply