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

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

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.


  • OneDrive Users To Get Storage Options, Plus New Personal Vault

    Microsoft announced a few OneDrive enhancements, including storage-option additions, plus a new "Personal Vault" feature for added security assurance.

  • Cloud Services Starting To Overtake On-Prem Database Management Systems

    Database management system (DBMS) growth is happening more on the cloud services side than on the traditional "on-premises" side, according to a report by Gartner Inc.

  • How To Replace an Aging Domain Controller

    If the hardware behind your domain controllers has become outdated, here's a step-by-step guide to performing a hardware refresh.

  • Azure Backup for SQL Server 2008 Available at Preview Stage

    Microsoft added the option of using the Azure Backup service to provide recovery support for SQL Server 2008 and SQL Server 2008 R2 when those workloads are hosted on Azure virtual machines.

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.