SQLServerCentral.com Articles tagged Spatial Data

Tuning Spatial Point Data Queries in SQL Server 2012

Fri, 27 Apr 2012 06:00:00 UT

Spatial Point Data queries require particular tuning efforts to enhance performance and improve overall application through put. SQL Server 2012 introduces a few key new features and improvements to assist you in that goal.

New Spatial Features in SQL Server Code-Named 'Denali'

Thu, 03 Nov 2011 06:00:00 UT

SQL Server 2008 introduced spatial data support into the database server. This paper describes and discusses the new spatial features in SQL Server Code-Named “Denali” CTP1 and CTP3 that augment existing SQL Server 2008 and SQL Server 2008 R2 spatial functionality.

Getting Started with Maps in SQL Server 2008 R2 Reporting Services

Wed, 08 Dec 2010 07:00:00 UT

I noticed a new feature in SQL Server 2008 R2 Reporting Services that allows you to render maps in your reports. Can you provide some details on this new feature and can I take advantage of it even though don't have any spatial columns in my data warehouse?

Standardize data storage for geography spatial data type in SQL Server

Mon, 04 Oct 2010 06:00:00 UT

Geography is one of the spatial data types introduced in SQL Server 2008. One of the characteristic of the geography data type is that it can accommodate any supported geometry based on any supported spatial reference system in the same field. So if the data that is stored in a column of geography data type is not standardized, it can be a very tedious and resource intensive task to figure out the geometry and spatial reference system associated with each value. To deal with this issue, we need to standardize the data stored in a field of that has the geography data type and in this tip we will look at how to deal with this issue.

Achieve Spatial Data Support in SSIS

Thu, 15 Jul 2010 06:00:00 UT

Spatial data support in SSIS is weak in comparison to SQL Server. This article demonstrates how to use the CLR to achieve the SQL Server levels of spatial data support in SSIS.

Reporting Services 2008 R2: Geospatial Visualization – Part I

Fri, 02 Jul 2010 06:00:00 UT

Geospatial Visualization is one of the key new features of SQL Server 2008 R2 Reporting Services. This step-by-step tutorial demonstrates the creation of a Map Report.

Working with Spatial Data Part IV - Developing a Geospatial Dashboard (GIS)

Wed, 26 May 2010 06:00:00 UT

In Part IV of the Geo-Spatial series, an interactive dashboard is developed to present and interact with the data.

Working with Spatial Data Part III - Reporting Spatial data using Reports Builder 3.0

Thu, 20 May 2010 06:00:00 UT

Part III of our spatial data series, continues building a demo spatial data app and uses Reports Builder for detailed visual mapping.

Working with Spatial Data Part II - Plotting Shapes and Storing Geocoded Data

Thu, 13 May 2010 06:00:00 UT

Continuing from Part I of the Spatial Data series we model an in-memory/persistent data repository for storing geocoded data and plot the data.

SQL Server Geography Data Type

Mon, 12 Apr 2010 06:00:00 UT

We are working on the migration to SQL Server 2008 and have geospatial data that we would like to move over as well. As part of our application we house information on locations across the globe. Which data type should we use?

Get alerts within 15 seconds of SQL Server issues
SQL Monitor checks performance data every 15 seconds, so you can fix issues before your users even notice them. Start monitoring with a free trial.

SQL Server 2008 Spatial Index Performance

Thu, 08 Apr 2010 06:00:00 UT

The institution I work with has decided to migrate their database system to SQL Server 2008. One of the applications uses geospatial data, which consists of millions of rows. I understand that their are indexes that can be used for geospatial data, but have not worked with them. What's the scoop on them?

SQL Server 2008 T-SQL Enhancements Part - IV

Fri, 26 Mar 2010 06:00:00 UT

In the fourth installment that looks at T-SQL changes for SQL Server 2008, Ashad Ali examines how the Filestream data type works.

Data storage and retrieval for geospatial data in SQL Server 2008

Thu, 04 Feb 2010 07:00:00 UT

The company I work for has migrated to SQL Server 2008 and we're ready to start planning for the use of geospatial data. One of the applications we want to use geospatial data in will assist order fulfillers in efficiently picking stock for orders. Our warehouse is fairly large, which geospatial data type should we use?

Using new location-aware data types in SQL Server 2008

Tue, 13 Oct 2009 06:00:00 UT

With SQL Server 2008, you will have new built-in support for location based data types and supporting geospatial features. Next you will learn how these new data types work.

SQL Server 2008 T-SQL Enhancements Part - V

Mon, 31 Aug 2009 06:00:00 UT

The fifth installment of Arshad Ali's series examines the spatial data types in SQL Server 2008. These new types allow the use of geospatial data in SQL Server applications.

SQL Server 2008 T-SQL Enhancements Part - IV

Fri, 26 Mar 2010 06:00:00 UT

In the fourth installment that looks at T-SQL changes for SQL Server 2008, Ashad Ali examines how the Filestream data type works.

Powerful Geographical Visualisations made easy with SQL 2008 Spatial (Part 2)

Tue, 23 Dec 2008 07:00:00 UT

This is the final article in a series on how to perform data visualisation with SQL Server 2008

New! Safeguard your SQL backups
Protect your backups from onsite disaster with SQL Backup Pro and a Hosted Storage account from Red Gate. Learn more

Powerful Geographical Visualisations made easy with SQL 2008 Spatial (Part 1)

Mon, 22 Dec 2008 07:00:00 UT

This article is part one of a two part series on how to perform data visualisation with SQL Server 2008

Make working with SQL a breeze
SQL Prompt 5 is the effortless way to write, edit, and explore SQL. It's packed with features such as code completion, script summaries, and SQL reformatting, that make working with SQL a breeze. Try it now.

Investigating the new Spatial Types in SQL Server 2008 - Part 2

Thu, 20 Nov 2008 07:00:00 UT

This is the second article in the series on the new spatial data types in SQL Server 2008

New! Safeguard your SQL backups
Protect your backups from onsite disaster with SQL Backup Pro and a Hosted Storage account from Red Gate. Learn more

Investigating the new Spatial Types in SQL Server 2008 - Part 1

Wed, 19 Nov 2008 07:00:00 UT

This article introduces us to the new Spatial Data Types in SQL Server 2008

GIS and SQL Server 2008: Making Maps with your Data

Tue, 04 Nov 2008 07:00:00 UT

When Microsoft introduced GIS into SQL Server with SQL Server 2008, it opened up a whole range of new applications that were previously impossible to do with SQL Server. So what can you do with GIS Data? We asked an expert!

Introduction to Spatial Coordinate Systems: Flat Maps for a Round Planet

Fri, 31 Oct 2008 06:00:00 UT

This paper is an introduction to Earth-oriented coordinate systems, projections, models, and mapping. While not specific to any technology, this information provides valuable background for those who will use spatial data in SQL Server.

Featured Blog: SQL Server 2008: Spatial indexes

Wed, 23 Jan 2008 07:00:00 UT

Paul Randal talks about the new spatial data types and their indexes.