IT programming books related reviews
Title: Oracle High-Performance SQL Tuning
Publisher: McGraw-Hill Osborne Media
Authors: Donald K. Burleson
Rating: 5/5
I bought this book looking for a method to tune all of the SQL in an entire database. Much of the introductory material is self-evident, but the advanced topics are very insightful.The text has lot's of examples, and clearly show how to find and fix sub-optimal SQL. Especially useful are the scripts to yank the SQL righ out of the library cache for analysis.Some of the text moves very slowly, but this is expected for a comprehensive book on SQL tuning. This book explains many nuances of cost-based versus rule-based optimization, and the coverage of SQL hints is very good. Overall, this one is a keeper.
Title: Oracle Reporting: Queries With SQL Objects
Publisher: Komenda Pub Co
Authors: Gary M. Lewis
Rating: 1/5
Don't waste your mone
Title: MySQL and PHP From Scratch
Publisher: Que
Authors: Wade Maxfield
Rating: 1/5
Since reading (and returning) this book, I discovered a miracle product that makes this book redundant -- there's no reason to spend a day or more installing PHP and MySQL when you can buy software that does it automatically in less than 10 minutes. There's a company called Abriasoft (.com for their website) that makes a CD that will install MySQL, PHP, Apache, and other such programs on your computer within 5 minutes. Awesome! It will install in either Windows or Linux. I'm a beginner in PHP, and could no more install these programs myself than fly, but it was a cinch with Abriasoft. I know I probably sound like an ad, but I have no connection with ABriasoft except for eternal gratitude!
Title: OCP Introduction to Oracle9i: SQL Exam Guide
Publisher: McGraw-Hill Osborne Media
Authors: Jason Couchman
Rating: 1/5
Book is good But Only if you are also using any other book.
Also If you are experienced Oracle user then it is OK to use this Book.I found Book from Sybex corporation much better than this Book.It contains scenario based questions which are new in OCP-9i
Oracle press should add more scenario based questions and material should be more detailed and real Exam types questions should be present in Book. Book contains only mulitple chioce questions which nowdays do not appear in OCP9i.
Title: PHP Fast & Easy Web Development, 2nd Edition
Publisher: Muska & Lipman/Premier-Trade
Authors: Julie C. Meloni
Rating: 4/5
This book is an essential pre-requisite for those who want to learn PHP script for database project development. It goes over the basics and gives examples, however somewhat limit, to enhance the learning experience. I recommend this book for those with little programming background who want to learn to use PHP to interface with a MySQL database. Once you finish this book and practice a little, you will want to move on to a more intermediate reading such as PHP and MySQL Web Development by Luke Welling and Laura Thompson and/or Web Database Applications with PHP & MySQL by Hugh E. Williams, David Lane. This book gives you the essential background. The only down-side is the authors use screen shots to illustrate the code example which can be a little hard to read. All of the source code is however provided on the accompanying CD.
Title: Optimizing SQL Server 7: Planning and Building a High-Performance Database (Prentice Hall Series on Microsoft Technologies)
Publisher: Prentice Hall Ptr
Authors: Jeffrey R. Garbus, Robert D. Schneider
Rating: 1/5
There is almost nothing about details of SQL Server 7.0 that would help you improve performance. This book is really dissapointing. This 2nd edition still only covers 6.5 stuff. One good example is the books description of the physical storage of the TEXT data type as using a linked list of 2K pages. SQL Server 7.0 has many advanced features for storing this data type and uses a B-tree instead of a linked list. The author goes over many tuning details needed when using 6.5 failing to mention the vast improvements in 7.0 that have made most of the tuning parameters obsolete.
Title: The Guru's Guide to Transact-SQL
Publisher: Addison-Wesley Professional
Authors: Ken Henderson
Rating: 5/5
This book changed the way I write T-SQL. I approach it now more as a language than a scripting facility. It's so powerful. There's so much you can do. I guess the best parts of the book are the ones that show off some of this power. My personal favorites are:1. The select chapter. Has to be the best narrative I've read on the select command. I had no idea you could do so much with it.2. The admin stored procedures chapter. Here's a goldmine of good, production-quality code.3. The undocumented chapter. Why doesn't MicroSoft document these? This chapter provides good insight into how SQL Server works behind the scenes.It's just a great book through and through. There's no filler or other nonsense -- just great writing and great code, the way a coding book should be.
Title: Professional Apache 2.0
Publisher: Wrox Press
Authors: Peter Wainwright, Poornachandra, Dr. Sarang, Afrasiab Ahmad, Sean Chittneden, Vivek Chopra, Micheal Link, Stephen G. Wadlow, Mathew Antony
Rating: 5/5
Apache's HTTP server has been by many measures the most popular web server on the web, and perhaps the primary application that drives people to Linux and open source. Three years ago, Wrox published the definitive book on running the Apache server by Peter Wainwright. Excellent though the book was, it badly needed updating. In May 2002, Wrox published another book, Professional Apache 2.0, which covers the new generation of Apache server, as well as older 1.3x versions that are still running production servers around the world." Although Apache changed a great deal in its version 2.0, it is a credit to the Apache folk that the config files and command line options have basically remained the same for sys admins. For this reason, the book seems to include a lot of material (CGI security, building, core modules) from the original book. However, a closer look reveals many changes. Almost every chapter includes a discussion about how features differ in both versions of Apache. The book does a good job of giving an overview of Apache's architectural changes and how the use of multi-processing modules (MPM) allow the admin to choose an optimal implementation of apache. This edition, noticeably bigger than the previous one, contains many more examples of how one can extend apache functionality (configuring for binary distribution, setting up virtual interfaces, load sharing). Many sections have been expanded. The discussion of security and SSL is more detailed, yet more succinct; so is the section on content negotiation, (which is twice as long as the previous book), doing proxy server configurations, rsync and benchmarking performance. The discussion on hardening the server was great and up-to-date, although I wish the book spent more time discussing on patching and upgrading. What is new to the book? We find a longer discussion of graphic administration tools for Windows and Unix, including webmin (which actually I wanted more of). We also have discussions of newer modules such as mod_ruby, mod_python, mod_dav as well as a brief description on how to install tomcat alongside apache. The discussion of mod_dav was especially helpful and interesting to me (and I was especially glad that the author acknowledged the Subversion DAV module, something which is bound to become more important). The php stuff hasn't changed much (although at the time the book was published, 2.0 compatibility with PHP was still an iffy proposition). The book's discussion of mod_perl isn't significantly different, although it does point out migration issues and some additional features. Generally, the book is clearly written and contains enough examples to find any configuration you want. A few parts required rereading (especially the part about proxies and proxypasses), and occasionally I needed a better explanation of what the example code was supposed to do. No book can be everything for everybody, and nobody can accuse the book of not having enough content (it is after all more than 700 pages!). I found myself wishing for other things. The book briefly discussed 2.0's support for ipv6, but I longed for a fuller explanation and a more detailed example (Fortunately, I had seen a good ipv6 tutorial on Linux Journal ). Also, I would have liked more information about other web application servers (like zope that Apache sometimes coexists with, content frameworks (such as cocoon) and other goodies produced by the Apache Foundation. The author might legitimately feel that such subjects lie outside the book's scope, but such topics are becoming more important. In summary: for newbies who are looking for a guide to start with: this is the definitive book to read. It's definitive and a little imposing, but it is well written and logically arranged. For people already familiar with Apache 1.3 but looking for more depth about ipv6, php, content frameworks or Tomcat, it might be better to read books on those specific subjects instead of this one. Indeed, Wrox will soon be coming out with a book specifically on Apache and Tomcat.For experienced system administrators, the material in this book may not be terribly new, but they will still appreciate the variety of configuration examples for managing large numbers of virtual hosts and the convenience of having documentation of the 1.3/2.0 differences at their fingertips.
Title: Php Fast & Easy Web Development (Fast & Easy Web Development)
Publisher: Premier Press
Authors: Julie C. Meloni
Rating: 5/5
Either of Julie Meloni's PHP books (PHP Essentials and PHP Fast and Easy) are great books to begin with for those who want to learn about PHP and MySQL.
Julie teaches by example with simple scripts that build upon what was learned in those before it. The accompanying web site is very good, which I find essential for any programming book as there are likely to be bug fixes needed and updates posted.While her two books cover much of the same territory they use (mostly) different script examples so I found both of them to be worth having. The more examples I can see of working code, the better I can understand it. I will buy any other books that Julie writes.
Title: .NET Enterprise Design with Visual Basic .NET and SQL Server 2000
Publisher: Sams
Authors: Jimmy Nilsson, Jimmy Nilsson
Rating: 2/5
Some good material in this book that are related to N-tier design, but not a .Net book at all. Less than %20 of the book had anything to do with .Net. It looks like the book was written 2 years ago and then .Net was added to the title to better market the book. I had to return mine.

