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!
In this blog, I will cover some typical TNS errors that we run across as an Oracle DBA and how to go about troubleshooting the errors. First of all, when you encounter a TNS error you need to understand that it relates to the network communication between a client...
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...