RisingRoad helps SQL Anywhere developers make better databases

Ask for help, or ask a question: Breck.Carter@gmail.com

Or read the The Blog.

"We couldn't have been more pleased! We received a detailed explanation and demonstration of how MobiLink works. Along the way, we received much needed help in our preparation to migrate to SQL Anywhere 10 and a number of helpful database tuning techniques." - Wayne Allen, Vice President of Software Engineering, Integrated Services Inc. (more...)

Foxhound helps SQL Anywhere administrators sleep at night

"Foxhound is great! I've found it tremendously useful in being able to quickly look at meaningful database performance / schema parameters without investing much time in using disconnected technologies to get the same info or writing singular queries and generating the data presentation. Within an hour, I've identified several areas in my schema design that need improvement to maximize query performance. I ran it on the HITS database and quickly saw the issues with our big tables that require further optimization." - Jeff Chu, Simbex (more...)

Foxhound Beta 9 is now closed. Beta 10 will start soon.

Best of the Blogs

Unpublished MySQL FAQ - The all-time most popular page in the SQLAnywhere blog... might always be Number One.

OpenXML() Rocks! - All about using a single INSERT statement to parse and load XML data into a table, using XPath strings and SQL Anywhere's magic OpenXML() function.

Comparing Database Schemas, Improved Edition - How to use the SQL Anywhere Version 11 dbunload utility to do side-by-side comparisons of ALL the schema, across ALL versions from 5.5 to 11.

Compare Tables With UNLOAD INTO VARIABLE - How to use Version 11's UNLOAD INTO VARIABLE to compare the data in tables.

Revisited: Triggering an Audit Trail - How to use AFTER INSERT, UPDATE, DELETE triggers to capture before-and-after row images in shadow tables.

Multi-Tenant Database Architecture - Chris Kleisath's four-part discussion of how your company can use SQL Anywhere to host dozens or hundreds of databases for other companies.

Current Open Betas

SQL Anywhere for the iPhone - A REAL database for the iPhone

SQLA - a StackOverflow-based Questions and Answers website dedicated to SQL Anywhere

UltraLiteWeb - a browser-side SQL Anywhere database, with MobiLink synchronization, in Google Gears

---

This page was last updated on November 11, 2009      Home      References      Breck.Carter@gmail.com