by XTIVIA | Feb 18, 2021 | Blog, SQL Server
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...
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 XTIVIA | Oct 9, 2020 | Azure, Blog
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...
by XTIVIA | Sep 24, 2020 | Blog, Database
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...
by XTIVIA | Sep 22, 2020 | Blog, Microsoft
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...
