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 –...
by XTIVIA | Nov 15, 2018 | Blog, SQL Server
There are times when a Developer or DBA needs to determine the best performance options with transferring data through a linked server from point A to point B but may not know the best way to do it. In the following example, I am going to show you the differences...
