I’m about to head to Paris to present at the February meetup of the MySQL User Group in Paris, France. It happens 1st February from 6-8pm at the Patricks Irish Pub. Its free to attend, and I understand that SkySQL keeps this event afloat.

I’m also heading to my first FOSDEM right afterwards and will definitely hang out at the MySQL & Friends Devroom. There is an amazing lineup of speakers, with all talks being about 25-30 minutes, it looks like it is going to be a lot of fun. To boot, Michael “Monty” Widenius will also be there, so expect lots of Salmiakkikossu.

If you want to …

The first Central Virginia MySQL Meetup was a nice little howdy-do, and as a test flight, I think it showed that the bird can get off the ground quite nicely. So, with the generous help of our meeting host Meddius, we’re going to do it regularly on the 3rd Wednesday of every month. The next event is already scheduled – I will be talking about high availability options for MySQL.

MySQL Embedded Online Forum

Tuesday, January 31, 2012 9:00AM PST – 12:00 PM PST

Think You Know MySQL? Get the Facts.

MySQL is even better than you think. According to the experts, it’s easier to use and it’s more capable than most ISVs / OEMs realize, and by taking a few tried-and-tested steps before shipping your MySQL-embedded products, you can lower your product’s costs and increase its performance.

Join our expert-created and delivered MySQL Embedded Online Forum to learn:

Why MySQL is a great embedded database for startups as well as the largest software, hardware, and appliance vendors in the world, and how its features ensure costs remain low throughout an …

A recent trip to the SCALE Conference raised a few common questions. One of them was: does Oracle does offer a MySQL 5.5 exam ? I hope the links below help all of those that asked and others who might have the same question.

MySQL for Beginners (SQL-4401) This exam has been validated for MySQL 5.0, 5.1 and 5.5. They also offer a   MySQL 5 Certified Associate Exam
Oracle also now offers,  MySQL Specialization Criteria.


Related Press Release :New Oracle PartnerNetwork (OPN) …

I am honored to have been selected to give a 3-hour tutorial on white-hat Google hacking and other MySQL security topics at the 2012 Percona Live: MySQL Conference and Expo. The tutorial schedule can be found here and for more about the presentation I will be giving, you can see Google Hacking MySQL and More MySQL Security. I am also pleased that Percona has given a discount code for OurSQL: The MySQL Database Community Podcast listeners - 10% off any ticket price with code …

I’ll be presenting at MySQL Meetup in Raleigh,NC February 21,2012. The talk with be about Optimizing MySQL Configuration which I believe is a great topic for my first talk at this meetup group as it covers something every MySQL user has to deal with, also being something both beginner and advanced MySQL Users can learn a lot from. I’ll also bring High Performance MySQL 2nd edition for a drawing as well as exclusive discount codes for MySQL Conference and Expo 2012 in Santa Clara. See you there.

MySQL Stored Routines (functions and procedures) are not only used for improving performance but also they’re handy when it comes to enhancing security and restricting user access. This post briefs…

The post Access Control in MySQL Stored Routines: DEFINER, INVOKER & SQL SECURITY first appeared on Change Is Inevitable.

Tuesday, February 21, 2012
1:30 PM – 7:00 PM
(registration starts 1:00 p.m.)

Raffles Hotel Singapore
Casuarina Suite B, Level 3
1 Beach Road, 189673, Singapore

Please Register Online

The MySQL Developer Day is a one-stop shop for you to learn all the essential skills about MySQL. In this free, half-day seminar, we will cover everything you need to know to successfully design, develop, and manage your MySQL databases. You’ll also learn the guidelines and best practices in performance tuning and scalability.

Attend this event and gain the knowledge to:

Develop your new applications cost-effectively using MySQL
Improve performance of your existing MySQL databases
Manage your MySQL environment more efficiently

…

Dear Kettle fans,

Today I’m really excited to be able to announce a few really important changes to the Pentaho Data Integration landscape. To me, the changes that are being announced today compare favorably to reaching Kettle version 1.0 some 9 years ago, or reaching version 2.0 with plugin support or even open sourcing Kettle itself…

First of all…

Pentaho is again open sourcing an important piece of software.  Today we’re bringing all big data related software to you as open source software.  This includes all currently available capabilities to access HDFS, MongoDB, Cassandra, HBase, the specific VFS drivers we created as well as the ability to execute work inside of Hadoop (MapReduce), Amazon EMR, Pig and so on.

This …

Since one of our users has encountered a problem when modifying data via Data Editor, we decided to bring such a situation to our users’ attention.

Let’s assume you have the following table:

CREATE TABLE dept(
  DeptNo INT(10),
  DName VARCHAR(14),
  loc VARCHAR(13),
  Salsum FLOAT
);

Let’s execute the following query in the SQL document:

SELECT DName, loc FROM dept WHERE DeptNo = 20;

Now if you change any of the values of the first record in Data Editor, the changes will be applied to all records of the original table that have ‘DName’ = ‘Research’ and ‘loc’ = ‘Dallas’.

…