Post reply

Recommend some books for SQL 2000 and SQL 2005?

  • December 7, 2006 at 3:28 pm

    #171560

    As my path down databases continues, I need to add to my library to better understand databases overall.

    I have learned quite a bit lately, but I need to learn more, as much as I can.

    Does anyone have recommendations on some books? I was hoping to learn HOW to write SQL query (like select, insert etc.), better Database understanding, administration etc...

    Also, what is the difference between SQL programming and SQL query? I saw a 2005 T-sql book with those titles?

     

    I appreciate it.

     

    Jason

  • December 7, 2006 at 4:12 pm

    #676766

    For programming, I like Ken Henderson's The Guru's Guide to Transact-SQL.

    For using Profiler, I like Brian Kelly's e-book Start to Finish Guide to SQL Server Performance Monitoring

    Then there are the free Books OnLine.

    -SQLBill

  • December 7, 2006 at 4:14 pm

    #676769

    Thanks. I appreciate it.

     

    What is the difference between SQL Programming and SQL T-SQL Query programming? (I think thats it)

  • December 7, 2006 at 4:15 pm

    #676770

    I'm not sure about the difference between Programming and Query as the book you saw used them. I would have to see the book.

    However, it might be that programming involves more than just querying the database. You can create objects (dbs, tables, stored procedures, jobs, etc) via programming. But you query the data that is in the database/tables).

    -SQLBill

  • December 7, 2006 at 5:19 pm

    #676784

    I'll second pretty much anything that Ken Henderson has done. Guru's Guide to T-SQL is key... nearly every good SQL DBA I've ever known has owned a copy.

    I've also liked stuff by Joe Sack.

  • December 7, 2006 at 6:00 pm

    #676790

    Thanks guys. I appreciate it.

    Here were the two books I was curious about what the difference is:

     

    http://www.amazon.com/Inside-Microsoft-Server-2005-Pro-Developer/dp/0735621977/sr=8-1/qid=1165539295/ref=pd_bbs_sr_1/002-0017924-5084072?ie=UTF8&s=books

     

    http://www.amazon.com/Inside-Microsoft-SQL-Server-2005/dp/0735623139/ref=pd_bxgy_b_text_b/002-0017924-5084072

     

    Here is a list of books from Ken Henderson...anyones that you highly recommend to help me get started and learn a lot of SQL from?

     

    http://www.bookpool.com/ss?qs=ken+henderson

  • December 8, 2006 at 7:34 am

    #676882

    The ISS T-SQL Querying book concentrates on writing efficient queries, the programming book looks at other components of programming - datatypes, xml, etc., etc., etc.

    Before digging in to the development or monitoring books, you will do yourself a significant favor to gain a very solid understanding of stuff going on under the hood.  The comparatively thin but extremely informative book The SQL Server 2000 Performance Optimization and Tuning Handbook by Ken England ought to be required reading for anyone allowed to develop for SQL Server.

    Link:

    http://www.amazon.com/Microsoft-Server-Performance-Optimization-Handbook/dp/1555582419/sr=8-1/qid=1165587908/ref=sr_1_1/102-8673912-0385730?ie=UTF8&s=books

    The book is applicable to SQL Server 2005 as-is, with the exception of some new SQL 2005 features, such as index INCLUDEs and row versioning.

    I recommend this book constantly.  Everyone I know who has read it - including me - was completely changed in the way we look at and develop for SQL Server after reading the book.

    -Eddie

    Eddie Wuerch
    MCM: SQL

  • December 8, 2006 at 8:44 am

    #676930

    Good 2005 reference, coding, performance, and some admin:

    http://www.wrox.com/WileyCDA/WroxTitle/productCd-0764584340.html

  • December 8, 2006 at 9:31 am

    #676967

    And when you figure out all those, check out the Joe Celko SQL books.

  • December 8, 2006 at 10:13 am

    #676986

    If you are looking for a good DBA admin type book that covers SQL Server 2000 from start to finish I would check out Professional SQL Server 2000 Programming by Robert Vieira.  It goes into great detail but he does a great job of explaining in common terms.  It discusses everything from what is a relational database to security to log shipping etc...

    Cortec

     

  • December 8, 2006 at 1:44 pm

    #677042

    Inside SQL server 2000/2005 by Kalen Delaney

    MohammedU
    Microsoft SQL Server MVP

  • December 11, 2006 at 8:20 am

    #677214

    Who if you look is the series editor on the T-SQL Querying and Programming books metioned. I like Kalen's stuff and Ken's but there are lot's of books out there, I would suggest maybe one of the in 21 Days, Iditos or Dummies for a start to build ground work. You need to find something simple to start then work your way up from there. Also learn proper database design in addition to SQL T-SQL itself.

Viewing 12 posts - 1 through 11 (of 11 total)

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