Post reply

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

  • March 11, 2015 at 12:03 am

    #295858

    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 Lift — https://SqlQuantumLift.com/ ( company )
    Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
    Info sites — Collations     •     Module Signing     •     SQLCLR

  • March 11, 2015 at 1:57 am

    #1783143

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

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • March 11, 2015 at 8:45 am

    #1783316

    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 Lift — https://SqlQuantumLift.com/ ( company )
    Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
    Info sites — Collations     •     Module Signing     •     SQLCLR

  • March 11, 2015 at 2:48 pm

    #1783450

    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

  • March 11, 2015 at 3:50 pm

    #1783463

    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 Lift — https://SqlQuantumLift.com/ ( company )
    Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
    Info sites — Collations     •     Module Signing     •     SQLCLR

  • March 13, 2015 at 12:08 pm

    #1783962

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

  • March 17, 2015 at 2:00 pm

    #1784591

    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 Lift — https://SqlQuantumLift.com/ ( company )
    Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
    Info sites — Collations     •     Module Signing     •     SQLCLR

  • April 3, 2015 at 2:38 am

    #1788463

    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.

  • April 3, 2015 at 2:51 am

    #1788464

    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 you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • June 6, 2017 at 11:43 am

    #1945671

    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 9 (of 9 total)

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