IT programming books related reviews
Product: Book Paperback
Title: Developing Time-Oriented Database Applications in SQL (Morgan Kaufmann Series in Data Management Systems)
Publisher: Morgan Kaufmann Publishers
Authors: Richard T. Snodgrass, Christian S. Jensen
Rating: 5/5
Title: Developing Time-Oriented Database Applications in SQL (Morgan Kaufmann Series in Data Management Systems)
Publisher: Morgan Kaufmann Publishers
Authors: Richard T. Snodgrass, Christian S. Jensen
Rating: 5/5
This is a book EVERY programmer that deals with databases should read. It explains the evils of NULL date/datetimes and how to properly optimize a database design for real-world queries.Follows several applications through the evolution of time-senstive queries, clearly distinguishing the concepts of "current time", "effective time" and "transaction time", which trip up developers over and over.
Product: Book Paperback
Title: The Essence of SQL : A Guide to Learning Most of SQL in the Least Amount of Time
Publisher: Coriolis Group Books
Authors: David Rozenshtein
Rating: 4/5
Title: The Essence of SQL : A Guide to Learning Most of SQL in the Least Amount of Time
Publisher: Coriolis Group Books
Authors: David Rozenshtein
Rating: 4/5
This is definetly a great start if you are just beginning to learn SQL. The book goes through many examples but doesn't have any examples to be worked out by the readers and then checked with the book, so when you buy this book, start looking for another book. This book is not a for dummies book, so be prepared. One thing that I didn't like about the authors approach is that he used very mathematical words (such as boolean, cross-product, etc.) This was fine for me but I think some readers (especially those not familiar with those high order mathematical terms) will get confused. He might have needed to add a couple of pages to the book so that he could explain these terms with just a few (extra) words, or ommited the words entirely. I probably would have given the book 4.5 stars but wasn't available. Yes the book is very small and I read it in 3 days after long days at work but it was worth the money since it took from zero to comfortable with SQL statments.
Product: Book Paperback
Title: SQL In A Nutshell, 2nd Edition
Publisher: O'Reilly
Authors: Kevin Kline, Daniel Kline, Brand Hunt
Rating: 1/5
Title: SQL In A Nutshell, 2nd Edition
Publisher: O'Reilly
Authors: Kevin Kline, Daniel Kline, Brand Hunt
Rating: 1/5
SQL in a Nutshell is not for those who don't know SQL. What it is, is a very good reference resource when you can't remember how the syntax goes. Breaking each command down to highlight the syntax differences, and in fact the workability of each command, between the basic relational databases. One interesting feature is to let the reader see how far some (Microsoft SQL Server) have deviated from the SQL standards. You're not going to (most likely) read it from cover to cover, rather you will jump to the section(s) that you want and try to absorb the information. Rarely does time pass when I do not find myself referring to this book, just to check to little details. Highly recommended.
Product: Book Paperback
Title: Optimizing Transact-SQL : Advanced Programming Techniques
Publisher: SQL Forum Press
Authors: David Rozenshtein, Anatoly Abramovich, Eugene Birger
Rating: 1/5
Title: Optimizing Transact-SQL : Advanced Programming Techniques
Publisher: SQL Forum Press
Authors: David Rozenshtein, Anatoly Abramovich, Eugene Birger
Rating: 1/5
This book shows how to build better SQL. I find the info useful in building higher performance SQL statements.
Product: Book Hardcover
Title: MCDBA SQL Server 7 Administration Study Guide (Book/CD-ROM Set)
Publisher: Mcgraw-Hill Osborne Media
Authors: Syngress
Rating: 1/5
Title: MCDBA SQL Server 7 Administration Study Guide (Book/CD-ROM Set)
Publisher: Mcgraw-Hill Osborne Media
Authors: Syngress
Rating: 1/5
I found this book to be shallow and ineffective in being a true aid in exam preparation. I used this book as my main resource (big mistake) and found that this book only grazed the key topics. Please take this to heart, If you plan on passing the SQL Server Exam, then don't waste you time or money on this book.
Product: Book Paperback
Title: Setting Up LAMP: Getting Linux, Apache, MySQL, and PHP Working Together
Publisher: Sybex
Authors: Eric Rosebrock, Eric Filson, Eric Filson
Rating: 5/5
Title: Setting Up LAMP: Getting Linux, Apache, MySQL, and PHP Working Together
Publisher: Sybex
Authors: Eric Rosebrock, Eric Filson, Eric Filson
Rating: 5/5
This book covers all aspects of setting up LAMP, from the basics of a linux install right up to correctly managing MYSQL. While aimed at the first time/new linux user even the old hands will learn something.
Its well laid out in easy to read manner, which is something that linux books are often not.
It also takes the time to explain in simple every day language what something does before you do it.
The book also teaches you good linux administration right from page one.
And to cap it all off they provide a great checklist at the back for setting multiple lamp installs quickly without leaving things out. So after your first lamp system you will be able to fly through your next install!
Hats off to Eric Rosebrock and Eric Filson for a great all around book
Product: Book Paperback
Title: Microsoft SQL Server(TM) 7.0 Administrator's Pocket Consultant
Publisher: Microsoft Press
Authors: William R. Stanek
Rating: 5/5
Title: Microsoft SQL Server(TM) 7.0 Administrator's Pocket Consultant
Publisher: Microsoft Press
Authors: William R. Stanek
Rating: 5/5
First, this is not a "teach yourself book" it is a reference, geared toward field engineers. With that said, this is a fabulous carry everywhere reference (small; roughly 8"x5"x1" in size) that has just about everything you need to know (from a DBA perspective, that is) for maintaining/installing/etc. SQL Server 7.0. The book is broken into four sections: I. Administration Fundamentals - Configuring and TuningII. Administration - Managing Enterprise, Core DBA, SecurityIII.Data Administration - Backup/Recovery, Import/Export, Distributed Data/Remote Servers, ReplicationIV. Performance, Optimization, and Maintenance - Monitoring/Profiling, Creating Tables/Indexes, DB Automation/MaintenanceHaving worked with SQL Server for several years now, I have always dreamed of having a book that summarized (with examples) all aspects of installation and maintenance (and wasn't a 4" thick luggable). Stanek has done it. The contents are well laid out with a very thorough index. Examples are well laid out (step-by-step) to get you through what-ever issue you are working with. The book contains stored procedure calls, but is not a Transact-SQL manual (actually it would be nice if the author would come out with a T-SQL Admin Pocket Guide also!).I consider this a must-have for every SQL Server DBA's library. It will not gather dust, but instead become VERY dog-eared.
Product: Book Paperback
Title: MCDBA SQL Server 7 Test Yourself Practice Exams (Exams 70-028 & 70-029)
Publisher: Osborne Publishing Rating: 3/5
Title: MCDBA SQL Server 7 Test Yourself Practice Exams (Exams 70-028 & 70-029)
Publisher: Osborne Publishing Rating: 3/5
I happen to like books with lots of questions to test my readiness for a certain exam. For the most part, this book accomplishes that (hence 3 stars). It does, however, have many subtle errors so you need to check each answer you get wrong with an authoritative resource, like SQL Server Books Online. For example, is says to upgrade SQL 6.5 to SQL 7.0 the SQL 6.5 system needs SP4 - which is incorrect, it needs SP3. Lots of little mistakes like that. By all means, use this book as a resource, but NEVER as your ONLY one. You'd also be wise to double check every wrong answer you get (which of course consumes that much more of your valuable time).
Product: Book Paperback
Title: Professional Apache (Professional)
Publisher: Wrox Press
Authors: Peter Wainwright
Rating: 5/5
Title: Professional Apache (Professional)
Publisher: Wrox Press
Authors: Peter Wainwright
Rating: 5/5
Professional Apache is the book for anybody who needs to get the most out of the Apache Web Server. If you're thinking of setting up Apache for the first time, or of moving an existing web site to a dedicated machine, then this book will help you...
Product: Book Paperback
Title: Microsoft SQL Server 7 DBA Survival Guide
Publisher: Sams
Authors: Orryn Sledge
Rating: 2/5
Title: Microsoft SQL Server 7 DBA Survival Guide
Publisher: Sams
Authors: Orryn Sledge
Rating: 2/5
I realy don't know what to say , but if you want to stay alive while you mamaging the sql ,and this is the only book you got, you better send help to somebody who really know SQL. This is not the book you thought.
