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

There is no great joys for the bloggers to mark the holiday season with some blistering and lightweight blog posts. This Log Buffer Edition in Log Buffer #302 shares that mirth and presents you with another medley of blogs.

Oracle:

Eddie Awad asks; Have you installed or recently upgraded to Oracle APEX Listener 2.0? Have you used SQL Developer 3.2 to manage APEX Listener settings? If you answered yes to both questions then you are in for an unwelcome surprise.

It’s the end of the year, and the start of the year, and thus time for the ‘best of’, ‘ten best’ and perhaps even ’12 best’ articles for the zodiacally minded. Here are a few choice samples from Christopher Gait.

Here unfolds the slow JDeveloper startup mystery.

Harald van Breederode is demystifying ASM REQUIRED_MIRROR_FREE_MB and USABLE_FILE_MB.

The beginning of a new year is a time of resolutions and I’m sure this year is no exception. Kathryn Perry writes.

SQL Server:

On local instance of Pradeep Adiga, SQL Server service failed to start. The SQL Server error log had the following entries in it.

We all know that statistics get updated when you rebuild your indexes, right? Thomas expounds.

James shares experience of installing Master Data Services (MDS) in SQL Server 2012 or installing SQL Server 2012 sp1 (and possibly a CU).

For Denny, It is time again to take a little peak at the last year (as far as my blog goes) and see just what was the most popular posts.

Datachix has got a great idea to start the 2013.

Jason Strate is wrapping up 2013.

MySQL:

Is there a room for more MySQL IO Optimization ?

Alex Bolenok writes about emptry row if condition doesn’t match.

Ronald Bradford is installing MySQL MHA with Percona Server.

Why your cloud is speeding for a scalability cliff, Sean Hull wonders.

The main goal of global transaction ID is to make it easy to promote a new master and switch all slaves over to continue replication from the new master.

PostgreSQL:

David Wheeler is trusting the Sqitch, but cautioning about verifying first.

When Andrew Danstan moved the Buildfarm code from pgFoundry to GitHub, he started distributing release tarballs from there too.

Chris Travers is back from a break due to working hard on getting LedgerSMB 1.4 closer to release.

Having covered why nulls exist and how they can be created explicitly and implicitly, let’s look at how NULLs behave by looking at some specific examples with Bruce Momjian.

Peter Eisentraut is trying PostgreSQL with Jenkins and enjoying it.