30th September - 2nd October 2010

University of York

Gold sponsors
Silver sponsors
Bronze sponsors

Geo-marketing: Building real world geographical intelligence with SQL 2008 (and SQL R2)

In this session we will review how the new spatial data types, allowed a financial organization improve geo-marketing decisions.  Attendees will learn how to create, manipulate and query geographic and geometric data stored in the database using the spatial data types and spatial functions. We will focus on how to build spatial business logic that effectively uses the new abilities of the database and also generate appealing reports and applications.

Speaker focus

Javier Loria

JavierLoria.jpg
Javier Loria is a Solid Quality Mentors Mentor based in Costa Rica. He began his professional career in 1992, as a software developer and system engineer. His career evolved rapidly to the training side, especially in the XML and OLAP world, training customers at different locations in Latin America. He is a software architect, and Business Intelligence Architect assisting our customers in Latin America. Javier became SQL Server MVP in 2001. Javier is an MCT, MCSE, MCSD, MCDBA, and MCAD. Javier was an active member responsible for writing the Microsoft SQL Server 2005 courseware. He is the coauthor of several books including MOC2782: Designing Microsoft® SQL Server™ 2005 Databases, MCTS Training Kit 70-431: Implementing and Maintaining SQL Server 2005 and Microsoft SQL Server 2005 Database Essentials Step by Step.     

Javier Loria's blog http://blogs.solidq.com/ES/jloria/default.aspx



Downloads

No items to download

Other sessions from this conference

Denormalisation –having your cake and eating it.
Design patterns for SSIS Performance
Designing and Tuning high speed data loading
Event Driven Cube Performance and Security Monitoring
Fast Track Foundations: Get Serious about Sequential I/O
Getting Started with SQL Azure
High Availability in the Real World!
High performance functions
Improving Database Performance by Removing the Database
Inside the SQL Server Query Optimizer
Introduction to Performance Tuning Analysis Services 2008
Lessons Learned from 128 Core OLTP Testing
Make your DBA life better using SQL Server technologies - notes from field & best practices
Monitoring and Tuning Parallel Query Execution
Non-Functional Dependencies - A talktorial on getting performance and scalability right through proper Database Design and understanding Set and Relational theory
Optimizing tempdb and temporary object use
Performance Management for SQL Server with SCOM 2007
Performance Monitoring & Tuning - Documented Tips & Tricks
Performance Troubleshooting made easy with PAL
Photograph: SQL Server Crash Dump Analysis
Scaleout scenarios with Service Broker
SQL Server 2008 Reporting Services Scalability and Performance
Supercharge MDX performance using MDX Studio
Transaction Log Performance Tuning, Stop shouting Timber!