IT programming books related reviews
Title: Professional SQL Server 7.0 Programming
Publisher: Wrox Press
Authors: Rob Vieira
Rating: 5/5
This is a fantastic book. Robert Vieria is a hero. The book has helped me in my work, helped me pass my MCP and very often also made me laugh out loud..... A programming book with a sense of humor.....
Title: The Essence of SQL : A Guide to Learning Most of SQL in the Least Amount of Time
Publisher: Coriolis Group Books
Authors: David Rozenshtein
Rating: 4/5
The book is good. It teaches essential and good SQL skill, and provides a good understanding.
Title: Php Fast & Easy Web Development (Fast & Easy Web Development)
Publisher: Premier Press
Authors: Julie C. Meloni
Rating: 5/5
The book is very well written,and the included examples are great.I really look forward for a second addition with some more advanced technics.
Title: SQL Server Query Performance Tuning Distilled, Second Edition
Publisher: Apress
Authors: Sajal Dam
Rating: 1/5
I'm the author of the book "SQL Server Query Performance Tuning Distilled." To address the concerns of the readers of my book, I have started working with Apress. Apress understands the popularity of the book and has rendered the code samples for download at www.curlingstone.com. Apress is putting sincere effort in promoting the book. Meanwhile, if you find the content of the book highly useful for your database team, then I can consider sharing the knowledge with your team; if time permits, I may be able to deliver a good part of the content in a two-day presentation. If you feel that such an effort on my part will be useful for you and your team, then please feel free to write to my emailid sajaldam1@hotmail.com.
Title: Core PHP Programming: Using PHP to Build Dynamic Web Sites (2nd Edition)
Publisher: Pearson Education
Authors: Leon Atkinson
Rating: 3/5
There isn't much added here when compared to the online PHP manual. However, for the beginner, the examples help. I've found it useful for quick reference on airplanes and such when the online manual isn't available. NOTE: This book refers to PHP3 doesn't have much info on PHP4. In a nutshell, the bound online manual minus the user comments.
Title: Professional SQL Server 2000 Database Design
Publisher: Wrox Press
Authors: Louis Davidson, Wrox Author Team
Rating: 4/5
After some background on databases, we get started on requirements gathering - talk to customers and gather as much information as possible. Analyse this to identify entities/attributes/domains/relationship s. Sub-types receive good discussion. A brief overview of relational concepts is given (enough to whet your appetite - but no more). The IDEF1X notation is used throughout - personally I prefer the "crow's foot" notation. Normal forms get reasonable coverage up to 4NF. 5NF and DKNF are mentioned only briefly. The second half of the book considers implementation of a data model in SQLServer. In addition to creating tables and relationships, also discussed are UDFs, constraints, triggers, stored-procs, views, and transactions. Various other topics such as reporting, archiving, project planning, hardware, and physical architectures also get an overview. There are certain things in the book I don't like. Davidson insists on calling primary keys "pointers". No - they are most certainly not! He also recommends every table in a database has an identity column as it's primary key - even when a suitable primary key does exist. The "real" primary key is then implemented as an alternate key. To quote the book - "In logical modeling, we chose to use a 4 byte integer pointer for entity primary keys", "Every table will have a single meaningless primary key". Controversial to say the least! A rather wacky naming convention is also proposed, leading to such wonderful constraint names as chkAlbum$catalogNumber$function$artist$c atalogNumberValidate. Each to his own, I guess. Oh yes, and let's not to forget the obligatory mistake of talking about "null values" - AAGGHH!If you are after a book purely about data modelling then you may want to consider a different book, such as "Data Modeling Essentials" by Simsion. However if you want a book that considers data modelling in the context of SQLServer, then this may be the book for you - just take some suggestions with a large pinch of salt.
Title: The Guru's Guide to Transact-SQL
Publisher: Addison-Wesley Professional
Authors: Ken Henderson
Rating: 5/5
The book is very deserving of all the hype. It's the best book on SQL Server I've found. There's nothing in the other t-sql books that it doesn't have and lots of stuff it has that they don't. My favorite chapter is the Admin Stored Procs chapter. We're using a couple of these as I write this. It's rare to find a book that no only contains excellent teaching material, but also includes code that you can put to use immediately. That alone is worth the price of admission.
Title: Optimizing Transact-SQL : Advanced Programming Techniques
Publisher: SQL Forum Press
Authors: David Rozenshtein, Anatoly Abramovich, Eugene Birger
Rating: 1/5
You don't have to read the whole book, just first three chapters of this book will more than pay for itself. It seems complicated in the beginning with new notations, and their notations hide the simplicity and elegance of characteristic functions. However, once you get the concept of characteristic functions, it can help you enormously. I can't say enough about how good this is, it is such a simple and elegant idea for set-based db-engine, wonder why nobody else had thought of it sooner. I find myself deriving different characteristic functions for all kinds of tasks, and that in it of itself is fun. A must read for anybody using set-based db-engine such as Sybase and MS-SQL server ( despite their claims to the contrary for their latest versions ). Not much help in using this concept in ORACLE, since ORACLE seems to create implicit cursors anyway. I have improved speed in stored procedures by more than ten-fold by using the characteristic functions. Hooorrray!!!!
Title: MCDBA SQL Server 7 Administration Study Guide (Book/CD-ROM Set)
Publisher: Mcgraw-Hill Osborne Media
Authors: Syngress
Rating: 1/5
This is really an aweful and very disappointing book.It is even does not meet the basic ETHNIC standard. I really mean that why there are so many mistakes, wrong concept, wrong explaination.The author is allowed to express the knowledge in his own way that may leads poor-writing, but you can not write in a WRONG way.This book will destroy the reputation of the publishers in this series.The worst book I even seen for SQL Books.
Title: Professional PHP4 Programming
Publisher: Wrox Press
Authors: Deepak Thomas, Wankyu Choi, John Coggeshall, Ken Egervari, Martin Geisler, Zak Greant, Andrew Hill, Chris Hubbard, James Moore, Devon O'Dell, Jon Parise, Harish Rawat, Tarique Sani, Christopher Scollo, Chris Ullman, et al
Rating: 5/5
If you want to learn PHP4 then this is the book to buy.Its very well written and has great content.Credit also goes to the publisher and the editors for stitching up the content from 15-20 disparate sources. I suggest combining this book with the on-line documentation at php.net for maximum efficiency.The case studies deserve a special mention. Keep these books coming WROX.

