by XTIVIA | Dec 27, 2019 | Blog, PostgreSQL
The most important function of a database is returning queries in an acceptable response time. Sometimes these response times do not meet expectations, and it’s important to know where to look to find out more information. Utilizing a built-in extension called...
by XTIVIA | Dec 17, 2019 | Blog, PostgreSQL
If you’re not familiar with importing data using DBeaver, then I encourage you to view my previous blog here: This time I will show you how to update data using a csv file inside DBeaver. Connecting to the csv File Right-click your database connection (or...
by XTIVIA | Dec 5, 2019 | Azure, Blog
Since Microsoft’s launch of Office 365 (O365) in 2013, it has changed the landscape of software/cloud technologies. There are a plethora of reasons for your business to choose Microsoft SaaS services for your day to day activities, but here are just a few key...
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...
