Even though my workplace and reduced costs by migrating from Sybase on Solaris to Sybase on redhat. We are now in a move from Sybase to MySQL to further reduce the license costs of the applications. This has brought to forefront one of the reasons to use Sybase. Triggers and stored procedures. And while MySQL [...]
Archive for the ‘Sybase’ Category
MySQL Triggers weak support for referential integrity
Posted in RDBMS, SQL, Sybase, tagged Functions, InnoDB, MySQL, Procedure, Sybase, Triggers on February 21, 2009 | Leave a Comment »
Sybase On Red Hat Linux
Posted in IT Issues, RDBMS, Red Hat, Sybase, tagged Linux, RDBMS, Red Hat, Sybase on November 26, 2008 | Leave a Comment »
I’ve been installing Sybase 15.0.2 on several systems lately, both Core 2 Duo’s and quad Xeon’s and have been impressed with the ‘normalcy’ of the installations. With the one exception that they have all has a ’segmentation’ failure with the backup server during the initial ’startup’ script this is due to the omission of a [...]
Sybase’s self-destructive business plan
Posted in IT Issues, RDBMS, Sybase on May 26, 2008 | Leave a Comment »
I have monitored all the discussions of DRM with regards to Music and Movies, but until I started installing a Sybase ASE 15.0.1 installation, as a first stage to a Sybase 12.0 upgrade at the company which I work for, that I realized that Sybase must hate it’s own customers. I say this as that’s the only reason [...]
Crypto in the personal privacy world
Posted in Sybase, T-SQL on July 31, 2007 | Leave a Comment »
I was recently presented with The Code Book and while leafing through the pages during a moment of boredom I managed to create a simple crypto using the Julius Caesar character substitution method using Sybase T-SQL. And though I’m sure that the resulting encrypted text could be broken with brute force, it would not be [...]
Working for the Underdog
Posted in IT Issues, Oracle DBMS, Personal, RDBMS, Sybase on September 2, 2006 | Leave a Comment »
I always find it interesting that I seem to be in the position of supporting the underdog when it comes to computing, I own Apple’s and work with Sybase. Two systems that can’t manage a marketing strategy to move them into the main stream. Both manage to be on the opposite end of competition with [...]
Oracle Market share
Posted in Oracle DBMS, RDBMS, Sybase on August 27, 2006 | 2 Comments »
One more point in the Sybase vs Oracle debate is the size of the Oracle installed base. The claim has been made that the reason Oracle is the number one RDBMS, is that the database has been selected for it’s features, reliability and maturity.
Once again this is a false premise as the real reason [...]
Row level Locking
Posted in Oracle DBMS, RDBMS, SQL, Sybase on August 27, 2006 | 3 Comments »
In the Sybase vs Oracle discussion there is always one issue that Oracle used to win. Row level locking. In the early days of Sybase, page level locking was the lowest level of granularity that locks attained. Much of this was due to a conscious choice of increasing the performance of the transaction, rather than [...]
Sybase vs Oracle
Posted in IT Issues, Oracle DBMS, Personal, SQL, Solaris, Sybase on August 23, 2006 | 6 Comments »
I’ve seen some discussion around the internet about the age old argument about which is best Sybase or Oracle. I have been reading Mr. Talebzedah article on Sybase vs. Oracle: 10 reasons to use Sybase on Linux and I would agree with many of his statements. Having installed and used both over the years, [...]
Sybase Data Integration Suite
Posted in IT Issues, Personal, Sybase on August 16, 2006 | Leave a Comment »
This is a great idea, in almost every company I’ve worked with data integration is the big issue. With all the mergers of going on, the data transfer issues are mind boggling. I have even played the part of data shepherd in these situations.
More here Sybase Unveils Sybase Data Integration Suite