IT programming books related reviews
Title: PC Annoyances, Second Edition
Publisher: O'Reilly
Authors: Steve Bass
Rating: 5/5
This second edition of PC Annoyances has been updated and expanded to include the new developments in PC and Internet technology, including SP-2 for Windows XP, and 150 new tips and workarounds for common PC annoyances. A question and answer format is used throughout to describe each annoyance, with a corresponding solution. PC users at all levels of ability will find many excellent suggestions in the book, and learn to work faster, smarter, and free of frustration. With this book, you can get things to work your way. Author Steve Bass has set up a web site where the mostly-free utilities mentioned in the book can be found. Ed L.
Title: Advanced Transact-SQL for SQL Server 2000
Publisher: Apress
Authors: Itzik Ben-Gan, Tom Moreau
Rating: 2/5
I bought this book one month ago. Finally, I have some time to sit down and read this book. After read a couple of charpters, I realized that I made a big mistake even spend time on this one. This book comes with a sounding title with unreadable material... If peopel do want to explore advanced T-SQL programming, take the "The Guru Guide to Transact-SQL" by Ken Handerson. It is one of the best SQL books in my collection. It is a bit out dated but it will bring you right into the point.Jim J. Zhong
Title: XML and SQL Server 2000
Publisher: New Riders Publishing
Authors: John Griffin
Rating: 2/5
I haven't finished reading this yet but I just had to put it down real quick so I could tell eveyone how useful this book is. I'll warn you up front, you have to take the time to read this - it is packed with information. The XSLT chapter goes into great detail and takes the confusion surrounding this topic and blows it away. The rest are very informative, too. This book is far better than the Henderson/Soukup Guru's guide. Buy this one and you won't need anything else.
Title: Professional Data Warehousing with SQL Server 7.0 and OLAP Services
Publisher: Peer Information Inc.
Authors: Sakhr Youness
Rating: 5/5
My company had a project that requires using MS SQL Server 7.0 OLAP Services. We did not have anyone on staff who is familiar with the topic, so I bought the Wrox book and started reading it. I found the book to be great and extremely helpful. It addresses all kinds of issues, the simple ones as well as the more difficult ones. It is easy to read and comprehensive. Although it focuses one OLAP and how OLAP is used in SQL Server 7.0, it also gives great information about building a data warehouse, administering it, and managing it. What is also so great about this book, is that when we needed some help, I sent an email to the author, who was very responsive. Mr. Youness responded to my email questions with enough detail to get us going when we got stuck with one of the issues. I do recommend this book to anyone who wants to use MS OLAP and MS data warehousing.
Title: Microsoft SQL Server 7.0 Database Implementation Training Kit (Training Kit)
Publisher: Microsoft Press Rating: 5/5
I used this book after purchasing the Online version of this kit (ISBN 0735606781). This kit does a better job of going in depth on a lot of the items that will be tested than the Online Kit(which I have also reviewed). The practice exercises are good, and the included evaluation copy of SQL Server allows you to experiment and become more familiar with the product, along with giving you the books online for additional reference. The organization of topics is well done, something that I have had issues with with MSPress books in the past.
Title: SQL Server Security Distilled, Second Edition
Publisher: Apress
Authors: Morris Lewis
Rating: 4/5
A good definition for exactly what this book does. It breaks down every segment of the SQL Server security infrastructure in intricate detail so security professionals and DBAs alike can make the right decisions. The books is a good fit for anyone who must support multiple SQL Server versions (including SQL 6.5/7/2000 and CE) in almost every conceivable scenario including replicated deployments. Noticably absent were any discussions of the security implications of MSDE or a detailed guide to setting up SSL on SQL Server. That said, the information in this book is absolutely vital to anyone who needs to get up to date on SQL Server security and doesn't have time to sort through Books Online, White Papers, and assorted websites on the subject.
Title: Visual Developer SQL Database Programming with Java: Creating Fast, Efficient Database Applications for the Web
Publisher: Coriolis Group Books
Authors: Bill McCarty, Bill McCarthy
Rating: 4/5
The book I have been looking for. Recommended for database programmer who wants to make available their data in the Web or Intranet using Java and JDBC. Great sample programs that really works. I learned a lot from this book about database programming with Java and JDBC. I liked the part where the author detailed nicely the steps how a database connection is established and how the different pieces of interface interacts to store and retrieve data from the database. Great book. More power to you Bill.
Title: SQL Server 2000: A Beginner's Guide (Book/CD-ROM)
Publisher: McGraw-Hill Osborne Media
Authors: Dusan Petkovic
Rating: 3/5
This book provides a solid, useful introduction to SQL Server 2000. The coverage is comprehensive and informative. The writing is mostly clear and accessible though I was unable to understand a few points that the author covered. Very few books attempt to cover the Transact-SQL language, database concepts, and server administration in one volume and this one does it fairly successfully.You have to be pretty determined to make it through this book. The author covers a lot of ground and I did not find it to be particularly engaging. I coaxed myself through by reading chapters from the section on system administration in parallel with the earlier chapters on SQL language, syntax, and queries that were pretty dry. I didn't want to skip anything because I did not want to miss any of the new features of SQL 2000.It is clear from this book that the big change between SQL Server versions was between 6.5 and 7.0. The continuity between 7.0 and 2000 stood out in this reading. There are significant changes - from data types to syntax to utilities and more, but for those who are familiar with 7.0 the latest version will feel pretty comfortable.I rated the 7.0 version of this book 4 stars and this one 3 stars. Actually the book is about as good as the previous one but I have read a lot of SQL Server books since then and my expectations have risen. This isn't a bad book but it is among the dullest treatments I have encountered.Is this a good book for beginners? Yes. Many readers want a one-volume source and this one meets that need. If you want to learn SQL Server this book offers the basic education you need. A few sections will make no sense to a beginner. They made little sense to me and I'm not a beginner anymore. But if you keep at it by the end you will have a good general understanding and ability with SQL Server 2000.I picked up this book to prepare for Microsoft's beta exam on SQL Server 2000. Pre-test I think it does a pretty good job of covering material. While I found it boring I appreciated the review of Transact-SQL. I spend more time troubleshooting problems than writing scripts so I had gotten a little rusty. A reader who is up to speed on SQL Server basics might skip over the first two sections of the book to concentrate on the sections that deal with system administration, analysis services, full-text search, and XML support where more new stuff is introduced. What is new in the first two sections is very minor.
Title: Sams Teach Yourself Transact-SQL in 21 Days (2nd Edition)
Publisher: Sams
Authors: Lowell Mauer
Rating: 1/5
This book has several fundamental flaws. First, it doesn't stay on point. There are all sorts of tangents and asides that totally waste your time. Second, it's written really poorly. The prose is boring and plain. Third, it's inaccurate in many places and leaves out newer commands and important details. I returned this one for a refund.
Title: Sams Teach Yourself Microsoft SQL Server 7 in 21 Days
Publisher: Sams
Authors: Richard Waymire, Rick Sawtell
Rating: 3/5
This book is really not too bad to help someone learn about SQL Server 7. The only criticism I have is that the chapters seem to be out of order. The first week of this 3 week book is made up of security concepts like logins and permissions. I would hope that someone learning SQL Server would first want to learn about data types and data retrieval (which comes in the 2nd week). Views, stored procedures, and triggers are in week 3.
The logical order to me is: week one - data types and data retrieval, week two - views, stored procedures, and triggers and week three - login security and permissions.
I think the book would be much better if the security information was saved for the last week.

