Browse by Tags

SqlClrProject version 2.6 Released

I have just released a new version - 2.6 - of the deployment tool for SQLCLR assemblies. It is a minor release, but it implements some changes that are fundamental for coming versions and also fixes a couple of minor bugs. The download page for it is here , and if you want general information about what...

Posted to Niels SQL Server Blog (Weblog) by nielsb on Wed, Feb 27 2008
Table Valued Methods on Type

I amd really getting into the use of UDTs as a way of packaging up SQL CLR code. I'm also looking into implementing an array type so I can do code like declare @s dbo . SQLArray set @s . AddKeyword ( 'sas' ) set @s . AddKeyword ( 'dog' ) Fo this to be realy useful you would want to...

Posted to Simons SQL Blog (Weblog) by simonsabin on Fri, Feb 15 2008
Update of SQLCLRProject

I’ve had some feed-back about SQLCLRProject (thanks Doug et al!), and based on that fixed some issues. Read all about it, and get the updates on the download page . As always, comments and suggestions for improvements are very welcome!! Niels

Posted to Niels SQL Server Blog (Weblog) by nielsb on Wed, Jan 30 2008
Like Phoenix Rising ... or New Version of SQLCLRProjct

Hi everyone, it’s been a while (shame one me!)!! As some of you may know, back in the days I developed a tool for deploying .NET assemblies to SQL Server 2005 (or, as it was called then, Yukon). Initially it was just a tool used from the command line. As time went by, it evolved into a project named...

Posted to Niels SQL Server Blog (Weblog) by nielsb on Mon, Jan 14 2008
SQL Server 2008 Spatial - Using it in .Net code

So you want to use the SqlGeometry and SqlGeogrpahy collections in .Net. I found the lack of friendly collection based properties and methods suprising, i.e. no iterators, no collections which you can add to.( http://sqlblogcasts.com/blogs/simons/archive/2007/12/09/Katmai-Spatial---First-thoughts.aspx...

Posted to Simons SQL Blog (Weblog) by simonsabin on Mon, Dec 31 2007
Katmai Spatial - What's a geometry

Following on my previous post on discovering the spatial types I mention that one of the aspects to understand is the different types of geometries. Point Fairly this is obvious its a single spot that has an X and a Y co-ordinate. Multi Point A group of points that are not connected. (if they were connected...

Posted to Simons SQL Blog (Weblog) by simonsabin on Sun, Dec 9 2007
Katmai Spatial - First thoughts

I've been doing some work with the Spatial types in Katmai and these are my first thoughts. The first thing is that the data type is the same used by SQL as used in your .Net code. So what does that mean, · You use the same methods, which is great from a familiarity perspective · When calling the...

Posted to Simons SQL Blog (Weblog) by simonsabin on Sun, Dec 9 2007
CREATE ASSEMBLY Permissions - Could not obtain information about Windows NT group/user

If you encounter this Could not obtain information about Windows NT group/user <MyDomain>/<MyName>, error code 0x5. When you try and CREATE an ASSEMBLY, you might think well I'm not connected as that user. The user it sqawks about is the database owner. I run on a laptop and often find...

Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Nov 28 2006
Unload app domains when using the SQL CLR

SQL Server has a SQLOS that manages the use of threads and memory, this includes how SQL CLR operates within SQL Server. One of the items it does is manage the app domains used by SQLCLR. A question was raised about if it was possible to unload appdomains directly, just like you can clear the procedure...

Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Sep 14 2006

Page 1 of 1 (9 items)