Dave does Data

This post covers the following methods: STDisjoint, STIntersects , Filter,  STTouches , STWithin , STContains ,  STOverlaps , STCrosses,  STRelate, & STEquals One day these examples may find their way to Books Online. For now they can...

This post covers the SqlGeographyBuilder & SqlGeometryBuilder Classes & their methods. Overview of Methods to make your own Spatial Objects using the Builder API. SQL provides a Builder API that permit you to easily write your own Spatial Data...

This post covers the following methods: STArea, STLength, STDistance, STIsEmpty, STIsClosed, STIsSimple, STIsRing. Overview of Handy but obvious Methods The following methods are self evident. I’ve included here for the sake of completeness. You...

This post covers the following methods: STDimension, STGeometryType, STNumGeometries, STGeometryN, STNumPoints, STPointN, STNumInteriorRing / NumRings, STInteriorRingN / RingN, STExteriorRing, STX / Long, STY / Lat, Z & M (measure). Note: Unless otherwise...

This post covers the following methods: STUnion, STIntersection, STDifference, STSymDifference, STCentroid / STEnvelopeCentre, STPointOnSurface, STBoundary. Overview of Geometric "Set Theory" Methods These Methods help to understand the relationship...

This post covers the following methods: Reduce, STEnvelope, EnvelopeCenter, EnvelopeAngle, STConvexHull. Note: Unless otherwise stated. All code samples are designed to be Cut n Pasted directly into SQL Server Management Studio (SSMS) & run. Sometimes...

This post covers only 2 methods: STBuffer & BufferWithTolerance . They are so handy, they deserve a post all to themselves. Note: Unless otherwise stated. All code samples are designed to be Cut n Pasted directly into SQL Server Management Studio...

Remembering the exact syntax of a connection string is a pain. The following are links to my favourite articles on making a connection string.   Connection Strings.Com   Another great site for developers is The Code Project: ADO Connection Strings...