Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Solomon Rutzky Stairway to SQLCLR Level 1: What is SQLCLR? RE: Stairway to SQLCLR Level 1: What is SQLCLR?

  • January 9, 2014 at 2:41 pm

    #1678983

    currentp (1/9/2014)

    Great Article. I have been writing SQL Server external objects since 2007 and I have developed some best practices that work for me. You talked on most of them and I wanted to elaborate at bit on one of them.

    Do as much of the operation in T-SQL that you can and write small external objects (SQLCLR tasks) to perform the tasks that cannot be done in T-SQL.

    ...

    I hope my trial and errors help someone.

    Hi there. Thank you for the compliment and I am glad you enjoyed the article. Thank you also for sharing your experience with the community as I think it is very helpful to see the practical side of these issues and that some of these decisions can be rather impacting on our systems.

    I do feel bad though, that you ever had to do COM / OLE Automation programming. I never have done anything with COM and have rarely ever used the sp_OA* procs, so it is also nice to see some of the issues there.

    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