Director of Training, Percona
Throughout his career, Bill has shared his knowledge to help other programmers achieve success and productivity. Bill has answered thousands of questions, giving him a unique perspective on SQL mistakes that most commonly cause problems.
This is a step by step demonstration of methods of complex query development and optimization in MySQL 5.6. When presented with a complex problem, developers struggle to solve it in SQL.
When backing up a database in the cloud, many people are forced to choose between using command-line tools, or else writing a custom script to export data. We may not have privileges to use command-line tools in a cloud environment. Writing your own data dump script is deceptively complex. This presentation outlines a simple PHP class I've written that creates backups in the same format as... [read more]
"Don't bother me with DBA 'best practices,' we have real work to get done." So go the famous last words from overworked IT managers (we’ve all been there at one time or another). Best practices don't have to interrupt your work or make it harder. Ideally, they should make database operations more predictable and less fraught with emergencies or surprises.