Dave does Data

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...

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...

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...

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...

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...

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...

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...

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...

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...