Dotnet Code can be run in SQLServer in 2005-WHY?

Hi,
I had recently undergone training in YUKON.As the first class begun,i came
to know that in 2005 version,it is possible to execute DOTNET Code in SQL
Server.I was surprised by this. My trainer answered that,it was due to
performance,scalability and many other "ABILITY" terms...
Could someone please give me better answers on this as to why there is a
necesary to run dotnet code inside SQL Server? Any article/URL would be
appreciated greatly.
Thanks,
ShyamSee if this helps:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sqlclrguidance.asp
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Shyam" <Shyam@.discussions.microsoft.com> wrote in message
news:BDA7FB31-094B-4D30-8B94-7257F8CCB272@.microsoft.com...
Hi,
I had recently undergone training in YUKON.As the first class begun,i came
to know that in 2005 version,it is possible to execute DOTNET Code in SQL
Server.I was surprised by this. My trainer answered that,it was due to
performance,scalability and many other "ABILITY" terms...
Could someone please give me better answers on this as to why there is a
necesary to run dotnet code inside SQL Server? Any article/URL would be
appreciated greatly.
Thanks,
Shyam|||Hi Vyas
If I remember well you have promised us to put some .NET code examples on
your site some time ago :-)
We are still waiting for....:-)
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%23v%23vle7eFHA.1404@.TK2MSFTNGP09.phx.gbl...
> See if this helps:
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sqlclrguidance.asp
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Shyam" <Shyam@.discussions.microsoft.com> wrote in message
> news:BDA7FB31-094B-4D30-8B94-7257F8CCB272@.microsoft.com...
> Hi,
> I had recently undergone training in YUKON.As the first class begun,i came
> to know that in 2005 version,it is possible to execute DOTNET Code in SQL
> Server.I was surprised by this. My trainer answered that,it was due to
> performance,scalability and many other "ABILITY" terms...
> Could someone please give me better answers on this as to why there is a
> necesary to run dotnet code inside SQL Server? Any article/URL would be
> appreciated greatly.
> Thanks,
> Shyam
>|||I´ll keep them up on www.sqlserver2005.de domain is still moving to another
provider :-(
Cheers, Jens.
"Uri Dimant" <urid@.iscar.co.il> schrieb im Newsbeitrag
news:eSYnjj7eFHA.256@.TK2MSFTNGP14.phx.gbl...
> Hi Vyas
> If I remember well you have promised us to put some .NET code examples on
> your site some time ago :-)
> We are still waiting for....:-)
>
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:%23v%23vle7eFHA.1404@.TK2MSFTNGP09.phx.gbl...
>> See if this helps:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sqlclrguidance.asp
>> --
>> HTH,
>> Vyas, MVP (SQL Server)
>> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>>
>> "Shyam" <Shyam@.discussions.microsoft.com> wrote in message
>> news:BDA7FB31-094B-4D30-8B94-7257F8CCB272@.microsoft.com...
>> Hi,
>> I had recently undergone training in YUKON.As the first class begun,i
>> came
>> to know that in 2005 version,it is possible to execute DOTNET Code in SQL
>> Server.I was surprised by this. My trainer answered that,it was due to
>> performance,scalability and many other "ABILITY" terms...
>> Could someone please give me better answers on this as to why there is a
>> necesary to run dotnet code inside SQL Server? Any article/URL would be
>> appreciated greatly.
>> Thanks,
>> Shyam
>>
>|||Hi Vyas,
Thanks for the Link.But,it gives a better picture :)
I've another question based on this. I'm not very familier with Dotnet
Coding,since i've be dealing only with SQL Server 2000 as DBA. Now,Yukon has
more support for Dotnet with CLR integration.Can you please tell/advice me,
is it necessary for me to learn about Dotnet to survive in future as a SQL
DBA? If so,upto to what extent should i know in dotnet. I know it might not
be very revelent question,since dotnet is very vast.But,if you can help me in
this regard,it would bemuch appreciated. Thanks in advance.Let me know if any
links are available.
Regards,
shyam
"Narayana Vyas Kondreddi" wrote:
> See if this helps:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sqlclrguidance.asp
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Shyam" <Shyam@.discussions.microsoft.com> wrote in message
> news:BDA7FB31-094B-4D30-8B94-7257F8CCB272@.microsoft.com...
> Hi,
> I had recently undergone training in YUKON.As the first class begun,i came
> to know that in 2005 version,it is possible to execute DOTNET Code in SQL
> Server.I was surprised by this. My trainer answered that,it was due to
> performance,scalability and many other "ABILITY" terms...
> Could someone please give me better answers on this as to why there is a
> necesary to run dotnet code inside SQL Server? Any article/URL would be
> appreciated greatly.
> Thanks,
> Shyam
>
>