TSQL Programming Book

Question

Post reply

TSQL Programming Book

christa.reisert

SSC Rookie

Points: 26
More actions
May 26, 2010 at 7:44 am

#221605

I need a recommendation on a TSQL Programming book. I am new to sql server, but have worked with oracle for many years. So, I don't need a beginners book that explains how to write queries, but one that is more focused on Stored procedures, triggers etc. Any suggestions would be much appreciated.
Thanks,
Christa

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

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

ColdCoffee SSC-Dedicated Points: 39972 More actions · Answer 1

One of the excellent book:

Inside Microsoft SQL Server 2005: T-SQL Querying by Itzik Ben-Gan

Link : http://www.amazon.com/Inside-Microsoft-SQL-Server-2005/dp/0735623139

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 2

I prefer "Three Men in a Boat (To Say Nothing of the Dog)" by Jerome K. Jerome.

Oops, it is nothign to do with T-SQL, sorry.

😀

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

ColdCoffee SSC-Dedicated Points: 39972 More actions · Answer 3

elutin (5/26/2010)
I prefer "Three Men in a Boat (To Say Nothing of the Dog)" by Jerome K. Jerome.
Oops, it is nothign to do with T-SQL, sorry.
😀

😛 :hehe:

RTaylor2208 SSChampion Points: 13298 More actions · Answer 4

I would second the Inside SQL Server books, excellent reference books, but a word of warning the first 2 / 3 chapters in the T-SQL programming and T-SQL Querying books are very heavy going as they are more about how the database engine processes queries, this is very worth while knowing once you have a bit more experience in coding but can really put you off if you havn't coded much in T-SQL.

MCITP SQL 2005, MCSA SQL 2012

christa.reisert SSC Rookie Points: 26 More actions · Answer 5

ColdCoffee, thanks for your suggestions, I'll check it out.

elutin, I think I'll check yours out too. :laugh: I do love a good book!

RTaylor2208, thanks for your advice, I'll keep it in mind when I get started.

Thanks,

Christa

Grant Fritchey SSC Guru Points: 398909 More actions · Answer 6

Another vote for Itzik's excellent book.

You might also want to check out Joe Sack's "Transact SQL Recipes." It's just a very straight forward listing of possible T-SQL solutions for common problems, questions, and issues.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Garadin One Orange Chip Points: 29613 More actions · Answer 7

I really need to write the blog post I was going to do on this, but in the interim, I'd have to also lend my vote to Itzik's book(s). The entire inside sql server series is phenomenal.

Seth Phelabaum

Consistency is only a virtue if you're not a screwup. 😉

Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

Ray Dai SSCommitted Points: 1548 More actions · Answer 8

Jumping on the bandwagon: I've read "Microsoft SQL Server 2008 T-SQL Fundamentals" by Itzik. It is one of the best SQL books I've ever read. Even though the title says fundamentals, I found the book filled in a lot of holes in my knowledge.

The author is excellent in anticipating questions and go into the details that won't matter for a beginner but critical for someone who is trying to understand the whys. If I read his book first I wouldn't have posted couple of the questions I did on this forum. 😛

p.s. quoting from Inside Microsoft SQL Server 2008: T-SQL Programming

If you are new to the SQL language you should start with the earlier published book, Microsoft SQL Server 2008: T-SQL Fundamentals. If you are new to SQL Server but you have used other SQL supporting products you may want to start with the companion book Inside Microsoft SQL Server 2008: T-SQL Querying. But you can jump right into this book as well; it will give you great insight into SQL Server—specific programming. You can use the examples in the book to find out whether you need to study specific statements where SQL Server has a different implementation from your previous experiences and you can use these books for reference.