Posts Categorized: MySQL

PgEast 2011 Day The Second

Well day two here at PgEast has drawn to a close and it was another very informative day.Today I concentrated on the more common tasks of a Pg DBA so I attended three talks (four if you count mine) that where rather heavy on the technical side of being a Pg DBA. Keep reading.

NoCOUG (My)SQL Challenge entry #2

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.

Page 18 of 67« First...10...1617181920...304050...Last »