Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 The Yak Corral
 Book Suggestions?

Author  Topic 

JAdauto
Posting Yak Master

160 Posts

Posted - 2005-12-02 : 23:27:31
This forum has always been my best solution for problems I have and I thank you all so much. My company has spent the last 4+ years re-writing all of our applications in VB6 with SQL backend. We are about to wrap this major project up, and now will be spending the next XX time upgrading and converting all of those same apps to vb.NET and SQL2005. I have been coding in VB6 for... probably 6 or 7 years. I have no idea what I am about to get into, so I need to do some serious reading. I searched Amazon and the number of books is overwhelming. I was wondering if anyone has any suggestions of books that have worked for you or provided anyone with good info. Any suggestions at all will certainly help.

Thanks so much,
JAdauto

activecrypt
Posting Yak Master

165 Posts

Posted - 2005-12-03 : 06:49:31
Hi,
these are reference FYI :

http://www.sql-server-performance.com/images/hasan_tu_performance_tuning_ch7.pdf
http://www.sql-server-performance.com/reviews.asp

http://vyaskn.tripod.com/microsoft_dot_net_books.htm
http://vyaskn.tripod.com/top_15_sql_server_books.htm




Andy Davis
Activecrypt Team
--------------------------------------------
SQL Server Encryption Software
http://www.activecrypt.com
Go to Top of Page

Sitka
Aged Yak Warrior

571 Posts

Posted - 2005-12-03 : 18:15:13
Actually your timing is pretty good, considering. I've spent time on .Net1.x and some key aspects of that were lacking(ex the table adapter). You can avoid those on 2.x. The struggles are huge to switch the brain back and forth between relational database thoughts and Object Programming (plus throw in a little procedural stuff to). It's all about time at the wheel, dive into a huge impossible module and whenever you get stuck fight until your stomache hurts then take a day break and just read. David Sheepa's ADO.Net book gave me great help. It acted as a translator for me between the trivial "how to's of much of the "walk throughs" And the system focus thought process that always seemed to plague me when trying to get things done (how does this work, how will it fit in, when will it let me down)

I started with http://www.joegrip.com/csharp-course.html , now I think most of this stuff is probably recreated for free elsewhere but his stuff was good and it at least gave you the impression that you could make sense out of the OOP lingo (yeah right, it's real hard polymogorphism, interfaces, scope, private public,static, encapsulation it never ends). A week long investigation into the Microsoft Enterprise Library (R/D project) was a huge conceptual help to.
I had scripted asp(VB/Java/WSH) Developed foxpro and VB6 but C# is my favourite syntax and I'm glad I went with it. Most with 6 years VB6 would have no need to do that I just jonesed to go there. Probably more help/examples in VB.NET to. but I like being able to read VB and understand it but write in C# (this may come back to hurt with (SSIS the new DTS). I don't now if it is good to recommend the approach I took which was to use Vs.Net and not let any of the code it generates go uninvestigated. It certainly made things much more confusing but I'm glad I did it that way now. I have a bunch of books that have barely been opened but that is more a fact of one guy many hats and they just never got the time they deserved. But all in all a year of fits and starts got me to the point where I'm making serious progress (ugly but advancing) on a complex UI(Windows.Forms) and multi database integration module, and can write fairly complex web forms.

So those were my big three, JoeGrip, David Sceppa, Enterprise Library.

This is the best place for SQL stuff, the committment to think SQL dosen't come from a book but most will at least give a nod to ken henderson, kalen delaney.

"it's definitely useless and maybe harmful".
Go to Top of Page
   

- Advertisement -