by XTIVIA | Feb 20, 2020 | Blog, Db2
In my previous blog, I presented some of the issues you can run into when setting up one auxiliary HADR standby and a potential solution. This blog discusses setting up two auxiliary standby databases in detail. Let’s start with all the information we need to...
by XTIVIA | Feb 13, 2020 | Blog, Database
Data is the lifeblood of your business, which means taking care of it is essential for operating your business. Whether your company uses SQL Server, Oracle, Db2, or PostgreSQL, quality database support, maintenance, and protection must be an integral part of your...
by XTIVIA | Feb 7, 2020 | Blog, SQL Server
What is Needed to prepare for an email migration? As a system administrator, I have had my share of email migrations. Some have gone as smooth as can be, others not so much. With every situation being an opportunity to learn and grow, here are some tips I have learned...
by XTIVIA | Jan 30, 2020 | Blog, PostgreSQL
Table of contentsSlow QueriesMulti-Tenant QueriesHot Queries Using pg_stat_statements, we’ll look at several ways to identify queries with slow response times and those that are heavily used. If you’re not familiar with how to enable pg_stat_statements,...
by XTIVIA | Jan 14, 2020 | Blog, PostgreSQL
If you’re not familiar with importing data using DBeaver, then I encourage you to view my previous blog here. When importing data, sometimes you receive data that isn’t in csv format. The delimiter is tabbed, barred or others. DBeaver’s csv driver...
by XTIVIA | Jan 7, 2020 | Azure, Blog
Backups have always been a crucial asset in today’s continuous battles to control and protect our data. Every day, your data protection is being challenged continuously by malicious malware and viruses to hold your data hostage and have you pay fees to get it...
