Stairway to SQLCLR Level 6: Development Tools Intro

  • Solomon Rutzky

    SSCoach

    Points: 16173

    Comments posted to this topic are about the item Stairway to SQLCLR Level 6: Development Tools Intro

    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

  • Solomon Rutzky

    SSCoach

    Points: 16173

    Many thanks to David Poole for his time and help in peer-reviewing this article (i.e. Levels 6, 7, and 8) :-D.

    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

    As always, a nice article full of valuable content.

    I expect to see a few practical samples down the road, maybe you can open source a few functions in your SQL# project?:-P

  • Solomon Rutzky

    SSCoach

    Points: 16173

    Sorry to not respond sooner, but for some reason I never got a notification that there was a post.

    jeffrey yao (3/1/2016)


    As always, a nice article full of valuable content.

    Thank you for those kind words :-). Hopefully you were similarly pleased with Levels 7 and 8.

    I expect to see a few practical samples down the road, maybe you can open source a few functions in your SQL# project?:-P

    Well, I do strive to be as practical as possible with the examples, but I also need to show the various aspects of SQLCLR while not over-complicating the C# code. But if you have something in mind I will consider it for the following articles.

    As far as open-sourcing SQL#[/url] stuff, I have used a few of them in articles and StackOverflow / DBA.StackExchange answers already. However, there are a few pieces where I got the algorithm from RosettaCode.org[/url] or somewhere similar, and can easily share that stuff. I will look for one of those that would make for a good example here.

    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

    Thanks, Solomon.

    One thing I'd like to see is that I can create a CLR proc, which can connect to other sql servers via SMO, and then get some information I need, such as how many databases and their sizes on those remote sql servers. I believe I tried but failed because SMO cannot be used in CLR (?), I cannot remember the exact errors though. I even tried to write a CLR proc to read Excel files, but I believe I failed as well.

    These days, I simply rely on PowerShell to do my work but I still dream someday, I can use CLR to do the work directly inside SQL Server, from SSMS. 🙂

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Thanks for the article.

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

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