Archive for February, 2009

Hosting of Code Samples

February 12, 2009

The other day when I posted about the sample how to call a WCF Service from a SQLCLR method, I mentioned that I had no place to host my demo-code. I did not want to create a project on CodePlex (like I did with the SQLCLRProject), as demo code is not really projects per se.

I discussed this with David Reed from Microsoft who is a PM on the SQL Server team, and has a lot to do with overseeing the SQL projects on Code Plex. He mentioned MSDN’s Code Gallery, which is a place where you can create resource pages and upload code for download. So, earlier today I created a new resource page on the Code Gallery, and uploaded the SQLCLR to WCF sample to there. My intention is to upload other SQL Server related samples as well as How-To articles to there.


How-To Article about Calling a WCF Service from SQLCLR

February 8, 2009

I sometimes (not as much as I would like) hang out at some of the user forums where people talk about SQL Server generally and the SQLCLR specifically. Ever so often the question is being asked how to call into a WCF service from SQLCLR (.NET code running inside SQL Server).

The other day I became tired of giving exactly (or thereabout) the same answer for the n:th time, so I decided to croft up some code and write a mini How-To about how to call into a WCF service from SQLCLR. So without any further ado, the How-To article can be found here. I do not have anywhere to host the code yet (my usual hosting place disappeared – don’t ask), so until I decide where to host you can drop me an email if you want to see the code.

Update: I have now created a Resource Page on MSDN’s code gallery, where the sample code for the article can be found. So if you want to get the code, go to here.

New Home for SQLCLRProject

February 7, 2009

About a year ago, I wrote how I were about to re-surrect the SQLCLRProject tool, and in that process I created some new pages for it here at my WordPress blog.

This tool has had some interest, and it seems that quite a few of you are interested in helping out to take it forward. So due to that, and the fact that there are issues where I hosted it for download, I have today created a CodePlex project for it. You can find its new homepage here.

At the moment there are no source code there, just the binaries. I am in the process ofcleaning up the source code, and as soon that is done – I will upload it there as well.

So, go over there and have fun!!