A good T-SQL Programming book

Question

A good T-SQL Programming book

valeryk2000

SSCarpal Tunnel

Points: 4245
More actions
June 17, 2011 at 1:57 pm

#389770

Hi everybody,
could you suggest a good book for SS programmer? Some time ago I loved the one by Kevin Kline at al. - but this was from 1999. Now other people in our dept want to learn T-SQL and other SS2K8 issues.
Thank you in advance
Val

Viewing 10 posts - 1 through 9 (of 9 total)

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

PaulB-TheOneAndOnly SSC Guru Points: 66772 More actions · Answer 1

valeryk2000 (6/17/2011)
could you suggest a good book for SS programmer? Some time ago I loved the one by Kevin Kline at al. - but this was from 1999. Now other people in our dept want to learn T-SQL and other SS2K8 issues.
Thank you in advance

Somebody in this forum published time ago a simple yet great method to select a book.

Write down a list of ten question on the book's subject then go to a book store and try to answer these questions using available books on the subject.

Buy the one that allowed you to find the answers more easily and which answers are more easily understandable.

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

I usually check out Amazon.com first. Many books are not in Stock in the book stores.

You can read the reviews and if they have a Look inside you can look at the table of contents.

You can then check the book stores web site to determine if a book is in stock and check out the book before purchasing.

Compare the prices, Amazon is much cheaper.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Dave Ballantyne SSC-Dedicated Points: 33667 More actions · Answer 3

Anything by Itzik Ben-Gan would be highly recommended.

Clear Sky SQL
My Blog[/url]

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 4

The following books by Itzik Ben-Gan are very good:

Inside Microsoft® SQL Server® 2008: T-SQL Programming

http://www.amazon.com/Inside-Microsoft%C2%AE-Server%C2%AE-2008-ebook/dp/B0043M52MC/ref=sr_1_1?s=books&ie=UTF8&qid=1308507910&sr=1-1/

Inside Microsoft® SQL Server® 2008: T-SQL Querying

http://www.amazon.com/Inside-Microsoft%C2%AE-Server%C2%AE-2008-ebook/dp/B0043EWUUW/ref=sr_1_2?s=books&ie=UTF8&qid=1308508011&sr=1-2

Under the other issues category Microsoft® SQL Server® 2008 Internals (Pro - Developer) is a very good book.

http://www.amazon.com/Microsoft%C2%AE-SQL-Server%C2%AE-2008-Internals/dp/0735626243/ref=sr_1_11?s=books&ie=UTF8&qid=1308507699&sr=1-11

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Latheesh NK SSCertifiable Points: 6559 More actions · Answer 5

Please follow also the Gurus's series by Ken Henderson.

Mike McQuillan SSCertifiable Points: 6000 More actions · Answer 6

I learnt SQL Server programming using Robert Vieira's Programming SQL Server 2000 book. It's a great book and very comprehensive.

The 2005 version is also excellent but contains a number of editing errors (calling SSMS Query Analyzer, for example).

I haven't read the 2008 version of the book but the reviews are good. I wouldn't think you'd go far wrong picking it - here's the Amazon (UK) [url= http://www.amazon.co.uk/Professional-Microsoft-Server-Programming-Programmer/dp/0470257024/ref=sr_1_1?ie=UTF8&qid=1308567793&sr=8-1%5Dlink%5B/url%5D.

Mike.

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 7

I have the 2K Book as well.

Here is the link to the book (US):

http://www.amazon.com/Professional-Microsoft-Server-Programming-Programmer/dp/0470257024

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

GSquared SSC Guru Points: 260824 More actions · Answer 8

I'm the one who recommended the "go to the store and find some answers" method.

When I was originally learning SQL Server, the "SQL Server Bible" series by Paul Nielsen was what made it possible for me. But that was based on my "get some answers" method, and a different book may be better for you.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 9

Agreed, I usually use the "go to the store and find some answers" method before making a purchase.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/