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

The Log Buffer Edition is one-stop joint to know about the latest blog entries regarding the database technologies like Oracle, MySQL, and SQL Server. Enjoy this Log Buffer #281.

Oracle:

Whilst working with Oracle BPM Process Composer, Andrew began to receive the following error when opening projects.

Christian Screen is moving ODBC DSNs from source machine to target.

Dimitri Gielis is starting a series of blog posts about APEX 4.2.

Mohan Prabhala blogs about what enables Oracle Secure Global Desktop to allowa access anywhere.

Prateek Kumar Shaw came across use case where we need to have select all, select none and also we need to get selected rows into backing bean where later we want to perform operation on select records of af table.

SQL Server:

In Kalen Delaney’s experience, it is MUCH more common to have people turn off row or page locks when they shouldn’t, and by inspecting the sys.indexes catalog view, you can tell if that has happened.

Many people are looking for books about Analysis Services Tabular. Marco Russo mentions two books.

Why are so many DBCC commands undocumented? Paul asks.

Pedro has started a new challenge in life and challenge always corresponds to change, which is always lively.

Dinesh Priyankara has a cool blogpost about TABLE Type and MERGE Statement.

MySQL:

How exactly secure is ClouSE for MySQL, the first secure database in the cloud? Am I protected against standard application level security attacks or even accidental admin mistakes? Artem Livshits answers.

MySQL as a Key Value Store (KVS) is always intriguing and Andres Karlsson has shared his experience.

Brendan Gregg works on weird and challenging performance issues in the cloud, often deep inside the operating system kernel. Yes its already interesting.

Sean Hull mentions five things you overlook normally with MySQL dumps.

Transparent encryption does not make your database secure. Justin Swanhart says.