Log Buffer #212, A Carnival of the Vanities for DBAs

Tweet about this on TwitterShare on StumbleUponEmail this to someoneShare on RedditShare on LinkedInShare on Google+Share on Facebook

I’m wondering, how many of you have kept your new year’s resolution? Well, Pythian’s Log Buffer has kept it and kept it in style. Not only it has sparkled the Oracle blogosphere with continuous gems, it has always remained the bleeding edge source for industry buzz.

The Pakistani Spectator has the honor of hosting the first Pythian Log Buffer of 2011 – Log Buffer #212. Log Buffer is medley of database blog posts and one of the most popular database carnivals.

We hope you enjoy this:


Doug’s Oracle Blog is once again into the intricacies of performance tuning and produces an interesting post about Cost of plans.

Arup Nanda is carrying on with his very knowledgeable series of “100 things you probably didn’t know about Oracle” and in the latest installment, he talks more about Interested Transaction Lists.

Randolf Geist, a member of OakTable Network and an Oracle ACE gives a heads-up to those that plan to use the Pending Statistics feature that has been introduced in Oracle 11.1.

It’s good that Jonathan Lewis is now blogging more and more and this benefits the Oracle community a lot with new and novel ideas upon old and new concepts of Oracle. In his latest post, he once again discusses ASSM. The topic is old, but the content is not.

David Kurtz, provides a small but meaty post about finding unnecessary effective date processing in PS/Query.

SQL Server:

Jason Strate carries on with his fabulous 31 Days of SSIS, and in his latest posting he talks about DTSConfig Configuration.

Brighton, UK is going to to host the SQLBits 8 and its registration is now open. Chris Webb is quite sure that this would be a great chance to have amazing stuff as it is the SQL Server event of 2011 in Europe.

Michael Swart has come up with a new series where he is exploring the different normal forms by breaking them in absurd ways.

Datachix rocks it again by challenging the stereotype and discusses the anti-hero approaches regarding issues in the production.

Pinal Dave has written some rational articles about giving his take as to why shrinking database is bad.


On the MySQL front, the public service goes on at full throttle. Full text of SQL-99 Complete, Really by Peter Gulutzan and Trudy Pelzer, is now freely available as mentioned by Daniel Bartholomew.

So it is proven that social networking is not a fad. MySQL is the backend engine for almost all the social networking components. Networking is the key in this competitive world and Robert Eisele throws light on some stunning features of MySQL in this regard.

Instrumentation and profiling is the new buzzword for databases, and MySQL is not behind in this case. Ronald Bradford discusses the profiling features in the MySQL 5.5.

Drizzle is a lightweight database for Web applications and Cloud infrastructure and its new logo is out, which is in fact the old logo.

Mark Calaghan is adding a few more variables to make it easier to monitor replication.

Big Data Blogs:

Perhaps the buzzword for 2011 is Big Data. Already some of the forecasters and analysts have started touting that this year the Big Data markets will come of age.

Read some of the post regarding it here and also here.

DB2 Blogs:

Today’s DBA job role has changed altogether. Not only does the DBA have to keep looking after the technology side of the infrastructure, the DBA has to keep acting as bridge between different silos of IT, and at the same time making sure that to have an up to date and good understanding of business requirements and knowledge of the the system which is essential to serve this role. If you are preparing a job position for the DBA, this wonderful post by Craig S. Mullins will help a lot.

Willie Favero, in a very useful post, lists which features will be kaput from the DB 10 version.

Analytics not only rock, they also bring new life into the business and are proving to be a truly enabling and profitable technology for even industries like Zoo. Here is a real world example by Adam Gartenberg.

Do you prefer to manipulate XML in the application code or do you prefer the Native XML management in the database? Here is the take of Matthias Nicola about XML Manipulation in Application code vs. a Native XML Database.

Yes, it’s again that time of year when people list their top 10 things of last year. David tells us his top 10 most popular replication topics for DB2.

About The Pakistani Spectator

A candid look

Leave a Reply

Your email address will not be published.