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!
Understanding thread concurrency can help troubleshoot performance issues by optimizing how InnoDB multitasks between transaction requests simultaneously, but it is not a simple FIFO (first in: first out) process. That would not be efficient or leave much for a DBA to...
Background When running a batch file on MySQL the login credentials must be taken from some file. The file choices are to use a clear-text options file or the more secure obfuscated login-file generated by the MySQL program mysql_config_editor (which comes installed...
Recently, I was working on a system and noticed some odd behavior – running a simple db2pd command was taking what felt like a "long" time. I used the time utility to validate my impression: db2inst1@db2server $ time db2pd - Database Member 0 -- Active -- Up 0 days...
In this tutorial, I will go over the steps to clone your MySQL instance on the same server. This tutorial will only cover the steps to accomplish a clone on a Linux server. To ensure you do not cause corruption to the existing MySQL instance you will need to ensure...
Normalization is not that complicated. In fact, the beauty of these rules is that you may not know you're already applying them in your database design. To demonstrate, over the course of this multi-part series, we'll be covering the three generally accepted levels of...
The most satisfying meal is the one you make yourself, and database backup jobs are no different. Many DBAs use maintenance plans as a "one-stop-shop" for maintaining their SQL Server databases. After all, they do backups, integrity checks, index maintenance... What...
There are many reasons to install Windows Guest Additions for Oracle VM VirtualBox: mouse pointer integration, enable shared folders and clipboard, optimal video support, as well as generic host/guest communications. The most notable feature is the ability to resize...
This checklist outlines the steps I took to migrate SQL Server Always On 2017 Enterprise to 2019 Enterprise edition. Having mixed versions of AG's is a temporary solution meant for upgrading or migration purposes only and is not intended for long term use. Preparing...
July 13th, 2021 is quickly approaching. This is the date Microsoft has announced as the end of Mainstream Support for SQL Server 2016. What does this mean for the large number of Servers and applications using SQL Server 2016? You feel like you just completed your...
Starting from Oracle19c cloning your oracle home is a bit different, whether you use this method for out of place patching or rolling out patches to multiple servers we no longer use clone.pl, instead oracle recommends using the software-only install option, available...
