sql stored procedures books articles

Question

User1468341083 posted

First of all I would like to wish everyone a happy new year! I really am excited to see visual studio 2010 will be out in the next couple months!

Please let me explain my comment, I recently went into the bookstore I was looking for a good book about sql  "stored procedures"(I wish to use this as a good training ground for linq, wcf, silverlight, entity framework) Is it just me but alot of these books did not even mention the table adapter query configuration wizard   Please see this tutorial.  on this wizard     http://www.asp.net/learn/data-access/tutorial-67-vb.aspx

http://www.asp.net/learn/data-access/tutorial-75-vb.aspx also see this tutorial

on manual sql stored procedures

I would appreciate any help anyone could give me on a good book or tutorials

 

on using sql stored procedures as a training ground for using linq and entity framework, wcf. The book should concentrate on sql stored procedures

I already own a wcf book, sivlerlight  and I will look into a linq book as well

Is it just me or why isnt their more books or article mentioning

sql injection attacks and a good book about sql stored procedures

All of these books seem to be a bit out of date... I just believe the quality

of books should be updated a bit more Thank you for listening to me

rant and rave. If you can find any articles books on sql stored procedures

showing how to do it the right way) would be appreciated....Thank you           

  

Answer 1

User-319574463 posted

Try http://www.murach.com/books/sql8/index.htm

Murach's SQL Server 2008 for Developers
by Bryan Syverson and Joel Murach
22 chapters, 778 pages, 336 illustrations
ISBN: 978-1-890774-51-6
List price: $52.50; SAVE 30%, now just $36.75

For further help on SQL Server, you can ask at:

• SQL Server Team http://www.sqlteam.com/forums/
• SQL Server Central http://www.sqlservercentral.com/
• SQL Server at MSDN http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=19&SiteID=1
• SQL at TEk-TIPS http://tek-tips.com/threadminder.cfm?pid=183&page=1

Answer 2

User1468341083 posted

I appreciate your help and unfortunately this book is too generalized and  not what I am looking for,Thank you anyway  The  book that I am looking for is a book that will solely concentrate on t-sql or stored procedures, not anything else

Let me explain my list

1 An excellent t-sql or stored procedures book I was thinking michael coles or joseph sack's book on t-sql  (I need a  real meat and potatoes foundational book )I wished these books would have covered the uses of tableadapters 

2  a linq book

3 entity sql book(julia lerman has an excellent writing style and I will wait for second edition) 

4 a excellent sql administration book covering both asp.net win forms etc

THese book must build upon each other for a strong foundational purposes

for wcf silverlight wpf etc

THank you for your help

Answer 3

User1468341083 posted

 I finally have come out with my own list

t-sql using stored procedures-pro t-sql programmers guide Michael coles(apress)

http://www.amazon.com/T-SQL-2008-Programmer-rsquo-Guide/product-reviews/143021001X/ref=cm_cr_dp_all_helpful?ie=UTF8&coliid=&showViewpoints=1&colid=&sortBy=bySubmissionDateDescending 

2 sql administration Microsoft sql server 2008 Management and Administration

by ross mistry Sams

http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X/ref=sr_1_1?ie=UTF8&s=books&qid=1262750356&sr=8-1

Answer 4

User1468341083 posted

2 continued coming in a close second was william Stanek sql 2008 administration (microsoft press)

 pocket consultant http://www.amazon.com/Microsoft-Server-Administrators-Pocket-Consultant/dp/0735625891/ref=cm_lmf_tit_10_rsrsrs0

3 My linq book is due out Later this year By Joseph Rattz- ProLinq (apress) http://www.amazon.com/Pro-LINQ-Language-Integrated-Query/dp/1430226536/ref=sr_1_16?ie=UTF8&s=books&qid=1262750850&sr=1-16

4 My entity framework choice  is julia lerman's entity framework oreillydue out april 2010 or later I wish someone would comment and has anyone read these books

Please let me know if you have read these books thank you.....