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

Jun 7, 2013 / By Fahd Mirza

Tags: , , ,

The onslaught of blogs is hard to ignore and underestimate. Blogging has become part of technologists everywhere, including the database professionals and evangelists. This Log Buffer Edition appreciates that and consists of blogs from Oracle, SQL Server and MySQL.

Oracle:

Dass Oracle in Version 11 unter bestimmten Umständen große serielle Full Table Scans (FTS) mit Hilfe von Direct Path Reads durchführen kann, ist schon häufig erwähnt worden (hier im Blog mindestens in drei Artikeln) – zuletzt hatte Tanel Poder darauf hingewiesen, dass die Entscheidung für diesen Zugriff seit 11.2.

Michael Snow highlights an active WebCenter partner with a recent success in the transportation vertical. Read on below to learn more about Redstone Content Solutions along with a great profile of their customer, Standard Forwarding LLC.

Mdinh got over 100+ saved sessions in PuTTY running on Windows and was looking for a way to move those sessions to Linux.

Data Pump is much faster than the old exp and imp client commands. Data Pump has a feature that helps to make it even faster by trading performance for resource consumption (CPU); this feature is called the “parallel” option.

SQL Gone Bad – But Plan Not Changed?

SQL Server:

Just when you thought you could handle SQL Server 2012, here comes the next version!  SQL Server 2014 was announced yesterday during the TechEd North America 2013 Day 1 Keynote.

Melissa Coates is integrating Data from Data Explorer into PowerPivot.

How Do You Handle Changes? Chris Shaw asks.

Mike Hillwig was looking at syntax of DBCC SHRINKDATBASE today and came across a little gem.

Richard Douglas has an interview with the chairman of SQLRelay 2013.

MySQL:

Tokutek created the iiBench benchmark back in 2008. The point of the benchmark is to measure the performance of indexed insertions over time.

Madrid MySQL Users Group worth creating?

When looking at high availability for any CMS, and particularly for Drupal, the list of contenders for a part or all of the solution is growing and can be daunting.

Engine condition pushdown is a MySQL internal mechanism that is intended to avoid to send non matching rows from the storage engine to the SQL layer.

Ever wondered how a database cluster ticks? Here’s how!

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>