News

Microsoft's TerraServer Proof Point Still Serving Aerial Data

The TerraServer project that began six years ago as a proof point for the scalability of the then-unreleased SQL Server 7.0 is live and still growing, serving up free aerial images of neighborhoods, stadiums and harbors at half-meter resolution.

Microsoft Research vice president Richard Rashid called attention to the program during remarks at the Microsoft Research Faculty Summit in Redmond this week while talking about some of the projects his team is working on.

"Back in 1998, [Microsoft researcher] Jim [Gray] and his team did something called TerraServer, and we put up initially a terabyte, and now it's close to 20 terabytes of data on the surface," Rashid said.

He used the TerraServer example to provide a dramatic illustration of how much technology miniaturization and other improvements have reduced the footprint and cost of such massive database systems.

"It was originally a system about a quarter of the size of this room with all the disk drives in it. Now the system is dramatically larger, supports more users, and it's actually just two small racks about this high. And it went from being about $2 million worth of hardware to being about $70,000 worth of hardware," Rashid said.

The system relies on aerial imagery from the U.S. Geological Survey. Rashid says the new half-meter resolution data from USGS can actually show people in the images. "You can't really tell who they are, but as we get better data from USGS maybe we'll be able to do that too," he said.

Microsoft rolled out TerraServer to show that its unreleased SQL Server 7.0 would scale to meet the requirements of the largest enterprises. Scalability limitations were a significant knock that Oracle and other competitors used at the time to discourage customers from considering Microsoft's database. TerraServer has since migrated to SQL Server 2000 Enterprise Edition.

TerraServer is located at terraserver.microsoft.com/.

Meanwhile, Microsoft is also working on a newer project with the Sloan Digital Sky Survey to provide a free, public database of astronomy images and data. The Web site to access those images and that data is located at SkyServer.sdss.org.

Editor's Note: This article has been updated to remove incorrect references to satellite imagery. The TerraServer data comes from aerial imagery taken from cameras in airplanes.

About the Author

Scott Bekker is editor in chief of Redmond Channel Partner magazine.

Featured

  • Microsoft Offers Support Extensions for Exchange 2016 and 2019

    Microsoft has introduced a paid Extended Security Update (ESU) program for on-premises Exchange Server 2016 and 2019, offering a crucial safety cushion as both versions near their Oct. 14, 2025 end-of-support date.

  • An image of planes flying around a globe

    2025 Microsoft Conference Calendar: For Partners, IT Pros and Developers

    Here's your guide to all the IT training sessions, partner meet-ups and annual Microsoft conferences you won't want to miss.

  • Notebook

    Microsoft Centers AI, Security and Partner Dogfooding at MCAPS

    Microsoft's second annual MCAPS for Partners event took place Tuesday, delivering a volley of updates and directives for its partners for fiscal 2026.

  • Microsoft Layoffs: AI Is the Obvious Elephant in the Room

    As Microsoft doubles down on an $80 billion bet on AI this fiscal year, its workforce reductions are drawing scrutiny over whether AI's ascent is quietly reshaping its human capital strategy, even as official messaging avoids drawing a direct line.