A few days ago I learned about this year’s NoCOUG SQL Challenge and decided to to put the gray matter between my ears to work. I’ve been teaching a MySQL course this week and my first impulse was to use my MySQL VM to test my solution attempts. However, I eventually decided to use Recursive Subquery Factoring to solve the proposed problem and had to switch to an Oracle 11gR2, since it’s the only database that implements this feature that I know how to use (are there any others?). I was happy with my solution, but frustrated that I couldn’t run it on MySQL. So I decided to try to make it somehow work on MySQL.Read More >
Seems that our André Araujo has already spilled the beans and revealed his solution to the second edition of the NoCOUG SQL Challenge.
Now, I can’t let him have all the fun, can I?
Here is the next latest and greatest DBD::Oracle for your programming pleasure. This time round we have cleaned a few compiler warnings and fixed up a few of the tests. Thanks to H. Merijn Brand and Charles Jardine for those.Read More >
Once again the great Wizards of Northern California have reached out to the community, pleading for help in the deciphering of one more challenging riddle. The second edition of the NoCOUG SQL Challenge has been published and is open for submissions! This time Iggy and his ensemble came up not only with a SQL challenge but also with a brain-bender riddle that must be resolved before you can start coding your solution. Very nice!Read More >
The announcement of the Second International NoCOUG SQL Challenge sponsored by Pythian and Apress has been published in the February 2011 issue of the NoCOUG Journal. See pages 18 and 19 for rules, details of the unsolvable riddle and prizes to be awarded to the smartest wizard who can reveal the secret message.Read More >
Sometimes I get questions as to whether Pythian is one of the competitors battling with Oracle for MySQL support. The answer lies in the distinction of product support and operational support.Read More >
This is a short one. Yesterday I was asked to marry an EBS autoconfig feature to an Oracle 11G Cluster infrastructure. In particular the client’s intention was to use srvctl to manage Instances and at the same time keeping DB side Network related configuration managed by autoconfig. There are several possible solutions. However, I used the following…Read More >
Here is the latest and greatest DBD::Oracle for your programming pleasure. This is a long overdue maintenance release that fixes a large number of bug and issues which are detailed below in the Changes. Don’t worry there are some new goodies in this release namely I have added in 4 new
server side tracing/debugging attributes
Pythian will be at RMOUG in full force. Look for Alex Gorbachev, Kellyn Pedersen & Don Seiler. Be sure to stop by our table (#10), say hi to us & our friends from the OakTable Network, and enter our draw to win an Amazon Kindle, and software provided by Cary Millsap (MR-Trace, MR-Tools & Method-R Profiler) among a few other surprises. Pythian is agressively hiring top DBA talent. If this is you, register on our Career Center, or request a time for a short intro chat with Pythian. Alex, Kellyn or Don will be more than happy to give you the inside scoop on the company & share why they love working for Pythian.Read More >