Our blog is an invaluable resource for anyone struggling with the challenges of managing a database, applications, or clouds.
We understand the difficulties involved in troubleshooting, building, improving, securing, and operating these platforms,
and we’re here to share our insights and expertise with you. Browse through our collection of blog posts below,
and don’t hesitate to leave your comments and feedback.
If within a MySQL instance a schema name such as "#mysql#lost+found" or "#lost+found" is listed when the "show schemas" or “show databases” command is run, it's not a true schema but will appear when MySQL is installed in a root directory on a Linux server. At the...
There's often confusion over why MySQL users are created with a host of localhost in addition to a user created with wildcard, %, for their host. create user 'some_user'@'localhost' identified by 'some_password_here'; create user 'some_user'@'%' identified by...
Because even DBAs need a little holiday humor, and we all know how SQL query plans can go.
I wanted to get this quick-read out there, as I recently ran into this issue and didn't see any articles about a remedy for it. Here's some background: I've set up an NPS server in Azure for a client so they can leverage the NPS MFA extension that you can integrate...
It feels like we have to deal with the compounding disruption of innovation on a yearly basis as software companies evaluate their product line, advancing some business solutions while retiring others. As with every other software vendor, the Microsoft 365 product...
As a critical component of your business, a healthy database is vital to staff efficiency and customer satisfaction. If you've neglected database maintenance and tuning, chances are you're running into a litany of performance issues. When your database begins to lag,...
The following instruction will walk you through how to create a Windows OS backup in the event you need system image restore. An image backup copies everything on your drive, including partitions and the boot sector. It's the only way to back up your Windows...
Poor database performance bogs down operations, and as the lifeblood of a business, companies can't afford barriers to data access. One of the best ways to navigate past performance issues is by getting a regular database performance audit. Just like a car needs...
Overview From time to time, you'll encounter a situation where a server appears to be offline, and you need to verify the validity of the alert prior to contacting proper support channels. This document covers certain steps that can be taken for verifying an offline...
Informix 11.70 database versions will be out of support as of September 30, 2020. For Informix users, this means IBM/HCL is discontinuing security updates, patches, and other services (even if you have an existing maintenance contract). For the Informix DBA, this...