IT programming books related reviews
Title: Professional SQL Server 2000 DTS (Data Transformation Services)
Publisher: Wrox
Authors: Mark Chaffin, Brian Knight, Todd Robinson
Rating: 5/5
I have been working on a project involving DTS and needed a firm grash of it. the book far from scaring me with all the technicalities and programming depth at the begining gradually introduced me to DTS and step by step with example showed me how to harness the power of DTS including the programming side it is the perfect book to introduce you to the subject and for self learner like me it succeed at opening your mind and pointing you to the right direction I 'll recommend it
Title: SQL Server 2000 Web Application Developer's Guide
Publisher: Osborne/McGraw-Hill
Authors: Craig Utley
Rating: 4/5
I am only through the first four chapters but I felt it was important to get this information out to people who have bought the book or are about to buy the book.This is a very good book but some of the sample apps are missing key points in preparing to use those apps. First off, I am using XP Pro, SQL Server 2000 and Visual Studio 6 on a Pentium IV 1.8GHz machine with 512MB of SDRAM (Dell Dimension 8200). Now for the problems:(1) On page 78 Craig explains the two ways one can connect to SQL Server quite well but a little more help could've been given about what you have to do if you are using NT authentication. He says, "you must go into SQL Server and give permissions for that specific database to a user on your system called IUSR_<servername>...". For us novices out there a few words on how to do that would've been helpful. I fumbled around with it but figured it out (open SQL Server Enterprise Manager, navigate to your SQL Server, expand it, expand the SECURITY folder, right click on LOGINS and select NEW LOGIN (take it from there)).(2) And if you do use NT authentication you need to modify the provider string that he shows on page 79. You will not need to use a User ID or password (just like he says) but you will need this at the front of the string, "Trusted_Connection=yes;" My connection string looks like this:
"Trusted_Connection=yes;Provide r=SQLOLEDB;User ID=;Initial Catalog=Northwind;Data Source=Jupiter;PASSWORD=;"'Jupiter' is my computer's (server's) name and 'Northwind' of course is the name of the dB in SQL Server.(3) I had HUGE problems with the app he calls 'RealApp' beginning on page 105. Here's what I did to get it to work:
(a) If you have Norton Anti Virus (NAV) turn off SCRIPT BLOCKING. You do this by going to the OPTIONS menu in NAV.
(b) The folder that you write the text file to on your server must have READ/WRITE permissions for the IUSR_<servername> user name (if you're using NT authentication). That means you have to go to the SECURITY tab of the folder's properties; however, if you are using XP Pro you won't see a SECURITY tab anywhere! To expose the SECURITY tab, go to CONTROL PANEL, select APPEARANCE AND THEMES, and then click FOLDER OPTIONS, then on the VIEW tab, under ADVANCED SETTINGS, clear the "Use simple file sharing [Recommended]" checkbox. Now you will be able to see the SECURITY tab on all of your folders.
(c) Tell IIS that this app is a Web app (if you don't then Global.asa will never get looked at). Navigate to the RealApp web page icon in IIS. Right click it. Choose PROPERTIES. In the DIRECTORY tab look for APPLICATION NAME (it will be grayed-out) then click the CREATE button next to it. While you are here go down to the APPLICATION PROTECTION line and set it to "LOW (IIS Process)"....
Title: Pete Cassidy's Cookbook for Oracle SQL*Plus
Publisher: Chef Pierre
Authors: Pete W. Cassidy, Carole B. Cassidy
Rating: 5/5
This is a excellent book to learn SQL*Plus or to refine your knowledge. I teach several Oracle classes and I recommend this book to students to clarify important concepts. I would highly recommend this book to those that want to expand their knowledge of SQL*Plus.
Title: Oracle PL/SQL 101
Publisher: McGraw-Hill Osborne Media
Authors: Christopher Allen
Rating: 3/5
Great introduction to Oracle SQL, but very little if any PL/SQL here.
Title: SQL Server Security Distilled, Second Edition
Publisher: Apress
Authors: Morris Lewis
Rating: 5/5
SQL Server Administrators need to beware because this book gives up the goods to any who read it. Morris Lewis does a great job of not only explaining how SQL Server implements Security and the weaknesses from mis-configuring the server, but also how to close those holes. With in-depth coverage of the topic and hands on examples you learn how to secure your database and server from likely hack attacks.The book is well written, explains the subject matter well, and is very high on my list of suggested reading.
Title: Advanced Oracle PL/SQL Programming with Packages (Nutshell Handbook)
Publisher: O'Reilly
Authors: Steven Feuerstein
Rating: 3/5
The book is structured around a set of packages called PL/Vision. Eighty percent of the book is devoted to describing how to use PL/Vision and what it can do. PL/Vision is a useful set of tools; the P package in particular will be useful to any developer, though most will have already written something similar (though maybe not so fancy) for themselves. P is a packaged version of the dbms_output routines, and allows formatted output, debug output and other similar facilities.However, the book is not really a reference for Oracle packages. Most of what you need as a reference can be found in Feuerstein's "Oracle PL/SQL Programming", which I recommend. This book is more to give you an idea of what you can do with packages. I found it interesting, but I rarely refer to it--the other Feuerstein book is so comprehensive it covers almost all my questions.
Title: Professional Apache Tomcat
Publisher: Wrox
Authors: Chanoch Wiggers, Ben Galbraith, Vivek Chopra, Sing Li, Debashish Bhattacharjee, Amit Bakore, Romin Irani, Sandip Bhattacharya, Chad Fowler
Rating: 5/5
I was quite surprised by this book when I read it-- the topical coverage goes from fundamentals of a web server's role in J2EE development, to installing one, to adding various connector tools , and finally to testing web apps for load. That's going from start to finish for a service administrator, all in a tidy 500+ pages.Many guides try to cover all the details of a tool and get lost in explaining too much. This guide remains practical, and might even frustrate someone who does want every detail. For those who want to get something done and need reliable information, this book is an ideal desktop reference.If you want to learn some J2EE stuff by example and using a tool, this book will prepare you well for further reading on J2EE design. I also like the coverage on Ant and Log4J -- more books should explain how such tools integrate into a larger environment.This book will help anyone who feels confident with a web server to build and extend Apache/Tomcat on their own. I recommend it to anyone who supports the product or wants an aid to experimenting with it.
Title: Professional Oracle 8i Application Programming with Java, PL/SQL and XML
Publisher: Wrox Press
Authors: Michael Awai, Matthew Bortniker, John Carnell, Kelly Cox, Daniel O'Connor, Mario Zucca, Sean Dillon, Thomas Kyte, Ann Horton, Frank Hubeny, Glenn E. Mitchell II, Kevin Mukhar, Gary Nicol, Guy Ruth Hammond
Rating: 5/5
Some other reviewers have stated that this book is uneven in quality. I agree with that assessment but argue that is unavoidable. I cannot think of any one person who possesses the knowledge to write intelligently about all of this material in the depth this book has.In a few areas it is dated (obviously 9i is out NOW, but wasn't when this book was published), but it is still overall extremely valuable. I have had my copy for about a year now and have read it almost completely once (you can't read a 1200 page tech book cover to cover) and have referred to it in a pinch more times than I can remember.In short, a must have for any serious Oracle developer.
Title: OCP Introduction to Oracle9i: SQL Exam Guide
Publisher: McGraw-Hill Osborne Media
Authors: Jason Couchman
Rating: 1/5
This book includes just litte information, so simple that your even could't really understand what it expressed. And have so many terribly wrong mistakes. One page said this and in just a litte after page said totally opposite, made you confuse what is the right one.
Title: Mastering Oracle SQL
Publisher: O'Reilly
Authors: Sanjay Mishra, Alan Beaulieu
Rating: 4/5
I found this book to be very good as far as explaining Oracle SQL from the basics (DML, etc) to intermediate topics (unions, joins, etc.). I also felt that there are good examples and clear explanations of topics. However, I do not believe that mastery can be accomplished through this book.

