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

Horizon is getting cloudier, but these low-hanging clouds are not darker or more ominous in any way. These are the clouds of enabling technologies providing drops of technologies according to our wishes. Behind this seamless information troposphere, databases are floating, again on demand. This Log Buffer Edition showers in the droplets of blogs from databases.

Oracle:

Rajesh Rahela writes a blog post explaining how to use Oracle SOA Suite for Cloud Intergration.

Jeff Smith shares how to reset Oracle user password with SQL Developer.

Did anyone really ‘like’ Oracle Social? Lena asks.

How to restore from a loss of all current control files to a non default location using a backup piece? Marco V answers.

Mutating histograms, mutating number of rows, mutating blevel, mutating number of distinct levels… What do they mean? Carlos Sierra deciphers.

SQL Server:

Why do you need a TempDB to restore a database? Nacho Alonso Portillo provides an answer.

They say pictures say 1000 words and help you understand things clearly. Shashank Pawar shares a Windows Azure Cloud platform poster.

During some restore operations on Microsoft SQL Server, the transaction log redo step might be taking an unusually long time. Kevin Kline has a quick tip.

If you are using Transparent Data Encryption TDE and have Instant File Initialization turned on, you are not getting the benefits of Instant File Initialization. Tim Radney informs.

Valentino Vranken is sharing the impressions of a first timer to PASS Summit 2012.

MySQL:

If you plan to use the MySQL Workbench Migration Wizard to migrate databases from PostgreSQL to MySQL, you first need to configure an ODBC driver to connect to your PostgreSQL server, writes Sergiodlc.

CNN Money proclaims Database Administrator the fifth best job in America.

Gerrit gives us three ways to rename a MySQL database.

For many years, Mark Grennan has recommended that startup companies install and work with CentOS until they need and can afford RedHat Enterprise.

MySQL is the world’s most popular open-source database and powers websites and applications of numerous leading and fast-growing organizations.