in

SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » tips and tricks » SQLCLR (RSS)

Browse by Tags

  • 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

  • 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 (6 items)
Powered by Community Server (Commercial Edition), by Telligent Systems