Tamar Granor
  Tamar E. Granor, Ph.D., is the owner of Tomorrow's Solutions, LLC. She has developed and enhanced numerous FoxPro and Visual FoxPro applications for businesses and other organizations. She currently focuses on working with other developers through consulting and subcontracting. Tamar served as Editor of FoxPro Advisor magazine from 1994 to 2000. She is currently the magazine's Technical Editor and co-author of the popular Advisor Answers column. Tamar is author or co-author of eight books including the award winning Hacker's Guide to Visual FoxPro and Microsoft Office Automation with Visual FoxPro. Her most recent books are What's New in 9: Visual FoxPro's Latest Hits and OOoSwitch: 501 Things You Wanted to Know about Switching to OpenOffice.org from Microsoft Office. Her books are available from Hentzenwerke Publishing (www.hentzenwerke.com). Tamar is a Microsoft Certified Professional and a Microsoft Support Most Valuable Professional. Tamar speaks frequently about Visual FoxPro at conferences and user groups in North America and Europe, including every FoxPro DevCon since 1993. She is a Lecturer in the School of Engineering and Applied Sciences at the University of Pennsylvania. She served as Technical Content Manager for the 1997-1999 Visual FoxPro DevCons and was part of the coordination team for the Visual FoxPro Excellence Awards.
 
   
  Solving Common Problems with VFP's SQL
VFP's SQL language offers solutions to a variety of problems faced in many applications. This session presents a selection of problems and examines ways to use VFP's SQL to solve them. The focus is on working with VFP data and the examples provide demonstrations of many of the SQL features added in VFP 8 and 9.

Attendees will learn how to:
1. Use SQL commands to prepare data for reporting
2. Use SQL commands to process data
3. Clean up data using SQL commands
4. Manage SQL commands

Skill level: Intermediate
Suggested prerequisites: Some familiarity with VFP's SQL commands
   
  Using the VFP Debugger Effectively
Visual FoxPro has a powerful debugger that provides many tools for finding problems with your code. This session will dig into the Debugger, showing how you can make the most of its tools in order to speed development, improve your code, and understand VFP better.

Attendees will learn how to:
1. Step through code to find problems
2. Set breakpoints
3. Use Event Tracking
4. Use the Coverage Profiler

Skill level: Intermediate
Suggested prerequisites: familiarity with VFP