by XTIVIA | Nov 27, 2019 | Blog, PostgreSQL
There are many ways to import data into a database, some are pretty straightforward, and others are more complex depending on the type of data you receive and which format it is in. I will show you how to import data from an excel file using the DBA tool DBeaver. File...
by XTIVIA | Nov 25, 2019 | Azure, Blog, SQL Server
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...
by XTIVIA | Nov 22, 2019 | Azure, Blog
Azure Backup Service has risen from just being a simple flat file backup solution to an all in one sandbox for all your backup service needs. From BMR (Bare Metal Restore) to SQL databases, Azure Backup now gives you one centralized location to manage your data and...
by XTIVIA | Nov 7, 2019 | Blog, SQL Server
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...
by XTIVIA | Oct 24, 2019 | Blog, SQL Server
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...
by XTIVIA | Oct 8, 2019 | Blog, Db2
There are several scenarios where you might need details to re-build TSAMP. If TSAMP did not start properly after an upgrade or even while troubleshooting, the option to open a case with IBM and get root cause analyzed takes time. In many of these scenarios,...
