MS SQL Server - SQL DBA-Is Dotnet 2005 important for me!

Author

SQL DBA-Is Dotnet 2005 important for me!

Shyam

2005-06-17, 8:23 pm

Hi,

I'm a SQL Server DBA and have little knowledge about Dotnet(only Basic
concepts).
I've attended few seminars on Yukon (a.k.a SQL Server 2005) and it seems
that without the help of Dotnet,it would be really tough to survive as a SQL
DBA. My questions are,

1.Is Dotnet compulsory for a DBA in future? How am i getting affected
regarding this?
2. If so, what level of knowledge of dotnet is necessary for me to survive
as DBA?

I would really appreciate,if some body can provide me list of things that i
should follow,if dotnet is compulsory and let me know if any resource/link is
available to upgrade myself for the future..

Thanks,
Shyam

Mike Epprecht \(SQL MVP\)

2005-06-17, 8:23 pm

Hi

It will be as important as knowing T-SQL today.

http://assessment.learning.microsoft.com/test/home.asp

http://www.sqlteam.com/item.asp?ItemID=21927

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Shyam" <Shyam@discussions.microsoft.com> wrote in message
news:0DD5222D-1E53-4E35-9DAB- 97B2F962BBB2@microso
ft.com...
> Hi,
>
> I'm a SQL Server DBA and have little knowledge about Dotnet(only Basic
> concepts).
> I've attended few seminars on Yukon (a.k.a SQL Server 2005) and it seems
> that without the help of Dotnet,it would be really tough to survive as a
> SQL
> DBA. My questions are,
>
> 1.Is Dotnet compulsory for a DBA in future? How am i getting affected
> regarding this?
> 2. If so, what level of knowledge of dotnet is necessary for me to survive
> as DBA?
>
> I would really appreciate,if some body can provide me list of things that
> i
> should follow,if dotnet is compulsory and let me know if any resource/link
> is
> available to upgrade myself for the future..
>
> Thanks,
> Shyam
>

David Browne

2005-06-17, 8:23 pm

"Shyam" <Shyam@discussions.microsoft.com> wrote in message
news:0DD5222D-1E53-4E35-9DAB- 97B2F962BBB2@microso
ft.com...
> Hi,
>
> I'm a SQL Server DBA and have little knowledge about Dotnet(only Basic
> concepts).
> I've attended few seminars on Yukon (a.k.a SQL Server 2005) and it seems
> that without the help of Dotnet,it would be really tough to survive as a
> SQL
> DBA. My questions are,
>
> 1.Is Dotnet compulsory for a DBA in future? How am i getting affected
> regarding this?
> 2. If so, what level of knowledge of dotnet is necessary for me to survive
> as DBA?
>
> I would really appreciate,if some body can provide me list of things that
> i
> should follow,if dotnet is compulsory and let me know if any resource/link
> is
> available to upgrade myself for the future..
>

The short answer is no, coding in .NET is not required. You should be
familiar with the technology and the implications for the administration of
your database, though. For instance .NET code hosted in the database can
process large volumes of data much more cheaply than the same code hosted on
an application server, since the data doesn't have to be transmitted over
the network. On the other hand, the .NET code uses the database servers CPU
resources, so it can be a trade-off. You should be familiar with how to
deploy .NET assemblies on your server and create stored procedures and
functions which are implemented in those assemblies. One big area of .NET
development for SQL Server will be the creation of add-on, utility and
extensibilty functions for SQL Server, and you will definitely want to take
advantage of these.

One area I would advise stongly to investigate is the XML capabilities and
SQL Server Native Web Services. These represent a whole new way to access
the database, and being inherently declarative, schema-based and
data-oriented is well suited to a DBA's skillset. If .NET hosting in the
database represents an expansion of the enterprise application development
folk into the database, Native Web Services are the opposite. Using web
services hosted in the database you can provide a standard, published,
accessable and secure API for the enterprise to access your data. No
database coding is required outside the database, and no knoledge of the
underlying relational schema has to be exposed and synchronized with other
applications. You need some data, you need a whole DAL? Here are a web
services to give you the data. It's an approach which more and more
applications are using, but today the web services have to be hosted on
middle-tier servers and implemented in .NET. With Native Web Services
application programmers don't have to use ADO.NET or ODBC or any other
database API, and they can connect from any platform, (unix, java, .NET,
....). The database becomes just another service providing data.

http://msdn.microsoft.com/library/d...apscenarios.asp

David

Mark Broadbent

2005-06-18, 7:23 am

Maybe, maybe not. I think a lot of scare mongering is going on. I mean is it
necessary for an Oracle admin to know Java? Probably very helpfull to know
just as is a .net language but a stored procedure written via .net (imho)
is not going to be any more effecient than a t-sql sp. For me David's post
is probably more closer to the mark.

Br,

Mark (mcdba, mcad)

"Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message
news:OetLmn5cFHA.1044@TK2MSFTNGP10.phx.gbl...
> Hi
>
> It will be as important as knowing T-SQL today.
>
> http://assessment.learning.microsoft.com/test/home.asp
>
> http://www.sqlteam.com/item.asp?ItemID=21927
>
> Regards
> --------------------------------
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
>
> IM: mike@epprecht.net
>
> MVP Program: http://www.microsoft.com/mvp
>
> Blog: http://www.msmvps.com/epprecht/
>
> "Shyam" <Shyam@discussions.microsoft.com> wrote in message
> news:0DD5222D-1E53-4E35-9DAB- 97B2F962BBB2@microso
ft.com...
>
>

Sponsored Links