Welcome to MSDN Blogs Sign in | Join | Help

November 2008 - Posts

Friday, November 14, 2008 7:47 AM

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
Posted by davele | 3 Comments
Saturday, November 08, 2008 7:23 PM

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
Posted by davele | 1 Comments
Thursday, November 06, 2008 12:13 PM

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
Posted by davele | 1 Comments
Tuesday, November 04, 2008 9:11 PM

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
Posted by davele | 1 Comments
Tuesday, November 04, 2008 8:50 PM

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
Posted by davele | 1 Comments
Filed under:
Tuesday, November 04, 2008 2:06 PM

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
Posted by davele | 2 Comments
Monday, November 03, 2008 1:32 PM

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
Posted by davele | 4 Comments
Saturday, November 01, 2008 3:40 PM

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
Posted by davele | 8 Comments
Saturday, November 01, 2008 3:34 PM

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
Posted by davele | 3 Comments
 
Page view tracker