IT programming books related reviews
Title: Inside Microsoft SQL Server 7.0
Publisher: Microsoft Press
Authors: Ron Soukup, Kalen Delaney
Rating: 5/5
If you already know the basics and are interested in intelligent database design, this is the book for you. It delves into the internal workings of SQL Server and helps you understand how the program actually stores your data and the factors that could affect database performance. (After reading this book, I was able to redesign my some tables to reduce long-running queries by about 90%.)You can also buy the more recent edition on SQL Server 2000 if you are planning to upgrade soon.
Title: The Guru's Guide to SQL Server Stored Procedures, XML, and HTML (With CD-ROM)
Publisher: Addison-Wesley Professional
Authors: Ken Henderson
Rating: 2/5
This book is the guru's guide to transact-sql, second editon. It's fundamentally the same book with cursory and very beginner level XML chapters added. This is that same old collection of magazine tricks and command line stuff that's been left behind by the majority of professionals. This would be good if you are only interested in t-sql tricks to impress your friends. Loaded with obvious axioms in computer science and unusable code that is most often more dangerous and not wise to use at any time, than anything. [...]
Title: Apache Cookbook
Publisher: O'Reilly
Authors: Ken Coar, Rich Bowen
Rating: 4/5
On a similar note, I have the book, and have found it very useful at work over the past few weeks as some of our servers have been migrated from apache 1.3 to 2.0 and as I fix a number of the other small issues that had been bothering me. It is a great book that covers all of the issues that I have most frequently encountered, all with easy to implement solutions.Its great to have a problem, fix type set up, and even better that some of the items solutions are "You can't do it with apache right now." Instead of searching the web because an item was left out of the book, its nice to know of some limitations. It was also helpful to get some of the people insisting that I could do things that were not possible. If its in a book, it must be true!
Title: Microsoft Access Developer's Guide to SQL Server
Publisher: Sams
Authors: Andy Baron, Mary Chipman
Rating: 5/5
This is a great book. I have recommended it to coworkers who also purchased the book and they were equally impressed. This helped me have a much greater understanding of both Access and SQL Server and how they work together.
I would highly recommend this book to anyone using Access with SQL Server. It is easy to understand and has plenty of useful code examples. I use this as a reference on a regular basis.
Title: SQL Server 2000 Stored Procedure Programming
Publisher: Osborne/McGraw-Hill
Authors: Dejan Sunderic, Tom Woodhead
Rating: 5/5
I have been looking for a book like this for two years. This is the first book I've found that goes beyond the usual trivial stored procedure examples with one or two select and/or insert statements. It has everything I need - loops, conditional execution, error handling, debugging, dynamic queries. And the sample database has some great, real-world examples of very complex stored procedures.
Title: Client/Server Programming with Access & SQL Server: The Integrated Guide for Programmers & Developers
Publisher: Coriolis Group Books
Authors: Leo Sanin, Renzhong Chen
Rating: 5/5
I think this is the most fantastic and authoritative book on Access and SQL Server that I have ever read. It is filled with excellent examples that draw on the authors personal experience. A must read!!!
Title: Microsoft SQL Server 6.5 Unleashed (Unleashed)
Publisher: Sams Pub
Authors: David Solomon, Ray Rankins, David S. Solomon, Jeff Steinmetz
Rating: 5/5
You MUST have this book if you are doing anything with SQL.It may not be perfect. It is hands down the best reference out there.Get Soukup's book too...you'll be ready to rumble.
Title: Oracle SQL: 101 Frequently Asked Questions
Publisher: Komenda Pub. Co.
Authors: Gary M. Lewis, Alex Sirota
Rating: 5/5
It has some real jewels in here, even for a VERY experienced programmer. How to change the SQL prompt, compute all kinds of statistics, including MEDIAN very quickly. Worth $30.
Title: Sams Teach Yourself SQL in 24 Hours (3rd Edition)
Publisher: Sams
Authors: Ryan Stephens, Ron Plew
Rating: 1/5
I came to this book with a very basic working knowledge of SQL, hoping to round out my knowledge of more complex operations and get a better grasp of transactional operations. I came away with little more than I started with.The authors take such a broad approach, attempting to do the impossible - teach readers how to use ANSI-compliant SQL. Problem is, no RDBMS (Database platform) is truly ANSI-compliant. When it gets specific it's generally to show how MySQL does not do what Oracle does, yet for some strange reason they instruct the reader to use MySQL for exercises. Even funnier, something like 20% of the exercises cannot be done on MySQL, so they actually suggest that you get out a piece of paper and write them out! Why not just write a book called "Oracle SQL" and offer some comparisons with other implementations? The "see your implementation documentation for details" disclaimer occurs 2-3 times per chapter. So, why am I reading this again? Why not just read my RDBMS help files?In the same vein, the data provided to learn with is exemplary of "toy" code, with tables of 5-10 records each. Most chapters consist of run-downs of the various functions, sometimes with good examples, often without. The typos are rampant, with whole blocks of text sometimes being misplaced. Even the source data contains egregious errors. Obviously, this book was slammed out (in "24 hours" I bet), was not proofread, and forgotten. Third edition?!? Was the first edition just a bunch of garbled text??I could go on, but in summary, don't bother. Buy something else. Anything else. Most likely either a book aimed at a particular implementation (e.g. MySQL, SQL Server, Oracle, PostgresSQL etc), or one of the many books aimed at giving a working knowledge of SQL for web development (e.g. PHP and MySQL Web Development, etc). Good luck.
Title: Oracle SQL & PL/SQL Annotated Archives
Publisher: Osborne/McGraw-Hill
Authors: Kevin Loney, Rachel Carmichael
Rating: 5/5
I received my copy of this book today and have already located scripts to begin using. This book will be instrumental in setting up our "DBA" processes and procedures. I especially like how each script is documented as to what it is doing and why and when you would want to use it. This book will save me many hours in script-writing. Thanks Kevin and Rachel.

