Tuesday, July 14, 2009

Beside writing T-SQL queries does a SQL Server 2005 Administrator needs to know programming?

I was wondering if a SQL Server 2005 Administrator or Developer needs to have a deep knowledge in C# or other NET languages?? I mea n is it required? I was under the impression that SQL %26amp; T-SQL programming and SQL Administratives tasks were the only requirement to apply for a sql server job??





Thanks.

Beside writing T-SQL queries does a SQL Server 2005 Administrator needs to know programming?
In Database System, SQL language doesn't enough, so they provide us with built-in function like TODAY, DECODEDATE, etc. but that doesn't enough either, so we need to build our User Defined Function eg: to count char in one field, to know the size of blob data, etc... and one thing i know is User Defined Functions are build with another programming language like C++ (we can build it with Delphi too , but is not common).





if your job as Administrator is just to maintain, backup and fine-tune the database then you don't need any other programming language except Sql.


but if your job as SQL server application developer, then you need other programming language to interact with Sql server.
Reply:see it totally depends on the requirement. Actually If you are DBA i means SQl Admin u don't require But see sometimes If your Project is engaged with C# based Project using SQl as backend may be then. Even I wonder on that.


No comments:

Post a Comment