Log Buffer #215, A Carnival of the Vanities for DBAs
Apr 1, 2011 / By Fahd Mirza
Spring is making its way into everything, and the databases are blooming as the DBAs who manage them are savoring the fragrance of the changing weather and fresh new ideas in the world of blogging. In order to appreciate the springing blogging innovations, this week’s Log Buffer, Log Buffer #215 picks some of the flowers just for you.
Hemant, the Oracle ACE from Singapore writes superbly about OuterJoin with Filter Predicate as usual with a reproducible case.
When Tanel Poder says it, you have got to believe it. Ok, it’s official – the first and only Oracle Troubleshooting TV show is live now!
Jonathan Lewis introduces a framework that helps avoiding the traps inherent in writing PL/SQL loops when modelling a session that does lots of simple calls to the database.
More and more experts are highlighting the importance of having immediate performance information from OEM, and Martin Widlake posts another blog about it.
Pakistan’s First Oracle Blog throws light on the identification of Exadata Performance Degradation.
There are some blog posts which speak for themselves – just the fact that they have been written after lot of hard work. Charles Hooper is in the habit of producing such gems regularly. Here is another one from him to relish over the weekend.
Kendal Van Dyke, who lives life as a SQL Server DBA announces the association For SQL Server in an interesting post.
A Highly deserved SQL MVP goes to Thomas LaRock. Congratulations LaRock from all of us at Pythian. And kudos also goes to Hemantgiri Goswami of Pythian who has achieved MVP three years in a row for SQL Server Systems Administration.
Wes Brown carries on with his magic with the disks. This time he slices and dices the fundamentals of Storage Systems, Understanding Reliability and Performance of Solid State Storage.
Mark Leith puts in lots of salient points in the single blog post and call it a Big Bag of Epic Awesomeness.
Kristian Köhntopp discovered a particularly subtle way of fumbling up a server restart.
Along with the Cloud, the next big thing is the Big Data. But How Big? Baron Schwartz (xaprb) discusses just that.
Use Replication for backups? Are you schemas consistent? Read the perspective of Ronald Bradford.
Our very own Marco Tusa of Pythian, my favorite MySQL DBA from beautiful Italy tells us that after a long period of time without one second of relaxation, The MySQL Dolphin Search, nick name Fetch for the friends, decided to go on vacation.