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

Posted in: Technical Track

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.


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.


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.



Want to talk with an expert? Schedule a call with our team to get the conversation started.

About the Author

I have been in love with Oracle blogging since 2007. This blogging, coupled with extensive participation in Oracle forums, plus Oracle related speaking engagements, various Oracle certifications, teaching, and working in the trenches with Oracle technologies has enabled me to receive the Oracle ACE award. I was the first ever Pakistani to get that award. From Oracle Open World SF to Foresight 20:20 Perth. I have been expressing my love for Exadata. For the last few years, I am loving the data at Pythian, and proudly writing their log buffer carnivals.

No comments

Leave a Reply

Your email address will not be published. Required fields are marked *