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

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

Oracle:

Rajesh Rahela has written a blog post covering how to use Oracle SOA Suite for Cloud Intergration.

Jeff Smith is sharing with us as 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:

Nacho Alonso Portillo is answering as why does restoring a databae needs TempDB.

They say pictures tell you a 1000 words and helps you to 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, written by Sergiodlc.

CNN Money has proclaimed being a Database Administrataor as being the fifth best job in America.

Gerrit tells us three ways to rename a MySQL database.

For many years Mark Grennan has recommended 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.