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...
by XTIVIA | Sep 18, 2020 | Blog, Database
Poor database performance bogs down operations, and as the lifeblood of a business, companies can’t afford barriers to data access. One of the best ways to navigate past performance issues is by getting a regular database performance audit. Just like a car needs...
