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...
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...
