Log Buffer has become the mainstream carnival of the Oracle blogosphere. Technological advances in Oracle, MySQL, SQL Server and other database systems, more and more conferences, and increasing numbers of bloggers are making log buffering more and more interesting, and this week’s edition Log Buffer #216 is a clear manifestation of that.Read More >
I saw an Interesting question on preventing human error posted on the DBA Managers Forum discussions today. I typed my thoughts and as I was finishing, I thought that it makes sense to post it on the blog too, so here we go…Read More >
In order to appreciate the springing blogging innovations, this week’s Log Buffer, Log Buffer #215 picks some of the flowers just for you.Read More >
Look for the Pythian team at one of the following popular database industry events in Q2, 2011.
We’d like to hear from you. If you have any feedback on our sessions, please send your comments directly to the speaker, or to Vanessa Simmons, Pythian Director of Marketing.Read More >
In SQL Server news, Pythian’s expert SQL Server team are appearing at DevTeach 2011 at the end of May. Have a look that the presentation schedule.Read More >
Well the last busy day here in The Big Apple again a number of very good technical talks. It is not often that the developer of a key piece of a technology gives an intro talk so I grasped it when it came up. Robert Haas gave a very informative talk on the theory behind WAL (Write Ahead Logging) and how it is implemented on PostgreSQL as compared to other DBs. His talk never ventured into the neither world of techno-babel but gave just enough of the technical side to get the understanding out. In the second part of his talk Robert focused on a introduction of the ‘Buzz’ words of WAL that one might have to deal with. There were some other great presentatios as well, I mention a few hereRead More >
Database Servers are humming along, and the people who manage them, interact with them or are just in awe of them are busy in blogging about them. This inspires our next Log Buffer, Log Buffer #214.Read More >
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?
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 >