by XTIVIA | Apr 25, 2019 | Blog, PostgreSQL
Query Queues are set up in Redshift Workload Management and are designed to give the administrator freedom to assign more or fewer resources to given groups or users. On occasion, you will need to inspect these queues to see which queries are running in which queues...
by XTIVIA | Apr 11, 2019 | Blog, PostgreSQL
The number one priority in any production environment, beyond availability, is performance. End users want a smooth and quick experience, while the pressure mounts on you to deliver faster response times. Since PostgreSQL monitoring is arguably one of the most...
by XTIVIA | Apr 4, 2019 | Blog, SQL Server
Transparent Data Encryption(TDE) encrypts SQL and azure database files by encrypting data at rest. In a situation where your physical media such as data, log and backup files get stolen the malicious party can restore/attach the database and retrieve data. TDE...
by XTIVIA | Feb 21, 2019 | Blog, Oracle
Today I wanted to talk about some terminology that applies to multiple database platforms, however, I want to talk specifically to how it relates to the Oracle RDBMS. These four words seem to cause a lot of confusion and are often misused. The specific terminology or...
by XTIVIA | Feb 7, 2019 | Blog, Db2
After applying a Db2 fixpack, you can get SQL0443N when calling the get_dbsize_info() stored procedure. Cause and resolving the problem: get_dbsize_info() uses the system catalogs internally which do not get updated as part of a fix pack update, and should be updated...
by XTIVIA | Jan 9, 2019 | Blog, Db2
While implementing HADR for multiple standbys, there could be potential issues if the HADR ports are not hard-coded on the HADR settings. Here’s what the issue looks like: The primary is dbpp.example.com The standbys are: 1st – dbps.example.com 2nd –...
