T-SQL Development

Question

question

TALENZ asked Mar 11, '15

T-SQL Development

I am throwing out a question for more learned minds than my own. I am wondering if anyone can either recommend a book(s) on developing my T-SQL skills further. In a perfect world, I'd have time to take a class or classes to develop more advanced skills. Since I don't inhabit a perfect world, I'll go with a good book. Since there are so many to choose from, I'd like to solicit advice from this esteemed group. Thanks.

sql-server-2008 personal-development

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey ♦♦ commented · Mar 16, 2015 at 07:24 AM

ASK SQL Server Central runs by you voting. For all helpful answers below, please indicate this by clicking on the thumbs up next to those answers. If any one answer lead to a solution, please indicate this by clicking on the check mark next that answer.

0 ·

Answer 1 · 2015-03-11T15:10:57Z

JohnM answered Mar 11, '15

T-SQL Fundamentals by Itzik Ben-Gan Amazon: http://www.amazon.com/Microsoft-Server-Fundamentals-Developer-Reference/dp/0735658145/ref=sr_1_1?ie=UTF8&qid=1426086579&sr=8-1&keywords=t-sql

5

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

JohnM commented · Mar 11, 2015 at 03:26 PM

I was going to reply with a ;-), but that wasn't enough characters to comment with so I'm typing this long response to ensure that I have enough. And.... ;-)

1 ·

Tim commented · Mar 11, 2015 at 03:13 PM

Ha, you beat me to the book by 20 seconds.

0 ·

sp_lock commented · Mar 11, 2015 at 04:40 PM

There is a newer book that I will be keen to get my hands on http://www.amazon.com/T-SQL-Querying-Developer-Reference-Ben-Gan/dp/0735685045/ref=la_B001IGQENW_1_3?s=books&ie=UTF8&qid=1426091932&sr=1-3

0 ·

Tim commented · Mar 11, 2015 at 04:48 PM

@sp_lock, that is the book I referenced in my answer. Looks to be a great book.

0 ·

sp_lock commented · Mar 11, 2015 at 04:51 PM

@Tim , so you did.. My apologies

0 ·

Answer 2 · 2015-03-11T15:11:46Z

Tim answered Mar 11, '15

Anything from Itzik Ben-Gan or Adam Machanic is good. They have a brand new book that just came out or is just about to come out. Earlier editions of T-SQL Fundamentals is also excellent. Their new book [T-SQL Querying (Developer Reference)]( http://www.amazon.com/T-SQL-Querying-Developer-Reference-Ben-Gan/dp/0735685045/ref=sr_1_2?ie=UTF8&qid=1426086508&sr=8-2&keywords=adam+machanic) is sure to be a hit.

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

@SQLShark commented · Mar 12, 2015 at 08:19 AM

I am looking forward to this one!

0 ·

Answer 3 · 2015-03-11T21:25:30Z

@SQLShark answered Mar 11, '15

I rushed a response last night so here is a better one: Join you local user group - I cannot recommend this more! Attend you local SQL Saturday - Chat to the guys who write the books you read. Attend a larger conference (the PASS summit) Get a Pluralsight subscription (Generally UG have these) there is so much content on there. Take a look at the redgate books - those are great and free in .epub. Watch some of Itzik's videos from previous sessions ([Bits][1]) As the other guys have said read Itzik's books, maybe even book the 70-461 exam for a few months time so you have something to work towards. Have a go at answering the questions that people post on here - even if you dont post your answer just going though the motions will help you develop. Also have fun TSQL is an incredible language! No1 rated language in 2013. [1]: http://www.sqlbits.com/%28S%28ckin5tat3ut34q55gkgc32eo%29%29/Speakers/Itzik_Ben-Gan

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question