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

Posted in: Technical Track

Blogging is the way to express an idea in an informal way by a person who has either worked with it, plans to work with it, or has seen it at work. In databases, ideas are the foundations of everything, and this Log Buffer Edition is presenting them. Enjoy!

Oracle:

Pythian will be at Oracle OpenWorld as usual, and our marketing guru Maryanne has uploaded the schedule.

Frits Hoogland‘s post really is about using LVM (Logical Volume Manager; an abstraction layer for disk devices) snapshots.

If you are looking to kick start your community contributions or looking to volunteer more than what you already do, Alex Gorbachev has an awesome suggestion for you.

Randolf Geist is doing parallel execution analysis using ASH.

What are the things I need to know, what do I have to do to become expert, and where is the list of key things I need to do with Oracle? Tom Kyte answers.

SQL Server:

DBCC DROPCLEANBUFFERS and CHECKPOINT are very useful, and Jugal Shah explains why.

Bob Beauchemin is not sure how many full-text searches over filetable demos he has seen.

Bill Graziano is discussing yet another update to the SQL Server configuration Scripting Utility.

Your presence matters at the PASS Summit, Allen White assures.

Allessandro Alpi blogs about deprecated database engine features in SQL Server 2012.

MySQL:

It’s always interesting when somebody asks why they got an error message and especially sweet when you’re working on something related that lets you answer the question. Michael McLaughlin has more.

Calculating the standard deviation in MySQL is a no-brainer by using the build-in aggregate function STDDEV(), says Robert Eisele.

Chris Calender is very pleased to see that the SSL-related MySQL Bug #62743 has been fixed.

Regression tests for some bugs are not published in new MySQL releases, and it matters to Mark Callaghan.

Percona XtraDB Cluster (PXC) and the technology it uses (Galera) is an exciting alternative to traditional MySQL replication. Jay Janssen has more details.

email

Author

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 *