by XTIVIA | Jun 15, 2023 | Blog, SQL Server
Setting up and optimizing a SQL Server database on a Linux environment is an important task for database administrators. While there are similarities between setting up SQL Server on Windows versus Linux, there are also key differences that need to be considered. In...
by Cheryl Bryll | Jul 30, 2021 | Blog, MySQL
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...
by XTIVIA | Aug 20, 2020 | Blog, Oracle, SQL Server
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...
by Rebecca Mitchell | Nov 8, 2019 | Blog, SQL Server
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...
by XTIVIA | Nov 1, 2018 | Blog, SQL Server
Directory Tree: In Microsoft (MS) Windows, the C:\ drive is where your operating system (OS), programs, and other files typically reside. In Linux, this is known as the “root” directory and is represented with the forward slash character ( / ). In Windows,...
by XTIVIA | Jun 15, 2016 | Blog, Db2
Today is the day! On June 15, 2016, a new version of Db2 is being released! IBM has also announced that Db2 9.7 AND Db2 10.1 will reach “End of Support” on September 30, 2017. There is so much information flying out there, so I thought I’d share some...