Sybase Watch

New DBMS: Advantage

I was surprised to see a newsgroup post from a TeamSybase member that included the statement

Sybase has three different database products : Adaptive Server Enterprise,  SQL Anywhere and  Advantage Database Server.

"Advantage Database Server"? What on earth is that? For a moment I thought that the much-missed SQL Advantage GUI (not provided with ASE 15.0 clients toos) had been reinvented as a full-blown DBMS...

A bit of digging - this is another acquisition by Sybase Inc which they've folded into the iAnywhere group. A client-server DBMS apparently popular in the Borland world (Delphi and C++ coders) - "3 million deployed seats" is impressive. Interestingly, its ISAM-based i.e. like MySQL. So no, not a rival for the ASE space.

Intersolv ODBC driver

One of the developers who has the thankless task of supporting an "old" Sybase 11-based application came looking for an installation of the "Intersolv" Sybase ODBC driver. He showed me the documentation - sure eneough, the original developer (long since left) has specified Intersolv. The Intersolv name rang a bell from my spell of Powerbuilder development eight years ago, but I haven't heard the name in a long time.

After a bit of digging I found that Intersolv is now DataDirect. I installed the ODBC driver from one of my old Sybase 12.0 PC Client installation disks - and no problems so far. I see from Five Salmon's Sybase Zone that Merant, another old name, is also now part of DataDirect.

Sybase ranked 21st in CIO poll

The annual poll from "CIO Insight" has ranked Sybase Inc 21st out of the top 40 I.T. vendors. At least Sybase has maintained consistent form, it was 21 last year too.

I've never heard of the top two vendors (CDW and Trend Micro) but kudos to the giant Cisco Systems at #3 and double kudos to Red Hat for joining Cisco on 3rd position. More directly related to Sybase...IBM is at #16, Microsoft at #24 and Oracle #32.

Looking a little closer at the Sybase results (and noting a total sample size of 826 CIOs), its interesting to see the highs and lows of the Sybase score. Its highest ranking is "meets ROI expectations" and the lowest is "meets commitments on time and on budget". May we surmise that Sybase "big database" projects are more complex than initially scoped, but eventually deliver?

MySQL chasing Sybase customers

MySQL AB has launched a new enterprise license priced at $40,000 including support. The company is specifically targeting Oracle, MS SQL Server, Sybase and DB2 customers.

Will there be a rush of Sybase ASE customers to MySQL? Dan Farber figures that it will probably do more in the short term to attract MySQL enterprise database customers who download the software but don't pay MySQL a cent for service and support.

I tend to agree with Dan. I reviewed industry research last year into MySQL and the global DBMS wars - I've come to the conclusion that medium-to-large enterprises run a product mix with at least two different platforms. Increasingly, mySQL is the second (or third) platform - but I don't see it currently replacing the big three in the Unix world (Oracle, DB2, Sybase).

Sybase gets into Podcasting

I listened today to a podcast from Sybase on "The Art of Performance and Tuning - General Best Practices". Historic in its own way as I believe its the first ever podcast released by the company, certainly for ASE.

Sybase has also been trying its hand at webinars, and the tech team have their own blogs. Combined, these techniques could prove to be a breakthrough for experienced DBAs who have long ago "finished" the phase of the five-day formal training course. Podcasting can chunk up about an hour's worth of good training material - tips & tricks, real-world case studies and the like.

Its usually the Java programmers who wear earphones all day, I welcome the chance to don a pair now and then for some useful podcasts from the mother ship.

Developers Edition

Why doesn't Sybase Inc make it easier to find the free Developers Edition of ASE? Its very handy to install this version on a PC for tinkering and testing data models etc. Its here by the way

Searching for "Developers Edition" on the Sybase website throws up the ASA (Adaptive Server Anywhere) download, not the ASE version. I spent a good hour following various links on www.sybase.com to no avail. Kudos to Rob Verschoor at www.sypron.nl, who maintains an updated link.

It rankles somewhat that Microsoft's SQL Server developers edition is much easier to find, search for it on the microsoft site to get immediate results.