Rob Gravelle

Monday May 28th 2012 by Staff

Rob Gravelle's Database Journal articles.

Rob Gravelle resides in Ottawa, Canada, and is the founder of Rob has built systems for Intelligence-related organizations such as Canada Border Services, CSIS as well as for numerous commercial businesses. Email Rob to receive a free estimate on your software project. Should you hire Rob and his firm, you'll receive 15% off for mentioning that you heard about it here!

In his spare time, Rob has become an accomplished guitar player, and has released several CDs. His former band, Ivory Knight, was rated as one Canada's top hard rock and metal groups by Brave Words magazine (issue #92).


MySQL Crosstab Queries

Current Articles

- Selecting WordPress Metadata
- Real-time MySQL Performance Monitoring
- Navicat 12: An Overview
- Speeding up MySQL Data Imports
- Implement a Secure WordPress Search
- Working with WordPress Result Sets
- Querying the WordPress Database
- Pivot Aggregate Counts on Months in MySQL
- Applying MySQL’s GROUP_CONCAT Function to Multiple Columns
- Why You Should be Using the MySQL GROUP_CONCAT Function
- Listing Duplicate Values by Group
- Top 6 MySQL DBA Mistakes
- Selecting the Top N Results by Group in MySQL
- Querying Multiple MySQL Tables
- MySQL Tuning for Large Datasets
- Calculating MySQL Database, Table, and Column Sizes
- Simplifying MySQL Database Design using a Graphical Data Modeling Tool
- In Search of a Regex Replace Function for MySQL
- MySQL Collaboration in the Cloud
- Searching on JSON Values in MySQL 7
- Working with JSON Data in MySQL 7
- Top 10 MySQL Reporting Tools
- MySQL Pattern Matching using Regular Expressions
- The Problem with Statistics
- Common MySQL Insert and Update Tasks and Their Solutions
- A Roundup of Popular MySQL Mobile Apps for Android
- MySQL Error Handling using the Signal and Resignal Statements
- Top 10 MySQL GUI Tools
- Exploring MySQL 5.7’s Geo-Spatial Functions
- Debugging MySQL Stored Procedures
- Building MySQL Crosstab and Subreports
- MySQL: Calculating Distance Based on Latitude and Longitude
- MySQL Union and Union All Operators Primer
- Generating Reports on MySQL Data
- MySQL Fuzzy Text Searching Using the SOUNDEX Function
- Guarding Your Data against Cyber Attacks
- MySQL Workbench 6.2 Performance Reporting
- An Overview of the MySQL Performance Schema
- Manage your MySQL Data on the Go with Navicat Cloud and iOS
- MySQL Goes Mobile: A Roundup of Popular MySQL Mobile Apps for iOS
- MySQL Date Gotchas
- MySQL Numeric Overflow Gotcha
- Importing Into MySQL from Other Databases
- How Safe is Cloud Storage?
- Importing XML, CSV, Text, and MS Excel Files into MySQL
- Enhance Your MySQL XML Import Procedures using Prepared Statements
- Importing XML Data into MySQL Tables Using a Stored Procedure
- Assigning Roles to MySQL Users
- Converting Between Data Types in MySQL
- Rounding Down, Bankers Rounding, and Random Rounding in MySQL
- Locating Instances of a Word or Expression within a MySQL Database
- 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

Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved