Category: MySQL

  • Thoughts on Data Masking

    Often times, production data needs to be moved to different environments for testing/developing purposes. However, some of that data can be people’s name, birthday, address, account number, etc., that we don’t want testers and/or developers to see, due to privacy and regulatory concerns. Hence the need to mask those data. I can certainly see this […]

  • Convert character set to utf8 in MySQL

    Update: If you are interested in automating this task with a simple Perl script, I created one here. Say, you had a MySQL database that stores texts in languages such as Chinese, Japanese, Korean, Hebrew, Arabic, and so on, and recently there was a server move or upgrade, and all of sudden text in the […]

  • In Santa Clara for MySQL conference

    It was a clear sky in LA, but looking down, the city seemed to be covered in smog. After working on Sql Server 2008 material in LAX airport for a while, I boarded a turbo-prop for San Jose. Landing time was windy, so it was a bit bumpy. The only flight attendant, Cindy K, joked […]

  • Some notes on Sql Server and MySQL

    I will take MySQL certification exams, therefore I am going through MySQL 5.0 Certification Study Guide. It is a pretty cool book in that it goes to the point right away without many wasted words. Too many technical books dance around the topic, fill the volume with screen shots, but do not deliver the goods […]

  • Analyzing low performance SQL code

    As an independent consultant and trainer , I found myself doing a lot of existing code analysis and enhancement, mostly for stored procedures and ad-hoc SQL statements. I suspect a lot of people do the same thing as well, so I am really interested in learning how you do it. That’s the main purpose of […]