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

The key to success for the database technologists is to stay a step ahead of technology challenges and keep growing in order to efficiently scale to meet the needs of dynamic businesses and customers. Blogs are one way to remain abreast of technology trends, and Log Buffer Edition this week once again helps database professionals in that regard.

Oracle:

As LinkedIn grew from a startup to a post-IPO market leader, they relied on Oracle applications to support transformations, Lana Prout informs.

BPM is the promise of business transformation by maximizing the potential of turnkey business processes in any organization. But the majority of organizations never realize this dream and land up restricting BPM to project silos at the departmental level. Mala Ramakrishnan shares.

Rob Misek marks 2013 as the year of the data grid and beyond.

You cannot trust everything you see, Tom Kyte advises.

Jonathan is giving a little demonstration on how the completeness of execution plans can develop over time.

SQL Server:

Dirty data is everywhere, and it’s headed for a database near you.  Extraction, transformation, and loading (ETL) can be difficult, but often the most challenging component of that process is the validation and clean up of data.

With the SQL Server 2012 SP1 CU2 release, a new important feature was added: the ability to back up and restore a database straight from Azure Blob storage.

A good post about the database life-cycle management for Azure SQL Database.

How to find/modify SQLServer Agent logfile location? Rohit Garg answers.

Patrick is running a series of SQL Server Reporting Services 2012 Beginner posts.

MySQL:

Many people use MySQL in the console to execute a simple command, but did you know that MySQL can format the result of the query directly to XML or HTML?

Valeriy Karvchuk was asked today what different state values for InnoDB I/O threads really mean.

Tony Darnell is using MySQL Utilities Workbench Script mysqldbcompare to compare two databases in replication.

Standard MySQL is so configurable that a single master server can be clustered with a number of read-only slave servers.

Sveta Smirnova writes about troubleshooting performance diagrams.