Review: Programming MS SQL Server 2008 – Holistic coverage for an App Developer

Following on from my review of my library. This week, Programming Microsoft SQL Server 2008. Summary: It appears to me that the authors started this book with the premise “There is a lot in SQL2008 that can dramatically change the way you architect solutions. Many features elegantly remove some of the clunky poor performance approaches…

0

SQL Spatial – How to get Spatial data. (FREE Maps ‘n Demographics)

This post lists ways to get spatial maps, some of them are Free. If you are in a hurry jump to the last link, it is so cool. Then check out the Free Map sites. Overview There are 3 ways to get the spatial data for your application:- Buy it Download it – FREE Build…

4

SQL Spatial – Tips on Storage

This post talks about ways to Store Spatial Reference data in SQL in order to improve performance of your map displays. Overview: There are two broad categories of Spatial Data. Spatial Reference data, the "stuff" you draw maps with; Geo-Political Boundaries (States, Postcodes), Rivers, Roads etc. It tends to be changed infrequently & typically refreshed…

2

SQL 2008 – Ways to architect Spatial apps

Adding spatial capability to your app might be simpler than you think. This is not a comprehensive coverage on architecture, but rather just a few ideas to stimulate your thinking. Overview In an N-Tier environment you have one of 3 options :- All spatial processing occurs on the Server(s) – Mid-Tier &/or Backend. All spatial…

4

SQL 2008 Spatial Samples, Part 1 of 9 – How to Learn SQL Spatial

This post covers how to get started with SQL Spatial methods & the best way to test things for yourself. One of the goals in this series of articles is to give you code you can cut, paste & try. I hope you find this handy. Overview Visual Studio is better than SSMS because: One…

9

SQL 2008 Spatial Samples, Part 2 of 9 – Background on Spatial Types & Well Known Text (WKT)

This post covers all the Methods to enter data in WKT, WKB & XML(GML) as well as functions to view the in Human Readable form. It also covers MakeValid, STIsValid & STSrid.   Summary of Methods to convert Geometric Formats The following table shows all the Methods create or import a spatial object from; Well…

4

SQL 2008 Spatial Samples, Part 3 of 9 – SQL Builder API

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 Importing utilities. It is also handy manipulating your shapes in a way that is not supported…

5

SQL 2008 Spatial Sample, Part 4 of 9 – Methods for Drawing Spatial Shapes

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 stated. All code samples are designed to be Cut n Pasted directly into SQL Server Management Studio (SSMS) & run.  Overview of Rendering…

4

SQL 2008 Spatial Samples, Part 5 of 9 – Performance Improvement Methods

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 I’ve added extra detail than what is in the sample picture. Overview of Performance Improvement methods. If you collected all…

2

SQL 2008 Spatial Samples, Part 6 of 9 – Geometric “Set Theory” Methods

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 between spatial objects & also to create new objects that show that relationship. Note: The sample code in the post shows more complex shapes than the diagrams…

3