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

Mar 23, 2012 / By Fahd Mirza

Tags: , , ,

There is so much to learn out there. So much to accomplish and so much to devour technically. It can be daunting and overwhelming to have so much in one’s plate, and that is why this Log Buffer Edition has culled some top notch blog posts for you  in Log buffer #264.


Oracle:

Dominic Delmolino blogs about SQLDeveloper Hint — Dial0gInput.

Suppose that you receive a request stating that a particular table in one of your databases must be monitored for changes. Yes, Charles Hooper blogs about yet another real world requirement.

At last, the Oracle Database is certified on OL6/RHEL6, and like many others Tim Hall finds it hard to believe.

Karen Morton is glad to see that youth is having a good early start in the Oracle technology.

Tom Kyte learns two more things this week. One a SQLPlus quirk, and another one is about temporary tablespaces.

SQL Server:

Pinal Dave shares his take on identification of optimal run of queries on single and multiple processors.

Chad Miller describes a process to transform and incrementally load the audit data into a SQL Server table for reporting purposes.

Dave Morrison, the TSQLNinja does a guess appearence.

What better way to celebrate birthday than to offer a SQL Server crossword? John Sansom does exactly that.

Richard Douglas is wishing you were there, as he is enjoying the company of #SQLFamily.

MySQL:

Petri Virsunen announces a webinar about Building a multi-master, multi-region MySQL infrastructure in Amazon EC2.

Florian Haas is sharing few thoughts on high availability features in OpenStack.

Chris Calender offers a simple query to identify foreign key references on deadlocked tables.

Ovais Tariq has written a second blog post in the series of blog posts leading up to the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5.

The recently announced Amazon DynamoDB is Amazons NoSQL service offering, but it is not like MongoDB with a twist, far from it. Anders Karlsson has more.

Leave a Reply

  • (will not be published)

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>