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

Mar 30, 2012 / By Fahd Mirza

Tags: , , ,

The weather is changing, clocks are being adjusted, and the changes at the technological front are as usual rapid, frequent, and over-whelming. Keeping up with such rapid-fire changes is a project in itself. In the database triangle of Oracle, SQL Server, and MySQL, patches, updates, features, tricks, and tips are booming, and so is this Log Buffer Edition.


Oracle:

Just a quick heads up to ODA customers from Alex Gorbachev — there is a critical patch 2.1.0.3.1 out that is applied on top of ODA patch bundle 2.1.0.3.0.

How often are you backing up your cloud services? Tim Hall asks.

Toon Koppelaars blogs about the fourth use-case for the triggers.

Which PLAN_HASH_VALUE Appears in V$SQLAREA? Charles Hooper answers.

Randolf Geist notes that Oracle 11.2 introduced a set of new Query Transformations; among others, there is the ability to coalesce subqueries, which means that multiple correlated subqueries can be merged into a number of less subqueries.

SQL Server:

Jonathan Gardner discovers his strengths and weaknesses on the technical side after certification.

Bob Horkay guides us on how to use the Rank function to get the newest (or oldest) record from related records.

You can easily import data from an Excel file onto SQL Server using SQL Server Import and Export Wizard. Vishal has more.

Marlon Ribunal is looking forward to learning and sharing about SQL Server and data in general on the new blog.

Melissa Coates encountered the dreaded File system error “A FileStore error from WriteFile occurred.”

MySQL:

Adam Douglas enables us to resolve the MySQL error Incorrect Key File for Table.

Henrik Ingo has introduced the newly committed HTTP JSON key-value interface in Drizzle.

Agile software delivery and schema changes – how do you do it? Trent Hornibrook asks.

Ted Wennmark points out an opportunity to better understand how to achieve high availability with MySQL.

Kristian Köhntopp, an internal project that is generating a materialized view of some pretty important data, uses 96 application server cores against a 12 core database with 192g of memory and a buttload of SS. It’s good for about 250 MB/sec peak write rate in synthetic file creation.

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>