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

Aug 19, 2012 / By Fahd Mirza

Tags: , , ,

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.

Leave a Reply

  • (will not be published)

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>