Our people

Travis Vandersypen

President

Travis Vandersypen

Travis Vandersypen is a Senior Software Developer at EPS Software Corporation, located in Houston, Texas.

He concentrates on consulting on and developing COM-based, distributed applications. He is an international author and speaker, co-author of the Fox Extension Classes, co-author of the Voodoo Web Controls, and 3-time Visual FoxPro Excellence Award Nominee.

He can be reached via email at: travis@eps-software.com.

Articles Authored

Articles

Showing 1–3 of 3

  1. CODE Magazine: 2002 - January/February cover

    XML UpdateGrams in SQL Server

    In this article Travis Vandersypen explains how SQL Server 2000's XML UpdateGrams provide a cleaner, transactional way to insert, update, and delete data via XML posted to the SQL virtual directory, avoiding OPENXML and URL length limits; he details the UpdateGram structure (<sync>, <before>, <after>), implicit and explicit XDR mapping strategies, NULL and identity handling, concurrency considerations, and practical execution tips for using UpdateGrams to map XML to relational tables.

  2. CODE Magazine: 2001 - Issue 1 cover

    XPath Queries in SQL Server 2000

    In this article, Travis Vandersypen explains how XPath Queries combined with XML-Data Reduced (XDR) Schemas enable developers to access and query SQL Server 2000 data without needing detailed knowledge of SQL or database structure. By defining XML schemas that map database tables and relationships, developers can retrieve and manipulate XML-formatted data directly via URLs using familiar XPath syntax. This approach shifts complexity to DBAs, allowing schema changes without impacting application code, and facilitates more flexible, XML-based data access and integration in SQL Server 2000 environments.

  3. CODE Magazine: 2000 - Fall cover

    Query XML from SQL Server 2000

    In this article, Travis Vandersypen explains how Microsoft SQL Server 2000 introduces native XML support, allowing developers to query data directly in XML format using the `FOR XML` clause with options like AUTO, RAW, and EXPLICIT. He details the configuration steps for enabling XML support via IIS, demonstrates querying data through URL and Template queries, and shows how XSL stylesheets can transform XML output for various presentation needs. Vandersypen emphasizes that this built-in XML functionality simplifies data integration for distributed applications by eliminating the need for custom conversion routines, enabling developers to focus more on business logic.