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

Nov 9, 2012 / By Fahd Mirza

Tags: , , ,

Log writer process of Oracle is one of the most revered background processes, a real work horse, and a real charming darling that keeps the whole Oracle database system consistent and humming beautifully. Many technologies in Oracle sprout from this good old process. Consistency is the key in database systems as well as in Log Buffers. 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 has more.

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

Shivmohan Purohit shows how to find files versions and locations.

Andrejus Baranovskis implemented a 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. Now he is trying to have a look at its future.

Ryan Adams makes 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? James Serra answers.

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, informs Reggie Burnet.

VISUAL EXPLAIN will become 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 that you store in MySQL? Peter Zaitsev inquires.

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

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>