MySQL

Displaying Leading and Trailing Whitespace on Varchar Columns in MySQL

It's fairly trivial to enclose varchar data within quotes using the CONCAT() function …

Monitor Your MySQL, MariaDB and Percona Servers with Navicat Monitor

The latest player to enter the database monitoring arena is Navicat. Rob Gravelle …

Web-based Database Management

Web-based database admin consoles have been somewhat limited, with the vast majority of …

RDBMS Management on macOS

While most DBMS apps focus on a specific database product, a few have gone the extra …

Best New Features of MySQL 8

Even though there is no official software release to download and use yet, the list of …

Ransomware Attacks Against MySQL and How to Avoid Them

In February of 2017, hundreds of MySQL databases were erased and replaced with a ransom …

Manage your Cloud MySQL Instance from Anywhere

Modern smartphones and other mobile devices have ushered in a new work paradigm where …

Configuring a MySQL Database on Amazon RDS

Although concerns about ownership and security persist, many companies have embraced …

Troubleshooting MySQL Performance Issues Using the Slow Log and Performance Schema

With so many causes and solutions of a database slowdown, you might expect to be …

Selecting WordPress Metadata

It pays to get a solid handle on how metadata is stored and retrieved in WordPress. In …

Real-time MySQL Performance Monitoring

A key part of keeping your MySQL database running smoothly is the regular monitoring of …

Navicat 12: An Overview

Navicat Premium 12 is a robust solution that is geared towards DBAs who would benefit …

Speeding up MySQL Data Imports

Previous articles have described a way to overcome MySQL's import restrictions using …

Implement a Secure WordPress Search

Rolling your own search is especially advantageous for WordPress sites that include a …

Working with WordPress Result Sets

Whether you’re fetching a single row or an entire result set, WordPress offers …