IT programming books related reviews
Title: The Guru's Guide to Transact-SQL
Publisher: Addison-Wesley Professional
Authors: Ken Henderson
Rating: 5/5
If you are serious about squeezing everything out of SQL SERVER then this is THE book to buy. This is one of those rare books I take to work, leave there and refer to often. It somehow shows you the hard stuff when you need it.When I first read the book I kept saying WOW, I didn't know that, or 'That's how you do it'. I'd still pay for the book, if it was 1 chapter long. That's how much I've gotten from it!
Title: Professional PHP Programming
Publisher:
Authors: Jesus Castagnetto, Sascha Schumann, Harish Rawat, Chris Scollo, Deepak T. Veliath
Rating: 3/5
The main problem with this book is that the authors tried to keep it too "simple". I don't see why they bothered entitling it "Professional", when everytime something of critical purpose would come up they simply refer you else where or say "that is beyond the scope of this book since we are trying to keep it simple". The book does have a few decent examples, but I found leaving out SSL (Secure Socket Layers) in the disscussion of the Shopping Cart application to render the application nearly useless. But it can be used as a good example on how to tier a MySQL database. The other "application" is so focused on the content of the MySQL database, that it doesn't serve as a very good abstract model. Too much babble and not enough focus on what the code is doing. Your milage may vary, but coming from the standpoint of a "professional" I found the book to be lacking on the substance I needed most...
Title: SQL Server 2000 XML Distilled
Publisher: Curlingstone
Authors: Kevin Williams, Bryant Likes, Andrew Novick, Daryl Barnes, Paul Morris, Simon Sabin, Steve Mohr, Andrew Polshaw, Jeni Tennison
Rating: 5/5
SQL Server 2000 XML Distilled, from cover to cover its 100% professional & 100% technically absorbing.The content is mega interesting & discussed as you would use it here on planet-earth. It really gets into the juicy everyday issues.For example, converting data-types, and modeling enumerations: from XML code to creating a table & then inserting values into the table.Talk about nitty-gritty discussion: when it comes to OPENXML, in other books it's the same old story "it impacts performance", well that's not the case in this book - here there is a download file to setup and test, & a series of timing graphs supported with clear & objective discussion. The book even identifies an apparent level of fixed overhead for the number of elements that are parsed.
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
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!
Title: Professional SQL Server 2000 Programming
Publisher: Wrox
Authors: Robert Vieira
Rating: 5/5
This is a good book on many different aspects of SQL Server. It covers the basics of Creating Databases, Tables, Stored Procedures, Triggers, etc. It also talks a little about administration. It touches enough on every area to get you up and running with SQL Server 2000. This book is a sufficient resource for 80% of the developers out there who are also DBAs.
Title: Transact-SQL Programming
Publisher: O'Reilly
Authors: Lee Gould, Andrew Zanevsky, Kevin Kline
Rating: 2/5
Neither the code on the CD nor the source listings in the book are aimed at SQL Server 7.0. In fact, many of the examples don't work on MSSQL 7.0 because they query system tables that no longer exist (such as sysprocedures). The cover of the book says it covers 7.0, but actually 7.0 is covered only in an appendix. I'm giving it 2 stars because the code examples are antiquated and many simply don't work on the current version of the server.
Title: Microsoft SQL Server 2000 Notification Services
Publisher: Sams
Authors: Shyam Pather
Rating: 4/5
The motivation for this product is the desire by many users to be informed of certain types of data, or when such data changes, and where the data is on a different machine. An elementary case that you may have used is to sign up for a newsletter. But that is very primitive compared to what the book describes that SQL Server can do for you. That newsletter is basically a binary operation. Usually, you cannot specify more precisely what within that newsletter you're interested in.
But Pather shows how you have far more expressive power in your NS subscription. and how NS takes in these requests, along with various data feeds, and applies the requests to that data, to craft responses.
The book gives a heavy and natural use of XML for the user to encode her subscription preferences. It is for such things that XML is well suited. It also shows why Microsoft made a good decision to standardise on XML as its messaging language. On the server, we see considerable details about how to parse and apply the requests. The book is not a trivial read. Pather indicates that you may have serious coding on the server, using C# as the language of choice.
Title: Sybase Transact SQL Guidelines Best Practices
Publisher: Isosf Software
Authors: Mich Talebzadeh, Ryan Thomas Putnam
Rating: 5/5
I have read this book and I have found it really good. It is well written in simple enough language even for juniors to follow. Practical examples are very good. Tuning and optimisation examples are excellent and so is tempdb recommendations. By far the best Sybase book I have seen
Title: Easy Google
Publisher: Que
Authors: Shelley O'Hara
Rating: 4/5
A pretty, visual book. Each page has full colour screen shots of Google's pages. You might wonder at first, why? Don't you just use its main page? Well, that is the very point of this book. O'Hara shows how you can gain far more from Google.
For example, the Directory Pages gives a top down format for data searching that mimics Yahoo's directories, that originally shot Yahoo to fame on the Internet.
Plus, there is Google news. These are near real time news feeds from news organisations all over the world. Its greatest merit may be to expose you to alternative viewpoints; instead of just your regular newspapers.
But potentially the most useful portion of the book concerns the advanced search options. Many never avail themselves of these. Which is a pity. The book shows a good understanding can be a tremendous force multiplier to your web searching. Well worth spending some time getting acquainted and facile with these options.
Title: Microsoft SQL Server 7 Administrator's Guide
Publisher: Muska & Lipman/Premier-Trade
Authors: Ron Talmage
Rating: 1/5
What is new in SQL 7 is the content of this book. I really like how the author highlight every important points that had changed from SQL 6.X. From its relational engine to data architecture to store procedures, all the essential points and new features of SQL 7 are clearly presented. This book is a good resource for DBA who has general knowledge of SQL 6.X and needs to get up to date quickly on SQL 7. Although on the back cover it said for user level of intermediate to advanced, it is also a good book for beginners too.

