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

Resource Recommendations – Integration Services (SSIS & DTS)

I’m often asked "what references should I have for … <Insert Technology here>. " For Integration Services (SSIS), the MUST HAVE "bible" text book is… Professional SQL Server 2005 Integration Services (See the link for ISBN & similar details) Why do I love this book? It is one of the few I’ve seen that covers…

1

Resource Recommendations – Data Mining

I’m often asked "what references should I have for … <Insert Technology here>. " For Data Mining, the MUST HAVE "bible" text book is… Data Mining with SQL Server 2005 (See the link for ISBN & similar details) Why do I love this book? It walks thru each data mining algorithm, 1 per chapter, explaining…

1

Steve Ballmer Event SOLD OUT – But you can sneak in, online.

UPDATE: Now this event is complete, you can watch it online as a Webcast here Power to Developers The theme is Experience the Future of the Microsoft Platform. Steve Ballmer looks at high level trends in the computing industry, outlines Microsoft’s strategic investments, its direction & expands on the platform announced at PDC 08. Gianpaolo…

1

Small Business Server 2008 – WOW

Summary. I don’t think every product that Microsoft ships is great, one or two embarrass me. Most are good. But this one is brilliant. It gives me the same great feeling I get when I open Visual Studio to start working on a new project. Details. I just sat in on 1.5 hr demo of…

1

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