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

Feb 14, 2014 / By Fahd Mirza

Tags:

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:

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.

MySQL:

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.

Shard-Query is now much faster for some aggregate functions.

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.

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>