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

From Percona Live, London to TechEd Australia to Oracle Open World USA, the blogosphere of Oracle, MySQL, SQL Server and the related technologies is bustling with the eye witness accounts of these conferences, technical overviews, observations, predictions, and much more. This Log Buffer Edition covers all that and as usual more in Log Buffer #243.

Oracle:

What the heck is the SQL Execution ID – SQL_EXEC_ID? Tanel Poder has some gems there.

Can you believe it? 100 conferences! The Northern California Oracle Users Group (NoCOUG) is celebrating its 25th anniversary in 2011 with its 100th conference.

Randolf Geist is picking up various random notes including Volatile Data, Dynamic Sampling And Shared Cursors.

Tim Hall shares the account of his OTN APAC Tour with the pictures.

Thinking about moving the EM12c repository database? Read this post by Martin Bach.

SQL Server:

Now you as a database professional have the chance to earn Storage and Virtualization from home, work, or where ever is convenient for you, Denny Cherry informs.

Chris Webb has something interesting to note regarding how scoped assignments behave with multiselect.

Thomas LaRock presents a book review. Yeah, the other Steve Jobs book which you can order by clicking on this link: The Presentation Secrets of Steve Jobs: How to Be Insanely Great in Front of Any Audience.

Data files containing comma separated values, or CSV, are some of the most common data formats used for data representation and storage outside the database.  When it comes to loading CSV data into the database, many options exist, however, few make it as simple as CSVexpress, according to Kevin Kline.

Miss TechEd Australia 2011? No problem, all videos are online, James Serra blogs.

MySQL:

Seppo Jaakola shares the slide set for the Galera release 1.0 presentation given in the PerconaLive London conference: Galera Replication Release 1.0, Getting There.

Pavan Venkatesh lists down top 10 reasons why MySQL experts switch to SchoonerSQL.

Shlomi Noach shares the impressions from Percona Live, London.

Here is a nice blog post about Installing Nginx With PHP5 (And PHP-FPM) And MySQL Support On Ubuntu 11.10.

Robert Eisele was asked for help in optimizing a MySQL query where flags are stored in a database and references should be counted based on the flag value.