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

Posted in: Technical Track

On this Valentine’s Day, what is the most romantic thing you could do as database professional? Why, yes — you could read (and then share) this scintillating and lovely Log Buffer Edition!


Oracle is kicking off a 17-city North American event series on how running Oracle Applications on Oracle hardware can help customers deliver maximum value and achieve dramatically better business results.

Five guidelines to follow as you begin building and employing mobile applications – plus Oracle technologies and products that support your move to mobility in your enterprise.

When you run R functions in the database, especially functions involving multiple R engines in parallel, you can monitor their progress using the Oracle R Enterprise datastore as a central location for progress notifications, or any intermediate status or results.

In the era of big data, data warehousing is becoming even more relevant for enterprises which are eager to become more information-driven.

The License Definitions and Rules (LDRs) are a critical part of every software license that Oracle grants to a customer.

SQL Server:

An examination into how the various transaction isolation levels affect locking (and blocking.)

What to do if you need to push the limits of your disk subsystem, in order to determine whether the hardware’s I/O capacity meets the needs of a database application.

An Overview of SSIS Parameters – Level 15 of the Stairway to Integration Services.

With the new SQL Server 2014 In-Memory OLTP tables, stored procedures can be natively compiled and can improve performance.

Excel spreadsheets are useful for distributing data generated by SQL Server, but SSIS lacks direct support for writing Excel files.


The Sign: row-based binary logging and integer signedness in MySQL and MariaDB.

Delayed Transaction Durability: A new feature in SQL Server 2014 CTP2.

Getting Started with the Spider Storage Engine.

One of the most expensive database operations is performing Data Definition Language (DDL, e.g. CREATE, DROP, ALTER, etc.) statements, specially, the ALTER statements because MySQL blocks the entire table for both reads and writes while modifying the table.

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 *