So far, I have been blogging about curious RDBMS caveats mostly related to Oracle and MySQL databases. Some examples: You never stop learning about Oracle features NOT IN vs. NOT EXISTS vs. LEFT JOIN / IS NULL: MySQL SQL incompatibilities: NOT IN and NULL values MySQL Bad Idea #384 But there are also other databases, … Continue reading 10 Things in SQL Server Which Don’t Work as Expected →

We have forums available to help you answer your questions when dealing with our Windows products.  You can post questions, answer other user's questions, and find solutions to your own problems there.   You can find these forums along with many other resources in our Development Zione found at http://dev.mysql.com/.  The forums are located at http://forums.mysql.com/.

 Here are the forum links for our products:

• Connector/Net - http://forums.mysql.com/list.php?38
• MySQL for Visual Studio -http://forums.mysql.com/list.php?174
• MySQL for Excel -  …

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. …