sql stored procedures books articles RSS

• • Reply
  

  billsm

  Member

  462 Points

  220 Posts

  sql stored procedures books articles

  Dec 31, 2009 07:59 PM|LINK

  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           

    

  • Moved by Mikesdotnetting on Dec 31, 2009 08:07 PM
  • Edited by billsm on Dec 31, 2009 10:14 PM
• • Reply
  

  TATWORTH

  All-Star

  72415 Points

  14017 Posts

  MVP

  Re: sql stored procedures books articles

  Jan 03, 2010 07:12 PM|LINK

  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

  
  

  Click "Mark as Answer" on the post that helped you.
  This earns you a point and marks your thread as Resolved so we will all know you have been helped.
  FAQ on the correct forum http://forums.asp.net/p/1337412/2699239.aspx#2699239
• • Reply
  

  billsm

  Member

  462 Points

  220 Posts

  Re: sql stored procedures books articles

  Jan 05, 2010 12:37 PM|LINK

  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

  • Edited by billsm on Jan 05, 2010 12:40 PM
  • Edited by billsm on Jan 05, 2010 12:49 PM
  • Edited by billsm on Jan 05, 2010 12:50 PM
• • Reply
  

  billsm

  Member

  462 Points

  220 Posts

  Re: sql stored procedures books articles

  Jan 06, 2010 03:03 AM|LINK

   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

• • Reply
  

  billsm

  Member

  462 Points

  220 Posts

  Re: sql stored procedures books articles

  Jan 06, 2010 03:15 AM|LINK

  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..... 

  • Edited by billsm on Jan 06, 2010 03:16 AM
  • Marked as answer by billsm on Jan 28, 2010 07:38 PM