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

This Log Buffer Edition once again touches upon the bold and best blog posts from the wide world of Oracle, SQL Server, and MySQL. Log Buffer is all about ideas, their implementation, and much more.

Oracle:

Reliability is inherently a property of systems, not of people, says Paul Vallee.

How to restore from a loss of a subset of the current control files? Marco V. tells.

Kathryn Perry is having the Oracle Open World in small bites.

Eric Rajkovic shares some new initiatives from the cloud fronts.

Chris Saxon is fiddling his way to SQL to make it run faster.

Surachart Opun has found about Kexec while going through Oracle Linux 6 documentation.

SQL Server:

Kendra Little is listing down the top three performance tuning mistakes.

As a database professional, Shaun Stuart sees a lot of instructions from vendors on how they want their SQL Server backend configured.

Jason Strate, like many of us, is wondering if he is missing out on any good blogs out there?

Have you ever been tasked with a project that you know has been done before, probably thousands of times, but you didn’t know where to start because it was new to you? Michelle Ufford asks.

Does this datatype make my column look fat? Thomas LaRock inquires.

MySQL:

Guilhem Bichot is playing with the idea of Cost-based choice between subquery materialization and EXISTS.

Sheeri K. Cabral is discussing the Ops benefits of the Cloud.

Ulf Wendel talks about MySQL 5.6: SHA256’s secure password support for PHP mysqlnd.

Mats Kindahl is having a go at the round robin replication using GTID.

Solid State Drive (SSD) have made it big and have made their way not only in desktop computing but also in mission-critical servers. Ovais Tariq has more.