Rob Gravelle

Passing Field Names to MySQL Crosstab Stored Procedures
MySQL Input Parameters Add Flexibility to Crosstab Stored Procedures
MySQL Prepared Statements to Generate Crosstab SQL
MySql View Technique for Grouping Crosstab Column Data
MySQL CASE Statements in Multi-Aggregated Crosstab Columns
MySQL Multi-Aggregated Rows in Crosstab Queries
Tips for Simplifying Crosstab Query Statements

DIY Number Rounding For MySQL
Three Handy MySQL Numerical Functions
Using the InnoDB Memcached Plugin with MySQL 5.6
Perform Row Operations Using MySQL Cursors
MySQL Cursors and Loops
MySQL General Security Tips
New Query Optimizer Features in MySQL 5.6
All About the MySQL 5.5 LOAD XML INLINE Statement
Performing Full-text Searches in MySQL 5.6
Comparing SQL Server and MySQL Functions
Mapping Data Types between MySQL and SQL Server
Comparing TokuDB to MySQL 5.5 with InnoDB on Small Databases
Challenging MySQL Trigger Operations Made Easy
The Wonderful (and not so Wonderful) Things about MySQL Triggers
A Case for (Occasional) Denormalization of MySQL Data
Testing Your MySQL Stored Procedures with MyTAP
Handling Slow Processes in MySQL
Email Job Failures Report to DBA using PowerShell
Restore Your MySQL Database from a Backup Using PowerShell
Understanding the MySQL Information Schema Database
Automate Database Backups with MySqlDump and PowerShell
Create MySQL Databases and Tables from a PowerShell Script
Automate MySQL Queries with PowerShell
Running Commands Against Your MySQL Databases using PowerShell
The Pros and Cons of MySQL Table Locking
MySQL's User Privileges Model for Access Control
How MySQL Protects Your Password
Securing the MySQL Root Account
Achieving Five Nines Availability Using Synchronous Cluster Replication for MySQL
Database Buyer's Guide Conclusion: Which Database Is Best for You?
Cloud Database Buying Guide
Database Buying Guide: Open Source Databases
IBM DB2 Database Buying Guide
Microsoft SQL Server Buying Guide
Oracle Database Buyer's Guide
Desktop Database Buying Guide
Database Buyer's Guide, Part 2: Features, Features, Features
Should You Move Your MySQL Database to the Cloud?
Beyond the LIKE Operator: Advanced Pattern Matching with MySQL
Three Ways to Identify Non-matching Records in MySQL
Database Buyer's Guide: Database Types and Features
Converting between MySQL Date and Time Formats
Using MySQL's Analysis Tools to Improve Query Performance
Identify Slow Queries using MySQL's Analysis Tools
Top 10 MySQL Best Practices
Writing Reusable Queries in MySQL
Limiting the Number of Rows in MySQL Result Sets
Optimizing MySQL Query Retrieval Speed Through Table Joins
Use Derived Tables in Your MySQL Queries to Improve Database Performance
Eliminating Duplicate Rows from MySQL Result Sets
Clearing a Path through the 3NF Join Jungle
Cardinality in MySQL Data Modeling
How Operator Precedence Affects MySQL SELECT Queries
Disambiguating between Duplicate Column Names in MySQL
Identifying and Eliminating the Dreaded Cartesian Product
MySQL SELECT Statement 101
Five Handy Tips for MySQL's Powerful UPDATE Statement
MySQL INSERT Statement Variations
MySQL Data Manipulation and Query Statements
Top 10 MySQL GUI Tools
Passing Field Names to MySQL Crosstab Stored Procedures
MySQL Input Parameters Add Flexibility to Crosstab Stored Procedures
MySQL Prepared Statements to Generate Crosstab SQL
MySql View Technique for Grouping Crosstab Column Data
MySQL CASE Statements in Multi-Aggregated Crosstab Columns
MySQL Multi-Aggregated Rows in Crosstab Queries
Tips for Simplifying Crosstab Query Statements
Harmonizing Character Encoding Between Imported Data and MySQL
All About the Crosstab Query
More Efficient and Readable Select Queries with MySQL Subqueries
XPath Support for Working with XML Data in MySQL
Data Formatting, Working with XML Data in MySQL
Working with XML Data in MySQL
Make Your MySQL Queries More Efficient with Temporary Tables
Maximizing Query Performance through Column Indexing in MySQL
Tips for Managing Complex Queries
Fetching Data from Multiple Tables using Joins
Running MySQL in Batch Mode
Enhance your Queries with Stored Functions
Creating Stored Procedures in MySQL Using HeidiSQL 4's Stored Routine Editor
Write SQL Code for MySQL Using HeidiSQL 4