SQL Map Reporting{1}


by Quoc L
One of the many feature of SQL server offer to the user is map report. It a tool that allow the user to visualize data against the geographic background. It compose of two part, map and ay layer. The map report all the data whereas map layer display the geographic background. Inside the map layer there another set of data types, polygon, line, point and tile. First type represent geographic, line  show the path and routes. Point are used for location and lastly tile represent Microsoft Bing maps tiles.

I think this is important to your class to being able to quickly and efficiency reading  data. We been learning about creating and importing data into SQL. However being able to read it is as important as any other SQL abilities. However using map is limited to geographic data, it still very important to DBA to know about.

 

Arshad, A. (2012, March 12). Database journal. Retrieved from http://www.databasejournal.com/features/mssql/creating-map-report-in-ssrs-sql-server-2008-r2.html