Stairway to SQLCLR Level 5: Development (Using .NET within SQL Server)

  • Solomon Rutzky

    SSCoach

    Points: 15964

    Comments posted to this topic are about the item Stairway to SQLCLR Level 5: Development (Using .NET within SQL Server)

    SQL#https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
    Sql Quantum Lifthttps://SqlQuantumLift.com/ ( company )
    Sql Quantum Leaphttps://SqlQuantumLeap.com/ ( blog )
    Info sitesCollations     •     Module Signing     •     SQLCLR

  • Phil Parkin

    SSC Guru

    Points: 243531

    I have never seen all of this written out so concisely before, thank you for the hard work that's gone into this.

    If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

  • Solomon Rutzky

    SSCoach

    Points: 15964

    Phil Parkin (3/11/2015)


    I have never seen all of this written out so concisely before, thank you for the hard work that's gone into this.

    Hi Phil. You are quite welcome. And thank you, not just for being complimentary, but also for this specific compliment. It helps validate my perception that this information, while being terribly important to know, has not been made readily available / accessible. Yet this is what anyone doing SQLCLR work eventually runs into, but usually only after trial and error and then, if they can even find any information on a particular issue, it is uncertain whether it is truly useful or just misinformation. Hence my trying to improve that situation :-).

    Thanks again and take care,

    Solomon...

    SQL#https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
    Sql Quantum Lifthttps://SqlQuantumLift.com/ ( company )
    Sql Quantum Leaphttps://SqlQuantumLeap.com/ ( blog )
    Info sitesCollations     •     Module Signing     •     SQLCLR

  • SumOfDavid

    Ten Centuries

    Points: 1357

    Solomon, you know I'm already a fan, but wow!! I agree with Phil, this article is completely unique across the internet. Anybody considering SQL CLR development should start with your Stairway and this article will be invaluable.


    David

  • Solomon Rutzky

    SSCoach

    Points: 15964

    SumOfDavid (3/11/2015)


    Solomon, you know I'm already a fan, but wow!! I agree with Phil, this article is completely unique across the internet. Anybody considering SQL CLR development should start with your Stairway and this article will be invaluable.

    David, thank you very much. I (and my wife 😉 ) greatly appreciate hearing that the time and effort spent on gathering the info, organizing it, writing it up, coming up with representative examples, testing those, etc is fulfilling the intention of providing help and clarity to hopefully improve the quality of SQLCLR projects.

    Thanks and take care,

    Solomon...

    SQL#https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
    Sql Quantum Lifthttps://SqlQuantumLift.com/ ( company )
    Sql Quantum Leaphttps://SqlQuantumLeap.com/ ( blog )
    Info sitesCollations     •     Module Signing     •     SQLCLR

  • jeffrey yao

    SSCarpal Tunnel

    Points: 4244

    Really love this SQLCLR series. Many thanks Solomon for your hard-work.

  • Solomon Rutzky

    SSCoach

    Points: 15964

    jeffrey yao (3/13/2015)


    Really love this SQLCLR series. Many thanks Solomon for your hard-work.

    Hi Jeffrey. You are quite welcome. And thank you for sharing that :-).

    Take care,

    Solomon..

    SQL#https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
    Sql Quantum Lifthttps://SqlQuantumLift.com/ ( company )
    Sql Quantum Leaphttps://SqlQuantumLeap.com/ ( blog )
    Info sitesCollations     •     Module Signing     •     SQLCLR

  • fw200811

    SSC Journeyman

    Points: 80

    Great job Solomon. Many advanced topics not found anywhere else.

    Thus, I've not found a solution to my problem.

    I would like to manage windows local groups on server through SQLCLR. I deploy my signed assembly using asymmetric key, login with this key, setting UNSAFE...

    I added the .net assemblies : System.DirectoryServices.

    My C# code works perfectly in console logged as administrator.

    The same code in stored procedures, with impersonnation, always give me "Access Denied"

    Any ideas to solve that?

    Thanks.

  • Phil Parkin

    SSC Guru

    Points: 243531

    fw200811 (4/3/2015)


    Great job Solomon. Many advanced topics not found anywhere else.

    Thus, I've not found a solution to my problem.

    --snip

    Thanks.

    Rather than hijacking this thread, I suggest you start another.

    If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

  • JediSQL

    SSCommitted

    Points: 1896

    Hi,
    Is there any possibility of the "The .NET Environment" table being updated to through SQL Server 2016 (and maybe even 2017)?

    Sincerely,
    Daniel

Viewing 10 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply