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

In this Log Buffer, you have naan bread, two types of roti, pasta, Karachi biryani, Chiken Tandoori, Beef tikka, eggplant masala, mixed pickles, French pastry with some elixir to wash all of it down. Yes, once again, this edition of Log Buffer contains numerous flavors from Oracle, SQL Server and MySQL.

Oracle:

Sometimes it’s the little differences that make something really cool, and Martin was wondering why this hasn’t made it into the Oracle dictionary before.

Oracle introduced a new feature for DataGuard called Far Sync. This configuration is designed to support synchronous redo transport between primary and standby database, which are far apart.

There are a few enhancements in 12c that might make a big difference in performance for a small investment in effort. One of the important enhancements comes from changes in histograms.

Kerry‘s favorite new Oracle Database 12c feature is the SQL Translation Framework. The feature grew out of SQL Developer’s ability to translate SQL from non-Oracle RDBMS’s.

Anyone who has anything to do with the RDBMS parts of the UK Oracle User Group probably knows Graham, as he ran the RDBMS SIG for years and years and years. He is no longer among us.

SQL Server:

Eating the elephant one bite at a time: knowing your tables.

Chris is talking about Point-In-Time Dimension Reporting in DAX.

Active Directory in Azure – Step by Step

You likely have heard about data warehousing, but are unsure exactly what it is and if your company needs one.

The SQL Server resources you just need to know about.

MySQL:

MySQL Server has an aborted_connect status counter which will show you the number of failed attempts to establish a new connection.

Change Password Of Server OpenSUSE 12.2 With ISPConfig 3 .

What kind of queries are bad for MySQL?

Hema Sridharan notices improved Backup Progress Reports in MySQL Enterprise Backup(MEB) 3.8.2.

Common Errors and Resolutions for Building your own MySQL or MariaDB C/C++ Program on Windows