IT programming books related reviews
Title: Apache Server 2.0: A Beginner's Guide
Publisher: Osborne/McGraw-Hill
Authors: Katherine Wrightson, Kate Wrightson
Rating: 5/5
It's a rare technical writer who can be conversational and engaging in her style without compromising either the quality or quanity of the technical information within the work. Wrightson has managed this balancing act, with a guide that is friendly, well organized and above all useful for a web administrator. The book's attention to Mac OS X is also welcome -- far too many Mac users have upgraded to Mac OS X and leapt into Apache but treated it like they'd treat Microsoft Personal Web Sharing. Wrightson's approach makes the power and versitility -- and challenge -- of Apache apparent without making it arcane. Brava!
Title: Microsoft SQL Server 7.0 Database Implementation Training Kit (Training Kit)
Publisher: Microsoft Press Rating: 4/5
This is a pretty good test preparation book. It is the only volume I read cover to cover to prepare for the System Administration for Microsoft SQL Server 7.0 exam (70-028). I had spot read several other volumes to prepare a maintenance guide for SQL Server 7.0 installations so had become familiar with admin topics on the job. I did find after passing the Admin test that my margin of safety would have been greater if I had read the companion volume on Implementing a Database Design on Microsoft SQL Server 7.0 (Exam 70-029) before I tested. It is clear that you really need to work through both the Administration and Design books to be prepared for either of Microsoft's SQL 7.0 Exams.
Title: Professional SQL Server 7.0 Programming
Publisher: Wrox Press
Authors: Rob Vieira
Rating: 3/5
This book is more of an intermediate level book. Good well written sections, with clear explanations. However I was expecting a book aimed more at programmers as opposed to a book which merely explains the funamentals of SQL Server 7. Most of the sections seem like re-worded help files. I conceed that these section are much better than help file, there are too many important areas (to me anyway)overlooked. Like for example Store Procedures and the OLAP section could be deduced by simply reading the help in the OLAP wizards. I guess this book is good if you need conceptual information about the SQL language and TSQL. Not for advanced users.
Title: SQL Tips & Techniques
Publisher: Muska & Lipman/Premier-Trade
Authors: Konrad King, Kris Jamsa
Rating: 5/5
I wasn't expecting two people from UPS to have carry this book into my office--the book is huge. I have been using MYSQL for a year and I am moving to MS SQL Server. The book's tips (over 600) have been invaluable. I used the code the book provides to convert many of applications to support transactions. Got to eliminate tons of code. Very well done! Recommend.
Title: The SQL Server 6.5 Performance Optimization and Tuning Handbook
Publisher: Butterworth-Heinemann
Authors: Ken England
Rating: 5/5
Had response problems with current database setup and SQL statements. The chapters on Indexing and Optimizing really work. Ex. A simple query on two tables took 2.5 minutes. After applying some of the suggestions, the query took a little over 2 seconds...
Title: PHP for the World Wide Web : Visual QuickStart Guide (2nd Edition) (Visual Quickstart Guides)
Publisher: Peachpit Press
Authors: Larry Ullman
Rating: 4/5
I don't know anything about programming. But this books helps to make those first steps. It's easy to follow. Don't expect that you become a wiz kid off it. But expect that once you learnt this book you have a understanding how it all works and you be able to move one to the next step. I certainly would recoumend it for absolute starters and not for those who already know to programe...
Title: SQL Weekend Crash Course (With CD-ROM)
Publisher: Hungry Minds
Authors: Allen G. Taylor
Rating: 1/5
I was fairly unimpressed with this book. I found it fairly easy to read the first night's lessons, but when it came time to try any of the examples on an actual machine, there were plenty of typos in examples. The examples should be the one part of a book where you NEVER find a typo. It's been about 9 months since I threw this in the corner, so I can't point to examples off hand, but I know once I spotted obvious errors I didn't bother to move further through the book. There's also no errata on the author's website, once you find it. I realize this book is no longer published, but there's no excuse for even wasting money on it. Try SQL Queries for Mere Mortals, it's far more useful to learn from, and works as an excellent reference to basic SQL commands.
Title: Administering SQL Server 7: Complete Administration Reference
Publisher:
Authors: Divya Chaturvedi, Paritosh Pathak
Rating: 1/5
how I purchase a book plis your answer in Espanis
Title: Inside Microsoft SQL Server 2000 (With CD-ROM)
Publisher: Microsoft Press
Authors: Kalen Delaney
Rating: 4/5
In the foreword mention is made that this book is the definitive companion to Microsoft Server 2000 and I think I agree with that statement. Understand that for some, very strong views are held about which database product is best and why. These views also extend into what a book on SQL Server should contain, should it be this book tells me exactly what I need to type in and thus is wonderful, or this book explains the concepts. Whatever your views on the ideal database there does however seem to be a movement towards Microsoft SQL 2000 and this book will help you understand why this is happening. If you are a sophisticated end-user and want to learn what is possible with SQL server then this book is recommended especially for searching for and retrieving data. If you are a client reading through this book might help you when talking to the programmers to get your message across. From a cost point of view it is quite an expensive book but compared to the cost of building a system and the value it can add the cost is reasonable. It also comes with the complete text as an e-book on CD so searching for a topic is facilitated. If you want to understand if you should upgrade your existing SQL servers to SQL 2000, whether SQL 2000 will meet the requirements for your next project, this book is of use. In parts it is technical but it is also readable.It describes how Microsoft SQL works and why it is the product it is to day. It covers general background that is simply not covered in other books. It covers it in a practical way that also reflects the theoretical point of view. I especially like the references to the ANSI SQL standards.There is a section that talks about planning for an SQL database that goes into practical reasons why one RAID system is better than another but also when the cheaper solution is likely to be acceptable. It also mentions the reasons why you need to backup and restore your database even if you are using RAID.Basically one puts data into a database and one allows queries of that data. Some data queries are simple, some are much more complex. End users "All I want is a list of names" know what they want but often have difficulties with syntax, NULL values and outer joins. There is discussion of the value of NULL and lots of examples of joins including outer joins. How to protect your users from outer joins yet still use the power of them. By the way if you are an end user who wants to query data Chapter 7 is all about querying data although you may need a programmer or DBA to help set up some of the more complex queries. Joins are much enhanced in this version by the way and may provide a business reason why you should upgrade.Chapter 10 talks about the full text searching available in SQL 2000, using Microsoft Search Service including a discussion on maintaining full-text indexes and weights for complex searches and the reasons why the results from one installation may differ from another. These searches can be quite specialised so the examples that come on the CD are useful to demonstrate some of the techniques. It should be noted that the full text searching does use a stop word or noise list and there is a short discussion of the word-breaking algorithm used.Chapter 11 talks about the use of batches, this is a technique promoted by Microsoft to minimise traffic on the network often a production bottleneck even on a LAN and very much so on a WAN or Internet connection. Real world performance gains of ten-fold to the client are not uncommon.Chapter 16 gives common sense advice about query tuning. If you are an end user this is quite a good introduction to database tuning and how good systems are built. Again parts are technical but the concepts are there including why you may wish to duplicate the database for data warehousing type and other decision support queries.In summary this book is not essential to use SQL 2000 but it will assist many in getting the most benefit from the product.
Title: SQL Server 2000 Stored Procedure & XML Programming, Second Edition
Publisher: McGraw-Hill Osborne Media
Authors: Dejan Sunderic
Rating: 5/5
I am actually a BizTalk Server Developer but need frequent access to SQL Server data, preferably in XML. This great book has helped me jump over to writing stored procedures with being an SQL guru. It addresses things in a well organized way and saved me the cost of the book on Day 1. I like Dejan and appreciate his efforts.

