Post reply

Good Book for SQL Developer

  • December 14, 2004 at 4:12 pm

    #59752

    Hello,

    What is your opinion on the best book on SQL Server Development?  (not Administration)

    Would it be "Inside Microsoft SQL Server 2000" ? Someone I know needs to cover different areas from TSQL to DTS to good database application design.  Level - medium to high, he is already supporting SQL Server and applications for several years and was supporting other RDBMS apps before that, but wants to know more.

    Yelena

     

     

    Regards,Yelena Varsha

  • December 14, 2004 at 8:49 pm

    #533884

    Try "Profesional SQL Server 2000 Programming" from Wrox.

    Kindest Regards,

  • December 15, 2004 at 1:12 am

    #533897

    I agree!

    "Professional SQL Server 2000 Programming" from Wrox has been invaluable to me.

    Regards

    Chris

  • December 15, 2004 at 1:21 am

    #533899

    If this Wrox book is that by Louis Davidson, I would have a close look at in the book shop first. One might think different on it.

    For me, I really love the Ken Henderson Guru's stuff. Kalen Delaney is always a must-have. Apart from this, you'll find that good book are rare.

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

  • December 15, 2004 at 1:34 am

    #533900

    The Wrox book I'm on about is by Robert Vieira.

    As a rule I tend to go with O'Reilly books, but the Wrox one was at my work already and I've not found a need to find another one.

  • December 15, 2004 at 5:12 am

    #533917

    I use..

    Inside SQL Server 2000 (MS Press)

    Mastering SQL Server (Sybex)

    SQL Server 2000 The Complete Reference (Database Professional's Library)

    Each of these has a different and better feel/read on different subjects which is why I have the 3.  1 is good for day-day, 1 for OLAP, 1 for odd ball stuff.

    I would sit down in the book store and read different chapters from a bunch of the different books and pick the ones that you like to read. 



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • December 15, 2004 at 7:09 am

    #533937

    The Wrox book by Viera is the one I use.  I chose it because of recommendations and wasn't disappointed.

    Regards,

    Scott

  • December 15, 2004 at 8:59 am

    #533970

    Hello,

    Thanks to all for the advices, highly appreciated.

    I myself read  "Inside Microsoft SQL Server 7" by Ron Soukup and Kalen Delaney when it came out, I had a good 6.5 book before that, but I did not read Kalen's 2000 version of the book. I took SQL 2000 Microsoft class and was somewhat dissappointed because I expected more of the new and complicated stuff in the class versus generic knowledge, but maybe it was just my wishful expectations.  I read Microsoft training materials for 70-029 and 70-229, they were OK.

    I also found very good chapters on the Relational theory in one of the Microsoft Access books that someone loaned me years ago, don't rememmber the title of the book. I found a lot of helpful theretical topics on database application architechture in the Microsoft training materials when preparing to the exam "70-300 Analyzing Requirements and Defining Microsoft .NET Solution Architectures "  For example a good whatie paper by Terry Halpin "Object-Role Modeling (ORM-NIAM) I use mostly BOL myself, but in this case I needed some systematically organized reading with good overview of the features for someone.

    Yelena

    Regards,Yelena Varsha

  • December 15, 2004 at 9:07 am

    #533972

    Hm, wasn't aware that you're also looking for books on the theory behind. For this topic, you might want to google for books by Jim Melton, Chris Date et al. But that's rather academical stuff at times. However, always good to read when you can't get to sleep.

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

  • December 15, 2004 at 9:23 am

    #533979

    Frank,

    Yes, you are right. I  was not looking for the theoretical books in my initial request because it was not for me.

    But I myself and someone else I know will certainly read the books you recommended. I am heavily in theory and architecture on one end  and administartion on the other end (if you can believe it) leaving the actual development that comes in between to others. Or at least trying to do that. I do some VB and WMI development instead.

    Yelena

    Regards,Yelena Varsha

  • December 15, 2004 at 9:55 am

    #533985

    I have looked at dozens of T-SQL books and few are really great. Here's my list:

    Professional SQL Server 2000 Programming by Robert Vieira

    The Guru's Guide to Transact-SQL by Ken Henderson

    SQL Puzzles & Answers by Joe Celko

    A few others have useful sections. My focus is on T-SQL development, of course. Not so much admin or theory or "inside."

    Thanks,

    Markus Lofstrom

  • December 15, 2004 at 10:06 am

    #533988

    I really like this book.

    http://www.bookpool.com/.x/3b9ypa4by8/sm/1893115828

    Pretty good book for the programmers who want to move toward more advanced stuff

  • December 15, 2004 at 10:26 am

    #533991

    Yelena,

    I agree with previous posters regarding the Viera book from Wrox.  It got me up to speed quickly and did a good job of explaining the what, how and why of developing working applications on SQL Server.

  • December 15, 2004 at 7:01 pm

    #534068

    I agree with Herb on Advanced T-SQL for SQL Server 2000:

    "http://www.bookpool.com/.x/3b9ypa4by8/sm/1893115828

    Ken Henderson's "Guru" books are also very helpful.  Inside SQL Server 2000 gives good explanations on what is happening under the covers.  Sometimes that's what you need to figure out that SQL Server is really doing what you told it to do, and you shouldn't have done that! 

    There is no "i" in team, but idiot has two.

  • December 16, 2004 at 5:21 am

    #534127

    Always used BOL...

    Nothing else required for SQL Server....

Viewing 15 posts - 1 through 15 (of 17 total)

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