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

Posted in: Technical Track

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!

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 *