SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Stairway to SQLCLR Level 6: Development Tools Intro


Stairway to SQLCLR Level 6: Development Tools Intro

Author
Message
Solomon Rutzky
Solomon Rutzky
SSCertifiable
SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)

Group: General Forum Members
Points: 5979 Visits: 3084
Comments posted to this topic are about the item Stairway to SQLCLR Level 6: Development Tools Intro

SQL# - https://SQLsharp.com/
Sql Quantum Lift - https://SqlQuantumLift.com/
Solomon Rutzky
Solomon Rutzky
SSCertifiable
SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)

Group: General Forum Members
Points: 5979 Visits: 3084
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/
Sql Quantum Lift - https://SqlQuantumLift.com/
jeffrey yao
jeffrey yao
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1841 Visits: 911
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
Solomon Rutzky
SSCertifiable
SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)

Group: General Forum Members
Points: 5979 Visits: 3084
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# 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 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/
Sql Quantum Lift - https://SqlQuantumLift.com/
jeffrey yao
jeffrey yao
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1841 Visits: 911
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. :-)



Iwas Bornready
Iwas Bornready
SSC-Dedicated
SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)

Group: General Forum Members
Points: 34844 Visits: 886
Thanks for the article.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search