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

It’s the scorching summer season in this part of the world, Pakistan. There are many summer woes as the temperature reaches to 45 centigrade and beyond, but that also brings in the most savored fruit of the world, the king of fruits, Mango. Pakistan is one of the largest producer and exporter of this fruit from paradise. There are many variates of mangoes and its hard to pick from them as they all are so sweet and eye catching. Same is the case with the database related blogs, when it comes to selection for the edition of Log Buffer. So once again here you are, about to savor the sweet blogs in Log Buffer #224.

Oracle:

Automatic Diagnostic Repository (ADR) has changed the way we think about logs and traces in Oracle. Uwe Hesse dishes out a survival guide for the DBA about the cli tool adrci, which is used to manage ADR.

I am big fan of the team which decides and design the logs for Google main page. On Les Paul’s 96th Birthday, Google main page provided a live guitar, and I don’t have words to describe its beauty and joy. Kerry Osborne, though tries to describe it.

Randolf Geist informs that in recent versions Oracle changes the costs of a full table scan (FTS or index fast full scan / IFFS) quite dramatically if the “flashback query” clause gets used.

Jonathan Lewis writes a quick tutorial about how to use the hints.

Tim Hall carries on his weight reduction adventure, which is the dream of many.

SQL Server:

Mark Broadbent helps us understanding as how to add meta to our audio training files.

Denny Cherry recaps the Microsoft’s Tech Ed 2011 in his recent blog post.

Stuart Ainsworth busts three myths about the so celebrated Agile Development.

Have you been thinking about getting certified? Are you close on finishing your studying but aren’t quite sure if you are ready? If so, then check the new blog post by Jason Strate.

Melissa Coates blogs about Nested Conditional Operators in an SSIS Derived Column.

MySQL:

NDB cluster is a very interesting solution in term of high availability since there are no single point of failure. In an environment like EC2, where a node can disappear almost without notice, one would think that it is a good fit. Hmmm, perhaps not so. Yves Trudeau blogs.

Webyog says that he doesn’t need to emphasize how productive you can be if you find what you are looking for in a quick and easy way. Google has shown it to us. Wouldn’t it be fun to have the same ease and speed while searching for data in your databases?

Baron Schwartz (xaprb) introduces a pocket-sized guide to setting up and managing MySQL replication.

Nocholas Goodman is sharing an example on how we can enable easy reporting on top of BIg Data immediately for CouchDB users.

Today, more and more proprietary software vendors are choosing to go Open Source. Doing this enables them to leverage the community benefits of Open Source, shorten the sales cycle, and gain a competitive advantage over other proprietary products. Sandro Groganz blogs about choosing the right Open Source Product Architecture.

Happy Summer and Enjoy the Mangoes!!!

email

Authors Fahd Mirza

Interested in working with Fahd? Schedule a tech call.