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

Nelson Mandela, The Madiba, said: ” There is nothing like returning to a place that remains unchanged to find the ways in which you yourself have altered.” Bloggers return to their blogs to experience the same charming thing, and database bloggers are no different. Enjoy this edition of Log Buffer.

Oracle:

With the new release of Oracle Database 12c, Oracle has removed the old Database Console.  In its place, they have given us Enterprise Manager Express (EM Express for short).

And here is a perspective about Why Not to Upgrade to Oracle 12c Database.

Sayan Malakshinov talks about Oracle 12c: Lateral, row_limiting_clause.

Garth is creating an Oracle 12c Pluggable Database & Container Database using DBCA.

Pete Finnigan talks about Oracle 12c security.

Jonathan Lewis is getting statspack onto 12c with containers.

SQL Server:

Have you ever wondered how to create all of those special characters called symbols? Well, you are in luck today.

If you think uninstalling SQL Server is a pain, have fun with Oracle.

Shaun Stuart writes about running SSMS under a different Windows Account.

Ashish Banga mentions named pipes error in MOSS 2007.

Jen Stirrup makes a note to self that PrerequisiteInstaller.exe app crash when you try to install SharePoint 2013.

MySQL:

If you’re setting up MySQL Cluster on Oracle Linux or another Linux such as Red Hat, CentOS, or Fedora, you might have come across some problems getting the nodes to communicate.

An SST is a full backup of one of the nodes in your database already.  If you want another backup, you may as well just run xtrabackup yourself.

MySQL Connector/Python v1.0.11 is a new version of the 1.0 production release of the pure Python database driver for MySQL.

There’s a lot of talk on the web about scalability. Making web applications scale is not easy.

Memcache access for MySQL Cluster (or NDBCluster) provides faster access to the data because it avoids the SQL parsing overhead for simple lookups – which is a great feature.

Jonathan Levin made a new tutorial for how to use MySQL to develop Big Data Applications.