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

Posted in: Technical Track

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.


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

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.”


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.



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 *