IT programming books related reviews
Title: Professional SQL Server 7.0 Programming
Publisher: Wrox Press
Authors: Rob Vieira
Rating: 5/5
If this book was titled a beginning book, it would defniitely get 5 stars. It is extremely clear, well written, and covers the essential topics that will confront a SQL Server 7.0 programmer. However, some details are missed. Examples: An SP programmed to raise errors with severity levels of 20+ will run "successfully" within DTS. Apparently DTS interprets any non-syntax error producing run as successful. How does one check for errors, and run different SPs within DTS based on errors raised?When writing an SP raising errors with severity levels of 20+, the with log option is required. However, this option requires heightened security levels than db_owner. What role should be assigned to the user of SP? Under what conditions?These are relevant questions when developing real world apps, and are not clearly addressed.Again, this a great book, and readily recommend it. However, its title (and size) imply a level of detail that is sometimes missing.
Title: PHP Essentials
Publisher: Muska & Lipman/Premier-Trade
Authors: Julie C. Meloni
Rating: 5/5
This was the book I've been looking for. Not pretentious. Didn't assume I knew anything. From reading the description and looking at the table of contents and the web site for the book, it looked like the perfect "getting started" book for me. And I did, and it was very fast. That's why I like this book and am giving it 5 stars: it met my expectations and did the job for me. There is a lot of stuff that isn't covered, but it wasn't "essential" (pun intended!!) for what I need to do now or for a long time. For a quick jumpstart into a new language, with a quick read and easy to understand examples, get this book! If you're a "hard core" programmer with years of it under your belt, you won't need this book. I did a lot of research: this author has a lot of information here and at the web site, and has already answered several of my "help!" e-mails - that's pretty great support, above and beyond the call of duty!
Title: Transact-SQL Programming
Publisher: O'Reilly
Authors: Lee Gould, Andrew Zanevsky, Kevin Kline
Rating: 2/5
For some reason, books on TSQl are uniformly bad, and are frequently rehashes of how to use the GUI. This isn't. Apart from some howlers, it is not a bad book, and if you're migrating from Sybase to MSSQL is a must. However, the Acknowledgement section makes the book worth buying all by itself. It is the most cringing piece of arslicking I have seen in my life.
Title: Beginning E-Commerce with Visual Basic, ASP, SQL Server 7.0 and MTS
Publisher: Peer Information
Authors: Matthew Reynolds
Rating: 5/5
I own over 20 Wrox books. They are by far the best. This is the best of the best. This is quite simply the best and most useful programming book I've ever seen. This is quite likely the best book Wrox has ever published.
Title: Unlocking OLAP With SQL Server 7 and Excel 2000
Publisher: Hungry Minds
Authors: Wayne S. Freeze, Wayne Freeze
Rating: 4/5
Hi! I am Korean. ................ I can't write in English easily. I read this book in 1 month. I started D/W project and OLAP project in my company. This book have been my best helper in OLAP part. It is very easy. If you are beginner for OLAP like me, i think you will retain help too.
Title: Inside Microsoft SQL Server 6.5 (Microsoft Programming Series)
Publisher: Microsoft Pr
Authors: Ron Soukup
Rating: 5/5
If you're starting to develop SQL Server databases, this book is a must buy! Covers the basics such as triggers, procedures, good table design, and much more with some of the best examples that I have seen anywhere!
Title: Troubleshooting SQL
Publisher: McGraw-Hill Companies
Authors: Forrest, Ph.D. Houlette
Rating: 1/5
This book is not as advertised.The blurb on Amazon says:
"You'll get programming tips, best practices, plus coverage of Oracle SQL and PL/SQL and T-SQL for SQL Server."This book is a collection of introductory material on SQL and RDBMS's, with about 99% of the information and examples exclusively based on SQL Server. With very few exceptions, even the few things this author has to say about Oracle in this book are completely wrong. The most outrageous point I found was a simplistic explanation of transactions in Oracle as consisting of commit and rollback in SQL*Plus. In the more detailed section on SQL Server that follows it we find this little gem of a quote: "Unlike in SQL*Plus, the ROLLBACK command iin Transact-SQL can also be used to revert to the last savepoint." Clearly the author does not have a clue how transactions and savepoints work in Oracle, which gives the developer or DBA an extraordinary array of control mechanisms for transactions, both programmatic and interactive.If you want an introduction to SQL Server by someone with a few tired tips on Microsoft datatypes and a lot of oft-repeated generalities, this is the book for you. If you are looking for a serious book on troubleshooting Oracle SQL, get Harrison's Oracle SQL High-Performance Tuning and Tom Kyte's new book. If you're looking for how to tune SQL on Sybase/SQL Server, I'm not the one to ask, since I tune Oracle databases for a living.
Title: DB2 SQL Procedural Language for Linux, Unix and Windows
Publisher: Prentice Hall PTR
Authors: Paul Yip, Drew Bradstock, Hana Curtis, Michael Gao, Zamil Janmohamed, Clara Liu, Fraser McArthur
Rating: 5/5
This book is excellent. I'm an Oracle DBA learning DB2. It has been very difficult to find DB2 books of this quality.
Title: A Guide to the SQL Standard: A User's Guide to the Standard Relational Language SQL
Publisher: Addison-Wesley
Authors: C. J. Date, Hugh Darwen
Rating: 4/5
This is by far the best book I have read on this subject, I recommend it to anyone who want to get a good handle on SQL
Title: Learning SQL: A Step-by-Step Guide Using Access
Publisher: Addison Wesley
Authors: Sikha Bagui, Richard Earp
Rating: 2/5
I know the pickings are slim for finding a book to learn SQL using Access, but PLEASE can't someone who knows how to teach and cares about getting their information correct write one? First off, this book has many errors including some statements that work OPPOSITE to the statements. Ex: On page 105 the description for "Nested LEFT and RIGHT OUTER JOINs" reads "In Access, A LEFT JOIN or a RIGHT JOIN can be nested inside an INNER JOIN, but an INNER JOIN cannot be nested inside a LEFT JOIN or a RIGHT JOIN." NO. NO. NO. It works in the opposite way.The tables to be used in the book tutorials often bear no relationship at all to the fields or to the data and some of the naming produces run errors-- creating a frustrating experience for a student. This was obviously no labor of love for the authors, but a slapdash method to pump out a book. It is a crime that there was no quality assurance on this book. That alone would have caught the worst of it. For shame to all associated with its publication.I generously gave it two stars just because it is probably better than nothing, but not much better. Again, here's a call to all of you SQL trainers out there: your market is wide open.

