February 29, 2016 at 9:23 pm
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 Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
February 29, 2016 at 11:56 pm
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 Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
March 1, 2016 at 11:55 am
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
March 3, 2016 at 10:33 am
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 Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
March 3, 2016 at 4:40 pm
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.
March 10, 2016 at 4:22 pm
Thanks for the article.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy