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