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

Posted in: Technical Track

With new blog posts covering newest technologies, discovered bugs and anomalies, this Log Buffer Edition is presented for you. In this Log Buffer #261, you would savor posts from Oracle, SQLServer and MySQL arena. Enjoy


Oracle ACE Director, Alex Gorbachev makes a quick announcement that Method-R is organizing the online class reunion for the participants of their Mastering Oracle Trace Data classes.

Jonathan Lewis discusses an anomaly pointed out by Christian Antognini.

How is it possible to query from a join view by ROWID, since the view is based on multiple objects and hence doesn’t have a simple one-to-one mapping to a ROWID of a single table? Randolf answers.

Repeat after Charles Hooper: NULL Values are Not Stored in Indexes?

Time to roll your own big data appliance :)


Managing a large SQL Server inventory requires an efficient management processes, Jack blogs.

Stuart Ainsworth is wrapping up his blog series.

One of the great features with SQL Replication is the ability to initialize a subscription from backup instead of from a snapshot. Denny Cherry has more.

SQL Rally 2012, in Dallas, is coming up in May, and Melissa Coates lets us know that there is a great lineup of sessions.

Thomas LaRock says that there are top three things which you should learn in SQL 2012.


Aaron Brown is going to outline the distinction between READ COMMITTED and REPEATABLE READ.

What does pt-show-grants look like? Sheeri tells us.

After having established a MySQL or MariaDB connection, HeidiSQL offers to launch a command line window (located in the “Tools” menu). Ansgar Becker has more.

Hartmut Holzgraefe is having more fun with partitions, this time with MyISAM.

Dave Stokes shares yet another interesting MySQL/NoSQL approach.



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 *