Our blog isn’t just a record. It’s a resource.
We know how difficult managing a database can be. Luckily, we’re here to share our experiences troubleshooting, building, improving, and operating them. Browse blogs below, and feel free to comment!
The Basics of Database Performance Tuning
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...
Verifying a Server is Offline
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 v11.70 End of Support (EOS)
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...
Using the Mysqlbinlog Utility
MySQL binary logging is used for replication and also for point-in-time recovery of a MySQL database instance. It records any changes to database contents and may be recorded in a "statement-based" or "row-based" format. The default location to find the binary logs is...
Resolving SQL0930N Memory Errors after an RHEL 7.8 Upgrade
A colleague and I were recently working on a Db2 server with a large amount of memory (512 Gb) and were supporting the system administrators in applying operating system maintenance to bring the system from RedHat Enterprise Linux (RHEL) 7.6 to RHEL 7.8. The operating...
Archiving Methodology in Office 365 Using a Shared Mailbox
This article covers an SOP scenario that can be adopted in an online exchange environment for archiving active mailboxes for future access. The benefit of this feature is the capability to control access to the archived mailbox and a money-saving tool (as shared...
Linux OS and File System Tuning for Database Servers
The Linux OS from major vendors, including Red Hat, Ubuntu, and Debian, has defaults set out of the box that works well with minimally spec'd hardware. However, if you want the best performance for your MySQL databases, you need to make changes in how Linux handles...
Oracle Create a Wallet to Store Secure User Credentials for RMAN Connection
In this blog, I'll be giving a tutorial on an Oracle hidden gem using an Oracle tool to securely allow you to run RMAN without passing the password in cleartext. The Oracle Database Secure External Password Store feature, which does not require any additional license...