News

SQL Server 2008 To Offer Spatial Data Type Support

sQL Server 2008 offers new support for spatial data types that some analysts say should deliver a real boost to geospatial applications and data sharing.

Microsoft's soon-to-be-released SQL Server 2008 offers new support for spatial data types that some analysts say should deliver a real boost to geospatial applications and data sharing.

Expected to ship in the third quarter, the new version of SQL Server will allow storage of spatial data -- in the form of points, lines and polygons -- in SQL tables. The software will also offer a set of functions to allow the manipulation of this data and new spatial indexes to support the execution of these functions.

The move is especially important, according to John Baleja, senior product manager at mapping software provider ESRI, because about half the company's customer base now uses SQL Server. ESRI is the dominant vendor of geospatial software in the federal sector.

"I would say that the request for SQL access to the spatial types is probably over the last two years the No. 1 request that we received here at ESRI for new functionality," Baleja said. "We've been in discussions with Microsoft for quite a few years about adding a spatial type, so we are really excited to see this coming out in SQL Server 2008."

Since 1996, ESRI customers who wanted to use SQL Server as a data repository had to use an ESRI Web service add-on to manage the data. The biggest advantages to having native SQL support for spatial data, Baleja said, will be easier integration with other applications, more security and possibly better performance.

"Going through SQL Server, you can take advantage of a transaction management and security features that are built into SQL Server," Baleja said.

About the Author

Patrick Marshall is the technology editor of Government Computer News (GCN.com).

Featured

  • Windows 10 Hyper-V vs. Windows Server Hyper-V: Which Platform for Which Workloads?

    The differences between these two Hyper-V versions are pretty significant, depending on what you plan to use them for. Here's a quick rundown of each platform, from their features to licensing quirks to intended use cases.

  • Office Mobile Apps To End as Microsoft Highlights New Office App

    Microsoft plans to end support for Windows 10 Mobile applications on Jan. 12, 2021, according to a Friday announcement.

  • Is Microsoft Finally Reinventing Office?

    Microsoft is testing out a new technology called "Fluid Framework." It could mean that Brien's dream of one Office app to rule them all might soon become reality.

  • Azure Active Directory Connect Preview Adds Support for Disconnected AD Forests

    Microsoft on Thursday announced a preview of a new "Cloud Provisioning" feature for the Azure Active Directory Connect service that promises to bring together scattered Active Directory "forests."

comments powered by Disqus

Office 365 Watch

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.