Perficient

Technical Architect

Toledo, Ohio

• Add Spatial Capabilities to Your .NET Apps

  * * * * *

  Due to the pervasiveness of GPS data, today’s developers are being asked to incorporate geospatial information into their data-driven applications, often with no budget for procuring GIS software. SQL Server 2008 provides rich spatial support by means of the new Geometry and Geography data types, but some enterprises may not use SQL Server, or may be slow to upgrade their database platforms until years after a product release. There is still hope! .NET developers without access to SQL Server 2008 can still incorporate these new data types into their applications – no SQL Server required! Not only will this solve an immediate need using Microsoft-supported technology, but also provides an upgrade path to using SQL Server 2008 for more advanced querying support. In addition, developers can also utilize Virtual Earth technology to provide an interactive geocoding and visualization story to their end users.

  Level: 200

  Speaker: Jason Follas

  Topics: .NET Framework, Database Development

• Exploit the XML Capabilities of SQL Server 2008

  * * * * *

  XML-based data is very prevalent in today's data world to the point that every database developer should know how to work with XML. Middle-tier translation of XML into relational data may be inflexible, and often leads to a loss of fidelity over time. One solution is to move the XML handling into the database itself in order to improve overall integration. SQL Server 2008 provides powerful XML processing features that allow easy access to data stored within XML without sacrificing any of the original fidelity.

  Level: 200

  Speaker: Jason Follas

  Topics: Database Development