Sybase iAnywhere SQL AAnywhere Mobile and Embedded Database

I'd rather play golf


Thoughts on data management, autonomic computing, and self-managing database systems.

 header image

Presentations

2010 Techwave presentations

Here are two links to talks presented by my colleague, Anil Goel, at the 2010 Sybase Techwave conference:

  • 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 MERGE statement. It includes a description of the support for immediately-maintained materialized views over outer joins, new in SQL Anywhere 12.

Recent talks

Webinars

  • Full text search in SQL Anywhere 11: This talk, given on 13 November 2008, provides an overview of the full-text search capability in SQL Anywhere 11, and highlights some improvements and subtle behavior changes in the 11.0.1 release.
  • Capacity Planning with SQL Anywhere: This talk, given on 20 November 2008, presents an overview of issues to consider when designing a performance evaluation of SQL Anywhere, and outlines an systematic approach to construct a model of performance to determine the relative importance of various performance factors, such as database cache size and the server multiprogramming level.

2009 Techwave Symposium presentations

Here are two links to talks that I gave at the Sybase 2009 Techwave Symposium at the Mayflower Hotel in Washington, DC on August 25-26 2009. Some or all of these are also available on www.sybase.com:

  • ORMs: Friend or Foe?: This talk outlines the promise, and the challenges, of utilizing ORM toolkits for production applications, using NHibernate as an example.
  • SQL Anywhere development best practices: This talk covers a variety of topics related to developing applications with SQL Anywhere, including aspects of schema design, reducing latency, and client-server protocol optimizations.

Techwave 2008 presentations

The following are links to four talks that I gave at the Sybase 2008 Techwave Conference in Las Vegas on August 5-6, 2008. Some or all of these are also available on www.sybase.com:

  • Capacity Planning with SQL Anywhere: We present an overview of issues to consider when designing a performance evaluation of SQL Anywhere. In particular, we outline potential pitfalls when designing a benchmark based on a specific database application. We address issues related both to the construction of a model database instance, and a model application workload, and outline an approach to construct a model of performance to determine the relative importance of various performance factors, such as database cache size and the server multiprogramming level.
  • Application Profiling with SQL Anywhere: We present a method for troubleshooting performance problems in SQL Anywhere, with a focus on version 10. We describe the nature of performance problems and classify them into categories of CPU-bound, I/O-bound, and concurrency-bound problems. We describe the steps a DBA should take to classify a performance problem, the tools provided in the product to examine the problem, and the analysis that must be done to resolve it.
  • Materialized Views in SQL Anywhere 11: This talk describes the comprehensive support in SQL Anywhere 11 for both batch-refreshed and immediately-maintained materialized views, along with a description of the server’s support for the MERGE statement.
  • Full text search in SQL Anywhere 11: This talk provides an overview of the full-text search capability in SQL Anywhere 11.