| Author |
Topic |
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
 Posted - 2008-03-25 : 17:25:08
|
Guys ..Im a very very confused  Jr DBA/Dev here !I need to know what exactly other languages [C#/VB.net/ADO/XML/ASP.net..etc] that I should learn in order for me to be able to excel in SQL Development.I started getting my hands dirty with some SSIS / SSRS & SSAS, but inorder for me to handle situations such as [Find if file exist in ftp before loading, Checking a certain row of a data file before processing/ Zipping and Unzipping data files and etc...] What should I need to know well in order for me to add more value to my skills?I would like to learn 1 language and master it pretty well.What are your suggestions?And what is this CLR that is being talked about ?Does it use other language besides SQL?Do guide this lost JR ....... |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-25 : 18:41:31
|
| Tell us more about your job. What are you responsible for as a Jr DBA/Developer? Will you be doing any front-end developement?At the very least, I'd suggest having a basic understanding of either C# or VB.NET so that you can write CLR code if needed. The most important skill set for a SQL developer is T-SQL though.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2008-03-26 : 01:56:41
|
| I am learning asp at the moment. Accessing and updating databases via web pages is an active area at the moment.e4 d5 xd5 Nf6 |
|
|
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
Posted - 2008-03-26 : 09:08:39
|
| At the moment I am involved in both DBA and Dev task.There are some projects that require[as far as I know] ..asp / vb @ C#.Most of my Sr have either 1 of the above.Are these imp for me to do CLR programming?Which language would you suggest as I am eager to start learning.Do I need to know anything else apart of these.How could I also practise/improve my T-SQL skills?Thank You! |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2008-03-26 : 09:15:00
|
| Bindman/LOOKUP_BI -- When you are saying "ASP", I hope you mean ASP.NET. I would not waste any time learning ASP. It is crude and sloppy and obsolete and it will cause you to form bad programming habits and make your life more difficult while using it. ASP.NET is the way to go, with true compiled, strongly typed languages (VB, C#, etc), a real robust library of classes and controls, and a powerful development environment. ASP was great in its day, but it's a limited web scripting framework; asp.net is a true web programming framework.- Jeffhttp://weblogs.sqlteam.com/JeffS |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-03-26 : 09:18:06
|
| or maybe not...asp.net web forms as they are now are way to complicated that they should be.they're trying to emulate a state based page to page mechansim when the underlying protocol is stateless...but in the MS world it's the best for now.asp.net MVC is coming.. but it'll be some time._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2008-03-26 : 10:18:14
|
| asp.nete4 d5 xd5 Nf6 |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2008-03-26 : 10:30:17
|
| Glad to hear that, blindman!Spirit -- I think ASP.NET is excellent as is, MVC is just another option. There is nothing inherently wrong with Viewstate, you can store in multiple ways (hidden inputs, session, sql database, etc) and it works really well. Like anything, it can be abused or use poorly, but I don't think there is anything wrong with its implementation. I don't see a fundamental flaw in "maintaining state when the protocal is stateless", since web apps need to maintain state somehow from page to page to function, right? MVC uses the same web protocol as asp.net, right? It's just a different way of handling things.- Jeffhttp://weblogs.sqlteam.com/JeffS |
|
|
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
Posted - 2008-03-27 : 11:41:25
|
| Thank You all, for your opinions and suggetions.I thought of doing some reading to understand both C# and VB.net and then proceed further with the one I'm most comfortable with.Do let me know if there are any other areas/languages/skills that I would need to consider.Appreciate your feedbacks. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-03-27 : 12:22:20
|
| maybe powershell scripting language based on .net... since this will be popular in sql 2008._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-03-28 : 09:43:07
|
| As well as t-sql , it depends on the environment you're working on - e.g Java, .Net etcJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
|
Other Programming Skills- CLR