Posts Categorized: Pythian

The XLDB4 Conference for Very Large Databases

For the 4th Extremely Large Databases Conference. I am interested in any MySQL folks planning to attend (I would expect Tokutek to be represented, and maybe even the Calpont folks). Most of this is directly from an e-mail I received from Jacek Becla, who had a keynote at the 2008 MySQL User Conference and Expo. If you also received this e-mail, please feel free to skip ahead to my viewpoints on the various Oracle conferences (or just skip altogether).

Pythian Implements Oracle Exadata at LinkShare Corporation

The Pythian Group Inc., the preeminent remote database infrastructure services company and a Platinum member of the Oracle PartnerNetwork (OPN) today announced the implementation of the Sun Oracle Database Machine at LinkShare Corporation, a division of Rakuten, Inc, and launch of its Oracle Exadata services practice.

MySQL and Quoting

MySQL does not follow the ANSI SQL standard for quoting. MySQL’s default quoting behavior is that either single or double quotes can be used to quote a string (this gets me into trouble when I work with Oracle databases, as double quotes do not indicate a string!).

ODTUG Kaleidoscope 2010 — Ready… Set… Go-o-o!

I just arrived and right in time for the Oracle ACE Directors’ briefing that will run for the whole days of Friday. This is a super secret meeting where Oracle’s super secret plans are shared. The ACE Director’s briefing is where Oracle shares the roadmap of its products — some of it is long term strategy and some is about the upcoming releases.

OVSAGE June Meeting

On June 17th, Pythian hosted the June of meeting of OVSAGE. This month, there was a presentation by Bill Stuart, CEO and VP Engineering , Karoly Molnar of Eseri. Eseri is a local Ottawa company that has integrated a full organization IT solution from the best of the world’s open source, from hosted Intranet to desktops to applications, and host it in the cloud for access on virtual desktops.

Oracle’s OPT_ESTIMATE hint: Usage Guide

Many have expressed the deepest desire to see OPT_ESTIMATE documented, but that never happened. I’ve just troubleshot a problem and used this hint a lot during my “what if” scenario testing, and found this hint to be quite useful. Thus, I decided to document it here on the blog. I will come back and update this blog as I discover new parameters, and feel free to suggest what you’ve found in the comments. If you can, include an example to illustrate usage.

Oracle UTF8 Encoding and String Manipulation Overhead

For one of our customers, I’ve recently reviewed the strategy of migration from single-byte encoding to variable length multi-byte UTF8 (AL32UTF8 encoding in Oracle naming standards). These type of projects are coming up again and again so I think it must be common for many of you. Thus, this bit might be useful. This is the PL/SQL block I came up with

Page 80 of 200« First...102030...7879808182...90100110...Last »