by XTIVIA | Oct 6, 2021 | Blog, MySQL
What is a deadlock and what exactly does it mean in regards to databases? In order to fully define what a deadlock is, it’s important to note that a ‘lock’ itself occurs when multiple processes are simultaneously trying to access the same resource. A...
by Lina Weiss | Apr 27, 2021 | Blog, SQL Server
People choose to get certified for a variety of reasons. Many IT Professionals get certified to update their skills and give their resume the automatic boost that comes with certification. Other technology users may choose to get certified to become more well-rounded...
by Marc Petros and Klara Townsend | Mar 30, 2021 | Blog, Db2, SQL Server
The SQL Server Migration Assistant (SSMA) is a tool for transitioning from other platforms like Db2 to Microsoft SQL Server. A reference guide for the SSMA can be found in Microsoft’s SQL Docs. This article addresses the issue of failed migrations without...
by XTIVIA | Jan 8, 2021 | Blog, MySQL
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...
by XTIVIA | Dec 29, 2020 | Blog, MySQL
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...
by Ian Bjorhovde and Marc Petros | Sep 3, 2020 | Blog, Db2
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...