September 26, 2008 at 6:50 am
As the lead developer for our (small) company, I am too often pulled into customer support calls for troubleshooting potential data problems. Often, the problem is one that has been seen multiple times at different customer sites, yet I still get called on by our support staff to do the basic diagnostics. It would be nice if our support staff had some beginner to intermediate T-SQL skills so that they could do the ground work and potentially solve the problem without my involvement.
Our company is small and we don't have much of a budget for training. Can anyone suggest a good beginner to intermediate book for learning T-SQL in the context of MS SQL Server 2005?
:crazy:
September 26, 2008 at 7:31 am
i can recommend these books:
Beginning Transact-SQL with SQL Server 2000 and 2005
byPaul TurleyandDan Wood
Wrox Press 2006 (594 pages)
ISBN:076457955X
Robert Vieira
Beginning SQL Server™ 2005 Programming
Copyright © 2006
September 26, 2008 at 7:35 am
many people say that O'REilly books are the best, and I tend to agree sometimes; thisis one of their latest ones on SQL:
Learning SQL on SQL Server 2005
By Sikha Saha Bagui, Richard Walsh Earp
...............................................
Publisher: O'Reilly
Pub Date: April 2006
Print ISBN-10: 0-596-10215-1
Print ISBN-13: 978-0-59-610215-9
Pages: 342
TIP: go to http://www.isohunt.com and search for the books' titles there. Find them , then follow instructions.
September 26, 2008 at 8:19 am
I'd suggest Itzik Ben-Gan's Inside SQL Server 2005: TSQL Querying. That's a great source for really learning how TSQL works and how to apply it to a lot of real world situations. If they get past that, there's also the TSQL Programming book from the same series. It focuses on the next level, cursors, transactions, views, exceptions, dynamic sql, etc.
"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
September 26, 2008 at 11:28 am
I'd recommend Itziks' books. If they get too complicated, move to the next section, but he does a great job going over things.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply