Deployment of Assemblies to SQLCLR
Today, after having arrived in Durban (South Africa), to do a gig here this coming week, I was going to start a serie of blog-posts about Complex Event Processing (CEP) and Microsoft StreamInsight.
However, as some of you may know, I am fairly interested in SQLCLR (the hosting of CLR inside SQL Server), and it happens from time to time that I try to help out with questions that arises on the forums and newsgroups.
One of the questions that pops up from time to time has to do with how to deploy assemblies which have references to other assemblies when using the Visual Studio “SQL Server Project” project data type.
So I decided to write a small post about it, so that I – in the future – just can point to that post instead of having to repeat it every time.
If you are interested, the post is here.
Hello World
A couple of days ago, I wrote a blogpost about me changing to a self-hosted blog. I also wrote that there might be more announcements regarding this move. So I guess it is time to do that announcement now;
I have started a new venture; SQL Develop, where I and others will do database and .NET development, consulting and mentoring. This does not mean however that I will stop doing work for DevelopMentor, nothing changes in my relation to DM.
I am extremely excited about this new venture, and stay tuned for more announcements!
How-To Article about Calling a WCF Service from SQLCLR
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
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!!
