I'd rather play golf

The 3.2.0 GA release of the NHibernate object-relational mapping toolkit was recently released on July 30. Thanks to the efforts of Julian Maughan, the base NHibernate distribution contains two SQL Anywhere dialects, named SybaseSQLAnywhere10Dialect.cs and SybaseSQLAnywhere11Dialect.cs, that can be used largely unaltered with SQL Anywhere versions 10 and 11. However, some SQL Anywhere software configuration [...]

[Read more →]

SQL Anywhere has offered support for clustered indexes since the 8.0.2 release. There is no physical difference between clustered and non-clustered indexes in SQL Anywhere; any index can be marked as clustered, including those indexes implicitly created for the maintenance of referential integrity constraints. Moreover, one can apply or remove the “clustering” attribute of an [...]

[Read more →]

Version 12 of SQL Anywhere offers support for a wider classes of materialized view definitions; in particular, SQL Anywhere 12 supports immediately-maintained materialized views containing LEFT or RIGHT OUTER JOIN. My colleague Anil Goel will be covering much of this material in two back-to-back sessions at the forthcoming Sybase Techwave conference in Washington the second [...]

[Read more →]

A new whitepaper entitled “10 Cool New Features in SQL Anywhere 12″ is now available on sybase.com. It was authored by Breck Carter, an independent consultant and long-time SQL Anywhere partner, who is also the author of the SQL Anywhere 9 Studio Developer’s Guide [1]. [1] Carter, Breck (2004). SQL Anywhere Studio 9 Developer’s Guide. [...]

[Read more →]

Many long-term SQL Anywhere customers continue to utilize older SQL Anywhere releases, in particular Adaptive Server Anywhere 9 which first shipped in July 2003. In this post I’d like to quickly summarize, in one spot, the SQL Anywhere server features that are available in SQL Anywhere 12 that are not available in Adaptive Server Anywhere [...]

[Read more →]

SQL Anywhere has offered autonomic, self-managing statistics collection since 1992 [1]. In SQL Anywhere 12, we are going one step further with the introduction of a “statistics governor” that makes SQL Anywhere column histograms both self-monitoring and self-healing. Self-healing statistics management in SQL Anywhere 12 includes the: recording and categorization of selectivity estimation errors in [...]

[Read more →]

In a previous article, I presented some examples of how one can SELECT rows from a dml-derived-table, a new SQL language feature of the SQL Anywhere 12 server, now in beta. In this post, I want to briefly describe some other ways in which one can exploit dml-derived-tables to simplify applications. The first thing to [...]

[Read more →]

In a previous post in May 2009 I expressed admiration for a SQL language feature in IBM’s DB2 product that permits one to use an update DML statement as a table expression in a query’s FROM clause. Here is a simple example to illustrate DB2′s syntax: 1 2 3 SELECT T_updated.* FROM NEW TABLE ( [...]

[Read more →]

You can find an NHibernate dialect customized for the Sybase SQL Anywhere 12 server (currently in beta) here. This new SQLAnywhere12Dialect offers support for: The TIMESTAMP WITH TIME ZONE data type (also known as the DATETIMEOFFSET data type); and SEQUENCE values using the new SEQUENCE support in the SQL Anywhere 12 server. SQL Anywhere 12 [...]

[Read more →]

As mentioned previously, Mohammed Abouzour and Peter Bumbulis of Sybase iAnywhere, along with Ken Salem of the University of Waterloo, had their paper entitled “Automatic Tuning of the Multiprogramming Level in Sybase SQL Anywhere” accepted for publication at the forthcoming 5th International Workshop on Self-Managing Database Systems which will be co-located with the IEEE Data [...]

[Read more →]