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

Posted in: Technical Track

There are so many great blogs out there regarding Oracle, SQL Server, MySQL, and various other database technologies. Keeping track of all of them is no less than a Herculean task. This Log Buffer Edition is an effort to pick a few of those great blog posts to appreciate the oceans of database blogs out there.


Nial Litchfield recently reviewed a table with no fewer than 23 indexes on it.

Toon Koppelaars asks: And what about table constraints?

Can Oracle Database Release 2 ( Properly Count Cores? No. Does It Matter All That Much? Not Really. Kevin Closson writes.

Jonathan Lewis has an interesting blog post about duplicate indexes.

How can we make Oracle Database 12cR2 the best release ever? Tim opines.

SQL Server:

Bob Horkay on pivot job history across multiple SQL Server instances.

John Sansom shares how to restart the SQL Server Agent Service using PowerShell.

A delightful read from Paul White on execution plan analysis.

Brent Ozar says that you don’t have a Big Data problem.

Data Explorer–Where Does The Real Work Get Done? Chris answers.


Good news to all those MariaDB users that have been waiting to get Galera synchronous multi-master replication to their favorite MySQL flavor.

MySQL modularity, are we there yet? Stewart Smith wonders.

Kolbe blogs that MySQL 5.6 includes a couple new options that allow you to store replication master and relay information in tables.

Valeriy Kravchuk lists down 17 famous MySQL bug reporters.

Baron is discussing how to avoid surprising users, and someone pointed out that what seems intuitive and rational to one person is often complete insanity for others.

Want to talk with an expert? Schedule a call with our team to get the conversation started.

About the Author

I have been in love with Oracle blogging since 2007. This blogging, coupled with extensive participation in Oracle forums, plus Oracle related speaking engagements, various Oracle certifications, teaching, and working in the trenches with Oracle technologies has enabled me to receive the Oracle ACE award. I was the first ever Pakistani to get that award. From Oracle Open World SF to Foresight 20:20 Perth. I have been expressing my love for Exadata. For the last few years, I am loving the data at Pythian, and proudly writing their log buffer carnivals.

2 Comments. Leave new

Why no Postgres?

Paul Vallee
March 8, 2013 1:56 pm

Hi Alex, did you submit links that were not covered? Readers contribute links. If no readers contribute Postgres links none make it in.




Leave a Reply

Your email address will not be published. Required fields are marked *