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

Log writer process of Oracle is one of the most revered background process, a real work horse, a real charming darling who keeps the whole Oracle database system consistent and humming beautifully and many technologies in Oracle sprout from this good old process. Consistency is the key in database systems, and so in the Log Buffer Editions, and this Log Buffer #294 continues it. And yes, the coolest 2012 PASS Summit is also there.

Oracle:

Celine Beck is giving us some cool highlights about Oracle AutoVue Key from OOW12.

Solve the SQL mini-challenge and attend the November 15 NoCOUG conference for free?, Iggy Fernandez entices.

Christina McKeon is sharing some powerful lessons in data from the US presidential elections.

Shivmohan Purohit is sharing as how to find files versions and locations.

Andrejus Baranovskis was implementing today one use case, where it was required to compare current row status with the data returned by another query (no master-detail relationship).

SQL Server:

Chris Web had a lot of fun using data explorer, and he was pleased and quite surprised and now he is trying to have a look at its future.

Ryan Adams has done a post which is a live blog of the PASS Summit 2012 keynote from day 2.

In SSIS there are two tasks than can be used to execute SQL statements: Execute T-SQL Statement and Execute SQL. What is the difference between the two?Asks James Serra.

One of the most positive experiences Kevin Kline can have, as a former leader of the PASS organization, is when he sees a neophyte become a passionate support and champion for the community.

Welcome to the 2012 PASS Summit. Yep, so you made it.

MySQL:

Being a MySQL DBA is more than just being able to understand the explain command to optimize a query, Keith Larson opines.

MySQL Connector/Net 6.6, a new version of the all-managed .NET driver for MySQL has been released. Reggie Burnet informs.

VISUAL EXPLAIN will be come a standard tool in your DBA toolbox but you will need later versions of both MySQL Workbench and MySQL Server. Dave Stokes has more.

What is the largest amount of data do you store in MySQL? Peter Zaitsev inquires

Kristian Köhntopp is wondering. Dude, where is my memory?