IT programming books related reviews


Product: Book Paperback
Title: Professional SQL Server 2000 Database Design
Publisher: Wrox Press
Authors: Louis Davidson, Wrox Author Team
Rating: 5/5
Not the be all end all, but a good place to start


My background is as an ASP developer and new dedicated DBA / Data Architect. I've done pretty extensive data modeling and implementation for several small to medium sized ASP applications. I am a big fan of the Wrox P2P series. This is my 8th Wrox purchase.I was disappointed in this book, but I'm having trouble putting my finger on exactly why I was disappointed. I read every word, which is rare for a technical book, but I just don't feel like I learned in the areas that I really wanted to learn. My two main goals for this read were to learn how to better build business rules into my databases and to reinforce and validate data modeling techniques I have been taught from mentors.Extensive coverage is given in the first half of the book to the logical design (extensive to the point of obnoxious). Tips on how to break down your notes for entities and relationships and the like are abundant. A theme I kept repeating to myself over and over as I read was that this is big-time overkill for anything other than an enterprise-scale application. I'm as big an advocate of documenting client interviews as the next guy, but come on - breaking down every paragraph looking for verbs is just overkill. There was no advice given on how to solicit valuable information. Reports are discussed, but I'm a firm believer that reports can tell you much more about an application's true value than anything else. I very much prefer to start by asking the question "What information do you need from the system to do your job better than you do today?" than to start out by asking, "What do you do all day?" I find it the only way to break users out of the paradigm that they have worked in for so long and it leads to much more innovative useful applications. Nothing like this was in the book. I learned how to go through notes that magically appear, and that reports will shed light on missed pieces of information and new pieces of functionality, but who doesn't know that that has designed a database?Davidson is a BIG advocate of normalization. And while there is no substitute for a well-normalized database for application stability and data integrity, Davidson advocates the breaking out of tables for the most meaningless of reasons. Those that develop applications on top of his databases much hate all the extra work he builds in. I disagree with his assertion that the database should be built to anticipate any possible changes to the user-expected data. You will spend forever trying to anticipate changes, and even longer coding over the massive database you have built. For example, in order to store a user's address, Davidson advocates a six-table structure with five joins. Are you kidding me? What coder wants to deal with all that just for the possibility that some time down the road the users may want to add Address Line 10 to the application.Davidson also follows an annoying pattern for demonstrating his normalization techniques. He presents a data model with problems, introduces a concept, applies the concept to the tables and comes up with a better model. This is great, except that he continues to build on the same example throughout the book. So, other than the very last model, all the ones before it are incorrect. You have to read every word in order to get to the correct answer. It makes it impossible to pick up a chapter to use as a reference, because if you create a solution similar to the one demonstrated, you will have an improperly normalized database. Fine for a book you read front to back, but not so good for a reference manual.The implementation details of the book were even more disappointing. Davidson is not an advocate of an N-Tier approach to coding. He believes that as many of the business rules that can be incorporated into the database should be built there. He openly says that he butts heads with his developers and system architects over this issue. I'm not surprised. While I suppose that building the business rules into the database is good for data integrity, I think the biggest advantage for the DBA is job security. I believe that a well-built database should be flexible to changes in business rules and that the data should be stored independent of those rules whenever possible. We all know rules change, and I don't like messing with a production database if I can help it. I would rather have flexibility in the model and trust my business tier coders to do their job.The chapters on Stored Procedures, UDFs, Triggers, and the like are too complicated for a newbie and too un-detailed for an experienced developer. I found Professional SQL Server 2000 Programming by Robert Vieira a much better reference for both the basics and best practices.I guess I've written enough. I still feel there is value in this book. For someone that has never designed a database before or has no formal training, it may be a good reference, but I fear it will be too complicated for a true newbie. There are valuable bits of advice and I broke out my highlighter more than once. In particular, Davidson offers some simple modes for overcoming common problems such as attribute change history.Three stars - I just had too many disagreements with the author to go any higher.-HawkeyeGK



Product: Book Hardcover
Title: MCDBA Administering SQL Server 2000 Study Guide (Exam 70-228)
Publisher: McGraw-Hill Osborne Media
Authors: Joyjit Mukherjee
Rating: 2/5
Embarrassing, DON'T BUT THIS BOOK


I have read and reviewed over 25 MS certification books, and this is among the worst I've ever seen. This book was obviously rushed into print, as the spelling and grammar errors are the worst I've ever seen in any published material. There are many cases where they give example SQL text that doesn't even run b/c of inaccuracies. Many of the exam questions specify incorrect answers and/or tell you one answer is correct, then the answer explanation will explain why another answer is the correct choice.The book is week on substance, as many of its pages are filled with screen shots rather than enlightening content. The test questions are not similar to the type of questions found on the actual exam. If anyone actually reviewed this book before it went into production, they should be fired immediately, as it's hard to read more than a couple pages without finding errors, many of which make it difficult to determine what the author is trying to say.If you want to learn SQL server and desire to pass the exam, spend your time with other material.



Product: Book Paperback
Title: The Comprehensive Guide to the JDBC SQL API: Develop High-Powered Database Solutions for Your Site
Publisher: Ventana Communications Group
Authors: Daniel I. Joshi, Rodney Runolfson, Ramesh Chandak
Rating: 5/5
Great Introduction


I had no knowledge of JAVA or JDBC and a limited understanding of SQL. I found the book extremely informative and well written Given the enormity of the three topics covered the author does an excelent job of introducing these. I don't think this book will suit professional Java Coders but if you want to understand the concept of how JAVA, JDBC and SQL work together this is an excellent book. A great book to get started



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: 5/5
Great book for fast understanding of SQL


By far the best book for learning SQL fast that I have read. I have recommended it to many software developers who understand computer languages and want to learn this one. Wonderfully thin and straight-forward, it does not focus on the boring details of SQL syntax, but on how you write various types of queries using this language. Best value I have found to date in an introductory SQL book.



Product: Book Paperback
Title: Core PHP Programming: Using PHP to Build Dynamic Web Sites (2nd Edition)
Publisher: Pearson Education
Authors: Leon Atkinson
Rating: 3/5
Not really a programming manual.


I'd rather give this 2.5 stars but that's not an option. I recently checked this book out of the library prior to deciding whether to buy it for my personal reference library. I was hoping for a good overview of programming PHP applications but instead got a basic language reference, which is okay as far as it goes but it certainly isn't the way it's advertised. As a reference manual its adequate but not as good as some of the other manuals out there, including the (free) online PHP documentation. On the whole its rather a disappointing book as it doesn't fulfill any objective well.



Product: Book Paperback
Title: A Guide to SQL Server 2000 Transactional and Snapshot Replication
Publisher: Not While the Surf's Up Press
Authors: Hilary Cotter
Rating: 5/5
Thorough and comprehensive


The first and only a fully comprehensive book on Transactional replication, filling a gap that has existed for over five years. I found it easy to read, and I like that it covers both the surface phenomena like wizards, and internals such as tables and stored procedures. By taking time with both, the book adds a nice perspective to a very complex topic. It also avoids the scattershot approach of online help.
Just a couple of days after getting the book, I jumped ahead to the internals of the distribution database and based on Hilary's info, write a query to monitor the progress of transactions. Very nice!



Product: Book
Title: Getting The Search Engine Ranking Your Website Deserves: : META Tags Yield To Google's PageRank As Search Engine Standard
Publisher:
Authors: John Henderson
Rating: 1/5
A worthless collection of cliches??


The concept of the author's article is excellent. I have discussed the idea of "page ranking" versus "site ranking" with fellow memebers at work and the process is right. There appears to be no way to trick or fool search engines. You can buy pay-per-click ranking (That's expensive.) or work to make your pages worth something to the search engines. I'd advise every webmaster to re-set their thinking. Concentrate on page ranking!



Product: Book Paperback
Title: Advanced Transact-SQL for SQL Server 2000
Publisher: Apress
Authors: Itzik Ben-Gan, Tom Moreau
Rating: 2/5
Not a COMPLETE waste of time


I don't agree with the other review on here that says this book is a complete waste of time. There are a few bright spots here and there. If you're very new to SQL Server, you may find, say, 5% of the book to be useful and to pass on info that you won't find in the Books Online.However, I do agree that the narrative is pretty uneven at times. You can definitely tell that more than one person wrote this book (e.g., when you see completely different code formatting on the SAME page :-).I didn't get much out of the book myself, hence the two-star review. Then again, I'm an advanced SQL Server developer (MCDBA) who's been working with the product for about two years now. The book was definitely beneath me, but if you're just starting with SQL Server you might learn a few things from it.



Product: Book Paperback
Title: Sams Teach Yourself SQL in 10 Minutes, Third Edition
Publisher: Sams
Authors: Ben Forta
Rating: 5/5
Good Succinct Primer on SQL


I taught a class to co-workers who had no SQL experience using this book, covering the first 6 chapters in approximately 4 hours; and the next day they were able to assist in writing queries, easing my workload (this is an excellent book to use for learning how to write queries, but it does not cover design, for that see Steven Roman's Access Database Design and Programming). This book demands a careful reading as it explains the syntactical differences between different implementations of SQL (e.g., Access uses * and ? as wildcards as opposed to % and _).



Product: Book Paperback
Title: MCSE Database Design on SQL Server 7 Exam Cram (Exam: 70-029)
Publisher: Coriolis Group Books
Authors: Jeffrey Garbus, David Pacuzzi, Alvin Chang, David Pascuzzi
Rating: 3/5
Not for the exam


It is so different from the exam: for example, all the SQL Profiler and the execution plans are missing. Nevertheless, it's a good companion to other guides and it takes 2-3 days to read. Better than nothing....



TopSellers at Amazon - Handheld PDA-s

Garmin Forerunner 301 Personal GPS with Heart Rate Monitor
PalmOne Zire 31 Handheld
PalmOne Tungsten E2 Handheld
PalmOne Tungsten E Handheld
PalmOne LifeDrive Mobile Manager
Fossil Abacus AU5005 Wrist PDA with Palm OS - Black
Franklin Speaking 11th Collegiate Dictionary
PalmOne Zire 72 Special Edition Handheld Silver
PalmOne P10952U 802.11 Wi-Fi SDIO Card for Tungsten T3 and Zire 72
HP iPAQ RX3115 Pocket PC

TopSellers at Amazon - Cables and Interconnectors

Belkin Pro Series USB 2.0 Device Cable (USB A/USB B, 10 Feet)
Belkin F3U133-06 USB Device Cable (6 FT)
Belkin F3N401-06-ICE IEEE 1394 4-Pin/6-Pin 400 Mbps FireWire Cable (6 Feet)
Belkin F3U133-16 USB 2.0 A/B Cable (16 Feet)
Belkin F3U134-10 USB A/A Extension Cable; 10ft
Sima CT-2 Video Signal Processor
Monster Cable iSplitter for iPod and PowerBook
Nikon UC-E6 Replacement USB Cable for Coolpix 2100, 2200, 3100, 3200, 4200, 5200, 8400 & 8800 Digital Cameras
Belkin IEEE 1394 FireWire Compatible 4pin/4pin Cable (3-foot)
Monster Cable iCable for iPod

TopSellers at Amazon - Office Phones

Motorola MD671 5.8GHz Cordless Speakerphone/Caller ID
Cardo Systems scala-500 Bluetooth Headset
Plantronics Audio 90 Multimedia Stereo PC Headset
VTech ip5850 5.8 GHz DSS Cordless Phone with Dual Handsets and Digital Answering System
Creative Labs WebCam Live!
Uniden TCX800 Accessory Handset for TRU8800 Expandable Phones (Silver/Black)
Panasonic KX-TG5433M 5.8 GHz DSS Cordless Phone with Answering System and Three Handsets
Logitech 980158-0403 Internet Chat Headset
Panasonic KX-TCA60 Headset
Panasonic Type-24 PP511A Cordless Telephone Rechargeable Battery Replacement

Top 10 yahoo news about mobile phone technology

Yemen short-lists six for GSM award (ITP.net)
Servinova begins seamless Wi-Fi-GSM/GPRS VoIP network testing with ASNAP (MobileMag)
Strategic Partnership with CPS Enables Simcom to Integrate; High Accuracy Location Technology into GSM/W-CDMA Devices (ZDNet India)
Photo Release -- Servinova, a Cisco Systems Registered Partner Company Has Started Network Testing on CISCO Aironet (PrimeZone via Yahoo! Finance)
2N Intros GSM VOIP Support (Unstrung.com)
Wireless: Making a living from cellphone innards (International Herald Tribune)
Photo Release -- Servinova, a Cisco Systems Registered Partner Company Has Started Network Testing on CISCO Aironet (RedNova)
Group Helps Fight AIDS in Zambia; Four From Vancouver Join Christian Program (RedNova)
Docomo seeking overseas suppliers (Electronic Engineering Times Asia)
Bharti to outsource call-centres business for Rs 1,100 crore (Financial Express)

Valid XHTML and CSS

Valid XHTML 1.0!

Valid CSS!

Most popular searches about sql, php, apache and more

database or object is
perl dll
sql reference
sql anywhere
perl pass by
associated with a trusted sql
perl concatenate
speech database
and database
college database
php ftp
perl do
apache for
wireless programming
perl loop through
collegiate programming
programming conference
ms sql server 2000
perl regular expression
database visual
javascript programming
apache directory
php self
sql software
javascript programming
parent directory appz xxx html htm php shtml opendivx md5
string php
database port
unix programming
access database help
database driven website
values perl
sql server error
perl do
java database programming
php content
asp database
linear programming
2000 database
programming internships
windows programming tutorial
insert sql
php install
wireless programming
html htm php asp
sql script
and access database
php cookbook pdf free download
mysql for dummies ebook chm file torrent
apache book emule pdf free warez

# A B C D E F G H I J K L M N O P Q R S T U V W X Y Z