SQL Server Books

0 pts.
Tags:
SQL Server
Standard Edition 2000
I am an Oracle DBA learning SQL Server. Does anyone have any favorite books for SQL Server 2000. I am looking specifically for books geared towards everyday tasks performed by a DBA.
ASKED: May 19, 2004  4:36 PM
UPDATED: May 20, 2004  11:56 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi.

Books Online. Just as the Oracle manuals are required reading, so is SQL’s Books Online.

That said, I recently picked up Ken England’s “Performance Oprimization and Tuning” and found it a VERY useful addition to the Books Online.

Ken Henderson has a couple of good T-SQL books (learn T-SQL… not hard, although a bit of a mental shift from PL/SQL, and I’m sure you’ll agree that, by comparison, T-SQL truly sucks.)

Haven’t come across any good backup/recovery books, and would love to hear from other folks on that.

As for the 1000-page unleashed/black book/etc books… They might give you a bird’s eye view, but IMHO they’re rarely useful as daily references. You may find the occasional nugget of wisdom there.

Better to get a Safari subscription (see, for example, safari.oreilly.com) and browse some of these suckers online.

HTH!

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Smeagol
    Books Online is my usual start point. I can also recommend Microsoft SQL Server 2000 Administrator's pocket consultant ( by William R Stanek) as useful for day to day stuff. It won't teach you the basics, but as an experienced Oracle DBA you already know what sort of things you need to achieve (I for one get tired of large books in which you skip the first X chapters if you already have some DBA experience behind you!) The SQL Server 2000 Resource Kit (various authors) is a good background book, though more for guiding design decisions than day to day admin. Again, not for beginning DBAs.
    0 pointsBadges:
    report
  • Ericggordon
    Good morn ... I am in agreement with the replies you have received thus far. I am on the otherside of the DBA transitioning curve as a SQL DBA acquiring Oracle skills. As noted: 1. Books online is key, comprehensive, and very helpful (aslo note that Microsoft has recently released an upgrade to BOL) 2. SQL Administrator's Pocket Consultant, SQL Resource Kit, and SQL Companion Guide 3. ... also O'Rielly's SQL Tuning 4. Make sure to subscribe to SQL Server Magazine 5. and let me not leave out our sponsors, SearchDatabase.TechTarget.Com 6. on the flip-side, www.dbforums.com Any reciprocated direction with respect to Oracle DBA resources would be greatly appreciated. Regards ...
    0 pointsBadges:
    report
  • Hopkihc
    Hi Eric. Thanks for the added recommendations... need to check out some of those myself! As for Oracle resources, gee, where to begin. The manuals have just gotten better and better, and I'd start with the concepts book. The logical-to-physical mappings and locking mechanisms are significantly different, so you'll want to get a handle on those right away. Aside from those... my favorite recent books have been Tom Kyte's two books. Great writing style, and sensible and informed advice. He doesn't make broad and unfounded "opinions" about Oracle... he proves his point with benchmarking. See asktom.oracle.com, too, for other pearls of wisdom. Technet membership will help: otn.oracle.com. For PL/SQL, I'm a big fan of Feuerstein's books (unless you think you'd bristle at his examples, into which he's injected a hefty dose of his political views). For backup and recovery, the Oracle Press book on RMAN is quite good I think, although does not spend a lot of time on DBMS architecture, which you'll want to know to be effective. Can anyone here comment on Rich Niemec's tuning book? Let's hope your company will foot the bill for an IOUG-A membership. It was worth it for me. Glad you're getting an opportunity to work on two platforms. They both have their strengths, although I can deal with Oracle's relative complexity far easier than SQL Server's relative lack of features (what, no row-level triggers?!?!). -John
    0 pointsBadges:
    report
  • Jrmills
    I was getting ready to reply to the request for where to start with Oracle books, when I found that hopkihc said exactly what I would have. The documentation, particularly the 9.2 documentation is excellent for the most part (you do run across subjects that could have been done better) and the Concepts volume is the best place to start. My tendency, and I suspect most other people's, is to assume you will get a better more effective introduction with third party publications. In this case, at least, Oracle has done a very good job, with links throughout to greater detail. I also agree with including Kyte's two books in your reading.
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following