# MSSQL 2000 Book Suggestions

**URL:** <https://boards.straightdope.com/t/mssql-2000-book-suggestions/163182>\
**Category:** Factual Questions\
**Created:** [March 21, 2003, 7:12pm UTC](https://boards.straightdope.com/t/mssql-2000-book-suggestions/163182 "2003-03-21T19:12:33Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![SkipMagic](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/skipmagic/32/20706_2.png) [@SkipMagic](https://boards.straightdope.com/u/SkipMagic)\
**Post date:** [March 21, 2003, 7:12pm UTC](https://boards.straightdope.com/t/mssql-2000-book-suggestions/163182/1 "2003-03-21T19:12:33Z")

</div>

I’ve a new partner for my position (a sentence fragment that could, but shouldn’t, be taken the wrong way… ahem!) here at work, and I want to get him a well-written, factually informative book about how to work with MSSQL 2000.

I know that, factually, the Microsoft Press books are (obviously) right up there, but they’re a little dry, sometimes confusing for the beginner and, of course, tend to talk solely about other Microsoft products and add-ins whether or not there are better, competing products on the market.

So… I’m looking for a beginning to intermediate user’s book with explanations on how to structure queries within a MSSQL environment; how to deal with database sizes; how to set up and manage transaction logs, etc…

Any suggestions from the Peanut Gallery?

And… Mods: I almost posted this in IMHO, but I felt that GQ might produce better answers; however, if you feel differently, go ahead and query my butt right out of this forum. 🙂

---

<div class="post-metadata">

**Author:** ![zev\_steinhardt](https://avatars.discourse-cdn.com/v4/letter/z/97f17d/32.png) [@zev\_steinhardt](https://boards.straightdope.com/u/zev_steinhardt)\
**Post date:** [March 21, 2003, 7:21pm UTC](https://boards.straightdope.com/t/mssql-2000-book-suggestions/163182/2 "2003-03-21T19:21:25Z")

</div>

For T-SQL programming, I would recommend [Professional SQL Server 2000 Programming](http://www.amazon.com/exec/obidos/tg/detail/-/1861004486/qid=1048274360/sr=8-1/ref=sr_8_1/104-1271552-0612734?v=glance&s=books&n=507846) by Robert Vieira is an excellent book. His book also covers some administration aspects as well.

In general, I tend to find Wrox books a cut above the rest.

Zev Steinhardt

---

<div class="post-metadata">

**Author:** ![SkipMagic](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/skipmagic/32/20706_2.png) [@SkipMagic](https://boards.straightdope.com/u/SkipMagic)\
**Post date:** [March 21, 2003, 7:49pm UTC](https://boards.straightdope.com/t/mssql-2000-book-suggestions/163182/3 "2003-03-21T19:49:47Z")

</div>

Thanks, **zev\_steinhardt**! You’re the second person today who has approved of Robert Vieira’s books. I really like the O’Reilly series of books (for PERL, Linux and PHP), but they didn’t seem to have a good book for MSSQL.

I’ll take a gander, also, at the WROX books for MSSQL administration.

Thanks again!