Which book to buy for 100$

  • Just curious, you found something by Celko less well researched? Would love to hear an example.

    If you want to know the relational model and theory - Data and databases by Celko is great (I got mine on half.com for $5)

    Inside SQL Server, as someone else mentioned, is excellent.

    If you want to know data warehousing get almost any book by Ralph Kimball (specifically the data warehouse lifecycle toolkit series)

    GL

    Ray Higdon MCSE, MCDBA, CCNA

    ------------

    Ray Higdon MCSE, MCDBA, CCNA

  • How about an Oracle Architecture book?

    Cheers,

    - Mark


    Cheers,
    - Mark

  • quote:


    Krispy Kreme is amazing, especially when hot! They melt in your mouth.


    Maybe I get flamed for this, but I don't like Donuts!

    ...and McDonalds I don't like, too!

    quote:


    Course feel free to send us here your 2004 renewal fee of US$0 for the site.


    what about taking this as prepayment for next 5 SSC annual books?

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • quote:


    Just curious, you found something by Celko less well researched? Would love to hear an example.

    If you want to know the relational model and theory - Data and databases by Celko is great (I got mine on half.com for $5)


    here we go!

    http://www.pgro.uk7.net/cjd6a.htm (Btw, from my point of view, one of the rare true valuable sources on the net!)

    quote:


    The SQL language was developed by IBM's Santa Teresa labs ... The big debate during development was not over the relational model, but over how NULLs should be handled ... The result was System R and Sequel (Structured English-like Query Language) as their first product ... The language was later extended a bit and became the first version of SQL


    this is simply not accurate, as C.J. Date points out!

    no big point, I admit, but it is written

    Frank

    I have heard of Ralph Kimball. I guess he must be to Datawarehousing what codd is to RDBMS. I'm not very much into Datawarehousing, but if I really change position internally, I will be confronted with this topic

    Edited by - Frank Kalis on 09/05/2003 12:49:33 AM

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • quote:


    How about an Oracle Architecture book?


    Did I already mention that I struggle with Australian humor

    Now, being serious, Oracle isn't an option for me at all. We will kick out our Oracle server around mid of next year. And everyone is not really sad about this.

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • Frank, excellent link on CJ Date's opinions, I still like Celko but can see his points.

    Thx

    Ray Higdon MCSE, MCDBA, CCNA

    ------------

    Ray Higdon MCSE, MCDBA, CCNA

  • Hi Ray,

    quote:


    Frank, excellent link on CJ Date's opinions, I still like Celko but can see his points.


    don't get me wrong.

    I have not read anything from Celko yet. And I think he wouldn't be the authority he is, by talking and publishing just nonsense!

    But I was really suprised when I read the article in the link. For I considered this 'common knowledge' or at least are the information reachable for everyone.

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • Database Design for Mere Mortals by Michael J. Hernandez (Addison-Wesley, 1997)

    Finally I found this again.

    Anyone can comment on this?

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • Take Celko in perspective: he's human like the rest of us. I have one of his books (SQL for Smarties) and found it to be interesting, just as I found the 1st Henderson book interesting (don't have the second, so I can't comment on it). I also found the Transact-SQL Cookbook to be an interesting book but it hasn't gotten the greatest reviews. I originally took a look at it because MVP Vyas Kondreddi recommended it.

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/

    K. Brian Kelley
    @kbriankelley

  • I'm surprised that nobody has mentioned the new SQL Server 2000 High Availability book. It is awesome!

  • callison,

    Who is the author/publisher/ISBN? Why do you like it so much? I haven't heard of it but I haven't been looking. With that kind of reference, I am interested.

    All the best,

    Dale

  • It is a Microsoft Press book. Authors are Alan Hirt, Cathan Cook, Kimberly Tripp, and Frank McBath. The ISBN is 0-7356-1920-4. It came out a little more than a month ago. It covers everything from disk configurations, clustering, log shipping, replication, backup and recovery, etc., in depth and with information that is not easy to find anywhere else, or, at least, is not put together in the systematic, intelligent way that it is presented in the book. It also takes into consideration the "real world" -- always a refreshing approach. I haven't found anything in it yet that is incorrect, or with which I disagree. These folks know of what they speak! The list price of the book is USD $49.99, and it is worth every penny.

  • I've been at a few seminars where Kim Tripp spoke and she is awesome.

    Ray Higdon MCSE, MCDBA, CCNA

    ------------

    Ray Higdon MCSE, MCDBA, CCNA

  • Hi Brian,

    quote:


    Take Celko in perspective: he's human like the rest of us.


    I've mentioned before, it's no big point, but I was really suprised to see such an 'slip of the pen' (sorry, looked this up in a dictionary) from such an authority.

    As you know, I did some research on the topic of SQL's history, so I was able to figure out that the points are not accurate. And when I am able to do so, for someone like Celko this should be a really simple exercise!

    And it is my believe (some would say my problem) that you are judged on what you do. I don't give anybody credit just because he brings in a big name. If something is wrong, it is wrong. No matter who did it. Simple as that!

    I can't say anything on other works by Celko, because I don't know them.

    But I guess they must be somehow outstanding, otherwise Celko wouldn't be what he is.

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • Hi there

    I have to say, Ken Henderson's T-SQL GURU book is a great buy. Other option I would seriously consider is http://www.books24x7.com, fantastic site and hundreds of books... save up a little more of course but well worth it.

    Cheers

    Cl

    Chris Kempster

    http://www.chriskempster.com

    Author of "SQL Server 2k for the Oracle DBA"


    Chris Kempster
    www.chriskempster.com
    Author of "SQL Server Backup, Recovery & Troubleshooting"
    Author of "SQL Server 2k for the Oracle DBA"

Viewing 15 posts - 16 through 30 (of 33 total)

You must be logged in to reply to this topic. Login to reply