At last week’s Sybase Techwave conference in Washington, my colleague Anil Goel presented two talks on the now-available SQL Anywhere 12 server:
- Self Management and Self Healing in SQL Anywhere: This talk gives an overview of the self-managing and self-healing features of SQL Anywhere 12, including high-level descriptions of the buffer pool manager, statistics manager, automatic multiprogramming level adjustment, and how these features are coupled to query processing.
- MERGE Statement and Materialized Views in SQL Anywhere: This talk describes the comprehensive support in SQL Anywhere 12 for both batch-refreshed and immediately-maintained materialized views, along with a description of the server’s support for the
MERGEstatement. It includes a description of the support for immediately-maintained materialized views over outer joins, new in SQL Anywhere 12.
Follow the links to download your copy of these Powerpoint presentations. They are also available on my Presentations page.

Glenn Paulley is a Director of Engineering at Sybase iAnywhere.
