This may be slightly off topic for this site, but it seemed a good place to start.
I have a fair bit of experience as a DBA, and I have dabbled with ASP.NET before but only in a very basic sense. Now I find myself being the prime developper for what should be a fairly simple project. I need to create a website with a SQL Backend that tracks trouble tickets. It needs to display all previously entered trouble tickets in a grid with a link to go to a page where the full details can be viewed.
I have the database set up, normalized, and basic maintenance automated. That was easy, but now I am struggling with setting up the front end. This has also made me realize that it is time to properly learn ASP.NET or something similar.
So, for someone starting as a SQL Server DBA, I am looking for both tutorials that will help me get this initial project off the ground quickly and then for more thorough resources to learn to deal with seb development. Any suggestions?
asked Nov 18 '10 at 11:31 AM in Default
If you developed Windows apps before then ASP.NET will initially be a shocker due to the stateless nature of the HTTP protocol. Ajax, Silverlight, WPF add a lot of noise and to try to cover this simple fact, but it cannot be hidden, the protocol is stateless.
The good news is that it is extremely easy to very quickly get up to speed with creating professionally looking presentation layer, much easier than with WinForms or even WPF.
I think that many people will agree with this simple approach to find the best books on the subject: look for Apress books. Many are written by ex-Wrox guys, so essentially, Apress and Wrox offer the same quality. Within those books, look for as few faces/author names as possible. If you see one name then the odds are that the book is great, if you see too many faces/author names then the book is terrible. If you know almost nothing about the subject, read Beginning series, otherwise opt for Professional. Beginning series can be somewhat misleading as they are not really for beginners, I mean you can still learn a great deal from them. For the reasons above, this book by Matthew MacDonald tends to stand out as a very decent choice.
This site could be a good resource as well. This is true that many contributors are DBAs, but in nowadays it is not really possible to be a classic DBA who only works with databases, so we do have guys who are very good ASP.NET experts (consider, for example, Matt Whitfield's site). We also have a plenty of devs and .NET junkies here, myself included :)
Just my 2 cents.
answered Nov 18 '10 at 12:22 PM
Its been a while since I used ASP.Net and needed to look for assistance (mainly as the dev work I have been doing is VERY low level) but these guys have helped me from the days of Classic ASP onwards - http://www.4guysfromrolla.com/
answered Nov 19 '10 at 01:18 AM
I have - before finding ASL SSC - been active in the SQL Server related discussion forums over at www.asp.net. I think that's a very good resource, with tutorials from entry level and on. Forums are active and you'll quickly get response to questions. Lots of walk-through video material etc.
answered Nov 19 '10 at 01:23 AM
Oleg, as usual, has an excellent answer. But one option to give you a good head start might be to use something like IronSpeed to generate the app layer, and have a look and learn.
Personally I always work better by learning from example - so IronSpeed would give you something whereby you would have an example to learn from. I probably wouldn't suggest actually using it, just using it to generate you an example.
answered Nov 19 '10 at 02:45 AM
Matt Whitfield ♦♦
Obviously having a strong database background it would probably make more sense to start with something like Microsoft's Dynamic Data Web. There's plenty of info on the interweb, e.g. http://weblogs.asp.net/scottgu/archive/2007/12/14/new-asp-net-dynamic-data-support.aspx from a quick google. Point it at your ORM (LinqToSql, EF) and press the go button. What you will get out of the box is some website scaffolding that gives you a running application right away based on your data model. From there you can customise and add custom pages if required.
I may be preaching to the converted but the other important thing you need is good source control and regular snapshots to ensure you can always get back to a last known good.
answered Nov 22 '10 at 11:23 AM