March 4, 2010 at 11:25 pm
Dear All,
I have a doubt.
Does a DBA need to learn dot.net language. ?
Thanks.
March 4, 2010 at 11:33 pm
Any extra knowledge is always a bonus, and learning .NET will increase your chances of understanding how applications use SQL as a back-end.
I have seen many job requirements for SQL Dev's, who actually require them to know a bit of .NET, but not always a fixed requirement.
Knowing .NET will seperate you from a normal SQL Developer, and it wont hurt knowing the other side....
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 4, 2010 at 11:35 pm
It depends on whether you need to or not.
Will it be beneficial - sure.
You can apply what you learn in .Net to CLR procedures and to SSIS packages. Both can be quite beneficial for the development dba.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 4, 2010 at 11:36 pm
Thanks for the quick respose, You are right.
But, has it become essential now a days .?....
March 4, 2010 at 11:41 pm
I can tell you that a bare minimum ability to understand at a basic level is necessary. Being able to look at .Net code and understand what it is trying to accomplish is necessary. That doesn't mean you have to be know it perfectly - but be able to follow the logic and understand what is happening inside the code.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 4, 2010 at 11:42 pm
Personally, I want to say yes, but it depends on where you want to go with SQL development, maybe into BI? then, YES.
Also depends on the needs of te current employer, and future developments.
Do it for yourself, you might need it one day.
😉
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 4, 2010 at 11:48 pm
Henrico Bekker (3/4/2010)
Personally, I want to say yes, but it depends on where you want to go with SQL development, maybe into BI? then, YES.Also depends on the needs of te current employer, and future developments.
Do it for yourself, you might need it one day.
😉
Sound advice
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 8, 2010 at 7:46 pm
Yes, but you have to know when to use SQL and when to use .net.
SQL is still the language of choice for set based operations while
.net is useful for things you cannot accomplish easily with SQL. For example I have found .net to be invaluable in SSIS when you want to call external dlls.
Computer Consultant
Business Computer Innovations, LLC
Offering the best in Database Administration, Development and Systems Analysis
www.BusinessComputerInnovations.com
March 8, 2010 at 7:57 pm
That depends. Do you want to be able to read the SQL CLR assemblies that the developers are going to want to put on your databases or not? Personally, I would want to, but that's just me. 🙂
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 8, 2010 at 8:41 pm
Yes, you should, even if it is just being able to read it and understand what is happening. There are several languages I don't even have basic coding skills in but I can read them and get 98% of what is happening, the other 2% is the nuances, which a good coder should have noted in comments.
It never hurts to know it. For SSIS there are some things that are not easily accomplished with the available tools and in general I don't like to use 3rd-party tools unless they are really necessary. I absolutely want to be able to read any SQLCLR code that comes my way, if for no other reason to quiz my developers why they didn't use T-SQL for this or that function..
CEWII
March 9, 2010 at 3:44 am
Thank you all.
I have coded in dotnet previously. Then letf it and decided to focus only on SQL DBA as am very much interested in it. But then again I feel knowledge of dotnet is essential...
I doubt role of SQL Developer has become insignificant in dotnet applications...
March 9, 2010 at 9:38 am
You're welcome.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 10, 2010 at 1:52 am
Yes. Of course you do. Sorry to be so definite about this, but I've lost count of the times that I've found that measure of skill in various .NET languages has been an advantage to me when working as a DBA. For example, SMO provides the easiest means of automating a lot of routine tasks and it is now impossible to avoid the use of a NET language to do it.
Best wishes,
Phil Factor
March 10, 2010 at 6:30 am
Thank you somuch.
Gonna brush up dotnet again.
March 15, 2010 at 7:54 am
PowerShell is built on top of the .NET framework. I expect that Powershell will take off as a management tool / API of choice for managing SQL Server, in the same way it has already done for Exchange. When that happens familiarity with the .NET framework will be very useful because if you start using PowerShell then sooner or later you will need know more about the underlying classes. The framework is a huge topic and I believe that investing some time in it now will pay off later.
Viewing 15 posts - 1 through 15 (of 29 total)
You must be logged in to reply to this topic. Login to reply