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!
Removing an Azure Application ID Certificate When There are Multiple
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...
End of Support for SharePoint Workflows 2010 on SharePoint Online
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...
What’s a Database Health Check?
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,...
Creating a Windows Backup Image (Win10)
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...
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...