SAP ASE Warm Standby Database using Replication Server
PostgreSQL: Password authentication failed for user “postgres”
When logging into PostgreSQL, an error message may appear like this: When PostgreSQL installs on Linux, by default no password…
PostgreSQL: Allow Remote Connection to Connect Database
When a client machine tried to connect the PostgreSQL Server, it got an error like “psql:could not connect to server:Connection…
Difference Between 2k, 4k, 8k, 16k Logical Page Size in SAP ASE
The main difference between a 2K, 4K, 8K, 16K page size is the amount of data stored on it. The…
Optimizing tempdb Performance
What is Stored in tempdb? tempdb is used to store three different categories of temporary data: User Objects Internal Objects…