Every environment is configured differently; however, we have all experienced alerts being triggered due to unfavorable performance. Oftentimes, before our root cause analysis begins, the issue has resolved itself and/or someone may have rebooted. Although current...
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...
Overview This doc is a general overview of symptoms to look for in the event of a potential virus alert from your service support product, or a user calls in regarding a potential virus. We'll also cover what to do in the event of a potential virus on a PC. We are...
Overview This document will cover procedures for low disk space alert on OS/C: drives as well as general disk space low alert. Low disk space can have potentially negative consequences with a server. Some examples are: Unable to install critical OS security...
What is Needed to prepare for an email migration? As a system administrator, I have had my share of email migrations. Some have gone as smooth as can be, others not so much. With every situation being an opportunity to learn and grow, here are some tips I have learned...
THE PROBLEM While working with a client on a data migration from Microsoft SQL Server 2014 to IBM Db2 11.1, the client reported that the application was displaying the following error when attempting to read records from tables containing LOBs that we had just loaded....
With Windows Server 2008/R2, along with Windows 7 OS, approaching EOL (End of Life) in mid-January, it is time to start prepping your infrastructure for upgrades. Microsoft announced last year that if you migrate your SQL 2008-2008 R2 environment to Azure, they will...
With the release of SQL Server 2019 comes many new and exciting features, we can't wait to share the ones that made our top five list! Overall there were vast improvements in the database engine, security, database recovery, and several other areas. TempDB bottlenecks...
The worst call/email to receive, as a sysadmin, is that users are reporting their files "looking funny," only for you to see your client's file server was hit with ransomware. You start saying a prayer hoping your backups that ran overnight were successful, as you...
There may be a situation where you want to remove a node out of an Availability Group (AG) may be due to testing, something wrong with the server and need to build a new one, running out of space on that server so you can move files around, move the server to a...