Sponsored links

Valid XHTML 1.0!
Valid CSS!

Product: Book - Paperback
Title: Oracle High-Performance SQL Tuning
Publisher: McGraw-Hill Osborne Media
Authors: Donald K. Burleson
Rating: 1/5
Customer opinion - 1 stars out of 5
no detail and some mistake

After having tuned our server, network, and database it was clear that the remaining slow performance was due to the SQL.This led me to the purchase of this book which has not disapointed. This book goes into great detail about how sql statements effect database performance and how to correct it.After just the first few chapters, I was able to quickly find 'hot' sql statements and see how they were causing bad performance due to full table scans, merge joins, slow index scans, hints, built in functions, sorting etc. This book gives a good explanation to the various table / index access methods and thus improved my ability to look at an explain plan and quickly see problem areas. With this book I have better understanding of the options to correct them without messing with the sql code. Infact, most all of these are correctable without changing the sql code - my favorite part.There is of course a lot written on tuning to the code that can make great strides in performance as well, but as a dba and not a developer, I was more focused on things I could do to improve performance without changing the code.
The scrips with the book are especially good - pull sql out of the library cache on the fly, or out of statspack tables for hisorical analysis - and get reports on full table scans, various index scan reports, etc. These alone make the usefulness of this book fast and easy - worth it.
In short, I recomend this book to anyone wanting a better understanding of how sql code is affecting your DB performance as well as options to correct it. This is good if you have applications where you can't change the code (or just don't want to) but see improvements in performance need be made.

Product: Book - Paperback
Title: MySQL (3rd Edition) (Developer's Library)
Publisher: Sams
Authors: Paul DuBois
Rating: 5/5
Customer opinion - 5 stars out of 5
Finally, THE book for MySQL

Just got the book two days ago and have not put it down except to read "Building Database Applications on the Web Using PHP3." (another great buy.)
I am new to SQL and this book is something worth buying. It is written for both techies and non-techies, and if you have the desire to learn MySQL, buy this book. It is the most concise and well written book on the language ever.
Make sure you block out a chunk of time, because once you start reading, you will not put this book down. It fills the gap where other books fail. The tutorial gets you up to speed very quickly (VERY) and you will be building databases within the first 1/2 hour of opening the book. I buy an average of 5 or so books a week and I guarantee that most of them will be covered with dust before I put this book down.
If you have the desire to learn on your own and want to learn MySQL...
BUY THE BOOK! Don't wait! Sell something if you have to, get a second job. Whatever it takes, you can not be without this book!

Product: Book - Paperback
Title: Essential XML Quick Reference: A Programmer's Reference to XML, XPath, XSLT, XML Schema, SOAP, and More
Publisher: Addison-Wesley Professional
Authors: Aaron Skonnard, Martin Gudgin
Rating: 5/5
Customer opinion - 5 stars out of 5
Exactly what a Quick Reference should be...

This book covers all the essentials of XML quickly and with no distracting fluff. This is the by far the best XML book I have read, and I highly recommend it.

Product: Book - Paperback
Title: Moving to VB .NET: Strategies, Concepts, and Code
Publisher: Apress
Authors: Daniel Appleman, Dan Appleman
Rating: 5/5
Customer opinion - 5 stars out of 5
My Choice for a First VB.NET Book

There are a lot of books out there for transitioning to VB.NET from VB6. However, before you grab any other book, I strongly suggest "Moving to VB.NET: Strategies, Concepts, and Code" by Dan Appleman. Written from an in-the-trenches, "I've been there" point of view, Dan introduces the reader to .NET using the single best possible approach: from the ground up. Due to the steep learning curve associated with .NET, approaching this subject is tricky, but I feel Dan has done a truly excellent job. Up front, this book is in my opinion the first book a VB6 person should read on the subject. It also helps that it is structured in such a way that it could be easily broken down for a classroom environment, getting a company up to speed.
One thing Dan really stresses is for the reader to familiarize themselves with the MSDN library. That point cannot be stressed enough. Unlike previous versions, MSDN for .NET was written with the VB.NET developer in mind, and is completely VB-friendly. Also, in the rare cases where Dan fails to explain an item right off the bat, such as the `Shared' operator (he does get to it), or the really cool `IntPtr' variable type, just quickly look them up in MSDN. The wealth of available information found there is fantastic.
When you crack Dan's book, please be sure to download the example files (and any errata updates) from the site location he suggests. Being able to view, run, and hack complete listing is an invaluable tool in comprehending the points he is making regarding each subject (I like them just so I can add expository comments once I understand a technique -comments are sparse, but just to keep space tight because much of the code, broken into blocks, is also in the book).
Though easy to read, this book is definitely not one to skip chapters on. If you do not fully understand everything in a previous chapter, the next chapter can be more difficult to digest. I was surprised that often a chapter would require only a second re-read to fully comprehend everything covered. Making reference notes and clarifications in the broad margins as "Notes-To-Self" is also a great help when you finally place this book in your reference library - and it WILL find itself there. This book is loaded with very powerful techniques that you will want to refer back to again and again.
This book has also crushed my habit of harkening back to the glory days of VB6, and of calling VB.NET by derogatory names such as Visual Fred and VB.NOT. Not only does the book explain the differences in structure between VB6 and VB.NET, but in the process it completely turned me on to the VB.NET philosophy and the much more powerful, and most-often much simpler methods of doing them in .NET. Every point I had once griped about, such as, for example, the `lack' of fixed-length strings and arrays in user-defined types was shown to be completely unfounded. Things that I complained that were missing have been in fact replaced by something much better and more powerful.
With this book as a launching point, in a day I can now develop applications under VB.NET that are just as powerful, and run just as fast as the C++ applications I used to develop over several weeks under Visual Studio 6. The book's author has shown me the way toward being comfortable with the.NET environment, and made me excited in my transition to it.
All things considered, after reading Dan Appleman's book, I now wish Microsoft had come out with .NET after VB5.