IT programming books related reviews
Title: The Guru's Guide to SQL Server Stored Procedures, XML, and HTML (With CD-ROM)
Publisher: Addison-Wesley Professional
Authors: Ken Henderson
Rating: 5/5
Finally a book that gives you, in the same chapter, a way to do arrays in SQL, and an excellent example of how to use extended stored procedures, and system functions.When I search for a good book, I look at a lot of books on the shelves, and often notice that many books just duplicate information readily available at "Books on line" or MSDN. This one doesn't do that. It explores a lot of topics that, although they do not appear immediatly useful, sooner or later will save you a lot of time.And that's what I look for when I buy a book! This extra wealth of information that makes a difference when you have to program something of higher complexity that usual.
Title: The Guru's Guide to Transact-SQL
Publisher: Addison-Wesley Professional
Authors: Ken Henderson
Rating: 5/5
Book is obviously written by an expert developer just for developers. You learn tsql just like you would any other language. The author takes you inside it and teaches you everything you need to know to build high performance, scalable sql server applications. Once he does that he shows you all the secrets so you can move from being a good tsql developer to being a great developer.
Title: Oracle SQL*Loader: The Definitive Guide
Publisher: O'Reilly
Authors: Jonathan Gennick, Sanjay Mishra
Rating: 5/5
I have been dealing with databases for over three years now.
Right now I am doing Siebel Consulting in which Enterprise Integration Module(EIM) is responsible for data transfer from any source to Sieble database. I came across a requirement where I had to use Oracle SQL Loader, so I went looking for a good book.
This 250 page book tells you everything you need to know about SQL Loader in less time than any other. Lots of code and real time examples.
Worth having as ref book for all DBAs or even developers.
Five Stars for sure.
Title: Advanced Transact-SQL for SQL Server 2000
Publisher: Apress
Authors: Itzik Ben-Gan, Tom Moreau
Rating: 1/5
I'm still trying to figure out what is "advanced" about this book. The writing is poor -- very poor, in fact. It's loaded with run-on sentences, bad grammar, and copious typos (I counted one on every page for no less than 12 pages!)Many of the examples don't work, and the ones that do are too simple to be useful. The coverage of SQL Server 2000 is sporadic and incomplete. My problem is that I can't come up with any redeeming qualities for the book. I feel like I really wasted my money on this one.
Title: Php 4 Bible (Bible (Wiley))
Publisher: Hungry Minds
Authors: Tim Converse, Joyce Park
Rating: 4/5
I had a database/dynamic webpage assignment for a course I was taking, and instead of following, in lemming style, the rest of the class in using ASP, I decided to give PHP a shot. Prior to this point I had looked at PHP for no more than a few minutes. This book was an excellent resource... It both teaches and acts as a reference at the same time. I would suggest this to anyone who is considering picking up a PHP book.Take note however, things may be a bit tough to get started on if you haven't had any experience programming in C/C++ as PHP syntax is very similar. My C++ programming experience was rather meager prior to learning PHP, but just being familiar with some of the syntax was a great help.
Title: Sams Teach Yourself Microsoft SQL Server 7 in 10 Minutes (Sams Teach Yourself)
Publisher: Sams
Authors: William Robison, William Robinson
Rating: 4/5
This is a great introductory book to Microsoft SQL Server 7 (and even SQL Server 2000). The 10 minute tag is a little unrealistic and smells of marketing. However, if you need a quick resource on writing SQL queries then this an excellent book. I use it as more of a quick reference than a learning tool.CONTENTS OF THIS BOOK: What is SQL Server -- Understanding Databases -- Finding Information in the Database -- Adding and Changing Data -- Using Data in Microsoft Word -- Analyzing Numerical Data with Microsoft Excel -- Including SQL Server Data in Your Microsoft Access Database -- Simple Web Publishing -- Advanced Web Publishing -- An Interactive Web Application -- Improving Query Performance -- Analyzing Your Data with SQL -- More SQL: Defining Data -- Storing SQL in the Database -- Controlling How Changes Are Made -- Simplifying Common Queries -- Managing Databases the Easy Way -- Keeping Your Server Safe -- Monitoring Activity -- More Powerful Options for Moving Data
Title: Beginning PHP 5 and MySQL: From Novice to Professional
Publisher: Apress
Authors: W. J. Gilmore
Rating: 1/5
Maybe beginners with PHP 5.0, but you definately need some prior PHP scripting experience for this book to be useful.
Gilmore does not have any real life examples for you to try and build your knowledge on in this book. Only a couple of lines are for each different sub-topic. None of them are connected to previous lessons. Some of the "examples" is not complete code. Just how that particular function or command would look on a single line. Very poor for a beginners guide.
I would have liked to see the book walk me through building some applications then tie them all together at the end before moving on to MySQL.
I recommed PHP & MySQL Programming (3rd Edition) PRIOR to reading this book.
After you can write your own simple PHP applications should you then move on to this book.
Title: Beginning Php 4 (Programmer to Programmer)
Publisher: Peer Information
Authors: Chris Lea, Allan Kent, Ganesh Prasad, Chris Ullman
Rating: 5/5
The thing which impressed me the most about this book is how clearly and methodically the subjects are presented. The authors are natural teachers, judging by their product. Each code example is presented in full, then key sections of code are shown again and explained in detail to make the necessary points. I found the level of detail just right, assuming that you have some ability but clearly explaining the PHP way of doing things. This is not just an introduction, but a good first manual. The appendix lists the available PHP commands so you can explore further if you need to go in a particular direction.
Title: SQL Server® Developer's Guide
Publisher: Wiley
Authors: Joseph J. Bambara, Paul R. Allen
Rating: 4/5
The book contains a nice balance of guidelines and tips coupled w commonly used reference material. A nice to have close by when developing w MS SQL. Good for DBA and programmer/ developer.
Title: Microsoft SQL Server(TM) 2000 Administrator's Pocket Consultant (It-Administrator's Pocket Consultant)
Publisher: Microsoft Press
Authors: William R. Stanek
Rating: 5/5
I knew nothing about SQL Server 2000 before picking this up. It took me from knowing nothing to knowing a lot. The author has an easy writing style which made it easier for me to learn this subject. I looked at a lot of SQL Server 2000 books and at least from my perspective, this is the one to own. Great information makes it well worth the money. If you're anything like me, you may be considering this book as a study guide for 70-228. I recently took this exam and passed. This book is without doubt a text you can buy to prepare for the exam. Sure it doesn't cover everything in the exam, but it comes close.Great chapters on replication and DTS. Very few screen shots. Packs in a lot of material in 450 pages. Absolutely useful for admining. Here's my exam study sheet... Hope it helps you like it helped me.Exam objectives not covered:Installation
Upgrades
I IS virtual directories for XMLExam objectives covered:Create a linked server.
Configure SQL Mail and SQLAgentMail.
Configure network libraries. Configure database options for performance. Considerations include capacity, network connectivity, physical drive configurations, and storage locations.
Attach and detach databases.
Create and alter databases.
Add filegroups.
Configure filegroup usage.
Expand and shrink a database.
Set database options by using the ALTER DATABASE or CREATE DATABASE statements.
Size and place the transaction log.
Managing, Monitoring, and Troubleshooting SQL Server 2000 Databases
Optimize database performance. Considerations include indexing, locking, and recompiling.
Optimize data storage.
Optimize files and filegroups.
Manage database fragmentation.
Modify the database schema.
Perform disaster recovery operations.
Perform backups.
Recover the system state and restore data.
Configure, maintain, and troubleshoot log shipping.
Perform integrity checks.Troubleshoot transactions and locking
Extracting and Transforming Data with SQL Server 2000
Import and export data.
Develop and manage DTS packages.
Manage linked servers.
Manage OLE DB Providers.
Configure security mapping.
Convert data types.
Configure, maintain, and troubleshoot replication services.
Managing and Monitoring SQL Server 2000 Security
Configure mixed security modes or Windows Authentication.
Create and manage log ons.
Create and manage database users.
Create and manage security roles.
Add and remove users from roles.
Create roles to manage database security.
Enforce and manage security
Set permissions in a database.
Manage security auditing.
Managing, Monitoring, and Troubleshooting SQL Server 2000
Create, manage, and troubleshoot SQL Server Agent jobs.
Configure alerts and operators by using SQL Server Agent.
Optimize hardware resource usage.
Monitor hardware resource usage by using System Monitor.
Resolve system bottlenecks by using System Monitor.
Optimize and troubleshoot SQL Server system activity.
Monitor SQL Server system activity by using traces.
Monitor SQL Server system activity by using System Monitor.

