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

Mar 8, 2013 / By Fahd Mirza

Tags: ,

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.

Oracle:

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 (11.2.0.3) 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.

MySQL:

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.

2 Responses to “Log Buffer #310, A Carnival of the Vanities for DBAs”

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>