The MySQL Windows Experience Team is proud to announce the release of MySQL Notifier version 1.1.4, the  latest addition to the MySQL Installer for Windows.

MySQL Notifier 1.1.4 introduces the following features:

• Monitoring of services in remote Windows computers (any service, not only MySQL Server services, similar to the local services monitoring offered in MySQL Notifier 1.0.3) via asynchronous Windows Management Instrumentation. Monitored services are grouped by computer name where the topmost is the Localhost. After a service in the Localhost or a remote computer is added to the monitored list, the MySQL Notifier automatically monitors for MySQL Server services addition (this option can be turned-off by users).
• Monitoring of MySQL Server instances on any platform via a timer configurable by users.  These instances are monitored via MySQL Workbench connections which are automatically …

My slides for presentations on MySQL Backup and Recovery Essentials and Understanding and using MySQL in the Cloud from the Oracle Technology Network (OTN) event in Medellín‎ Colombia are now available.

Thank you to the Colombia Oracle Users Group for inviting me to the event.

This is either too funny or too sad.

An acquaintance sent me this image from a cyber cafe or hotel in Russia. It says that my blog site is prohibited and violates Russian law, and that they’re blocking my site in accordance with the Russian Federal Law of 27.07.2006 No. 149-FZ.

All I can say is, “Wow!” I didn’t know that stuff about writing programs, web pages, and solving generic database and operating system problems was so sensitive. For that matter, I didn’t know what I post would interest any government. I half wonder whether my friend’s pulling my leg.

As I reflect on it, could it be that Oracle post on how to write an encrypted object type? or, how with proper OS credentials …

SQL tidbits are always valuable and highly searched for by newbies (as opposed to reading the SQL documentation). Sometimes we seasoned SQL developers take for granted little things like when a single- or multiple-character wildcard comparison works. It seems we know what newbies don’t. That you need a wildcard comparison operator not simply and equality comparison operator.

The question posed to me was, “Why doesn’t my wildcard comparison work?” Here’s a simplified example of their question.

SELECT 'Valid' AS "Test"
FROM    dual
WHERE  'Treat' = 'Tre_t'
OR     'Treet' = 'Tre_t';

Naturally, the answer is that the equality operator compares the strings based on their exact match (character sensitively in Oracle and character insensitively in MySQL). It needs to be rewritten by replacing the equals (=) comparison operator with the LIKE …

I registered yesterday for Oracle OpenWorld 2013, and I’ll look forward to seeing friends there. Having worked in the Oracle 12c beta for a year, I’ll be interested in the presentations. Also, hearing more about Java 7 at JavaOne. On the downside, I’m missing MySQL Connect this year.

Cloud computing offers many possibilities, and container and pluggable databases are a great solution. We’ve two new acronyms with the Oracle 12c release. A containerized database is a CDB, and a pluggable database is a PDB. I’m looking forward to seeing more about the provisioning of PDBs during the conference. If you’re new to the changes, check out CDBs and PDBs in Chapter 17 in the …

There is a tsunami of blog posts out there as Oracle has made public its 12c database and SQL Server and MySQL with numerous new offerings. This Log Buffer Edition covers a few salient blog posts.

Oracle:

Among the major ETL tools in the market , Oracle Data Integrator outshines not just for a couple of reason. Oracle has invested a lot in developing the tool after it took over from Sunopsis.

You want to learn more about innovative features of WLS 11g and 12c? You want to get answers about the roadmap and capabilities?

Kristin Rose tells us that 12c  offers the latest innovation from …

Finally, Connector/Python v1.1.0 is out. It’s the first of a series of alpha releases which will bring some new features. Check out the Change History if you want to keep up with what is being added and changed.

Notable changes for v1.1.0:

• Connector/Python v1.0 was known to work with Python v2.4 and 2.5. We now break compatibility with these older Python versions.
• MySQL Prepared Statements are supported using cursor.MySQLCursorPrepared.
• You can find out whether there is an ongoing transaction by checking MySQLConnection object’s property in_transaction. …

Over at David Stoke's Open Source DBA blog, the following was posted: http://opensourcedba.wordpress.com/2013/07/05/mysql-is-looking-for-external-contributions My reply: Allow me to contribute code with a BSD (3-clause) license without having to sign anything new and then we can talk. Don’t tell me that it can’t be done: Oracle already has some code of mine in another product which was

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.

…

MySQL for Visual Studio is a new product including all of the Visual Studio integration previously available as part of Connector/Net.  The product is now released as GA and is appropriate for use in production environments.  It is compatible with MySQL Server versions 5.0-5.7 and Visual Studio versions 2008-2012.