Browse by Tags

SQL Server 2008 - HierarchyId - How do you move nodes/subtrees around

In a recent post SQL Server 2008 - HierarchyId whats the point? I talk about the scenarios that the new hieararchyId can be applied to. Here we expand on this further and also provide a solution for moving hierarchies around. The limitation is that you can't do something like this to change the parent...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 03-31-2008
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 Blog on SQL Server Stuff (Weblog) by simonsabin on 12-09-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 Blog on SQL Server Stuff (Weblog) by simonsabin on 12-09-2007
Katmai Features I Love Part 1

I've seen it and I love it. If you've ever used Visual studio you would know that you can expand and collapse blocks of code to make your code readable. Well in Katmai you will be able to do this in management studio. So if you've got big sps then you can easily simplify the view by expanding...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 10-18-2007
Whats in a BOL link?

In using BOLyou will have noticed that the links in BOL contain some lovely guids. I often want to reference BOL in documents, forum posts etc but was concerned that the guids might change. So I asked Alan Brewer whether they change or not. He gave me a great response which I've got his permission...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 08-16-2007
SSIS : Web Service task doesn't cut it but who cares

18 months ago I was trying to use the SSIS web service task for a number of purposes. The first was to integrate with SalesForce, the second was to manage reporting services. Unfortunately the Integration Services (SSIS) web service task doesn't work for these web services. On further investigation...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 07-02-2007

Page 1 of 1 (6 items)

SQL Server Community Blogs

Browse by Tags

SQL Server 2008 - HierarchyId - How do you move nodes/subtrees around

Katmai Spatial - What's a geometry

Katmai Spatial - First thoughts

Katmai Features I Love Part 1

Whats in a BOL link?

SSIS : Web Service task doesn't cut it but who cares