My Job in a Nutshell

Pages

(http://www.commitstrip.com/en/2014/08/01/when-i-help-a-rookie-coder-fix-his-queries/)

Developing Internal Business Applications with PHP

Image via Wikipedia Recently, my company has decided to go full (or mostly) open source by moving away from Microsoft technologies. This is ...
Open Source ETL tools vs Commercial ETL tools

Image via Wikipedia Recently I have been asked by my company to make a case for open-source ETL -data integration tools as an alternative ...
How to Safetly Restart Your MySQL Slave Server

Make sure that nothing can access it (take it off the load balancer). in mysql client do: STOP SLAVE; in mysql client do: FLUSH TABLES; ...
Storing Conditions in the Database

Caching Business Logic in the Database I had this relatively simple idea of storing conditions in the database. The idea is to store the con...
JSON and MySQL Stored Procedures

You probably heard that MySQL 5.7 supports JSON. But did you know that you can also use JSON with MySQL Stored Procedures - making them ver...
Mastering MySQL Indexing

Indexes are tricky things. In my experience, indexes are added whenever SQL queries are too slow. This makes sense. However, sometimes these...