We can not take the backup of the database and transfer it to the test environment for security reasons. Because the actual data should …
Read More »Primary index concept in Teradata
Every table must have at least one column as the Primary Index. The Primary Index is defined when the table is created.There are two reasons you …
Read More »Sybase Questions
1)How to Calculate Memory Usage and Disk Space Usage? There are 2 stored procs which help you to calculate the memory size and database …
Read More »PG Log File Maintenance and DB Corruption
It is a good idea to save the database server’s log output somewhere, rather than just routing it to /dev/null. The log output is invaluable when …
Read More »PostGre SQL Database Maintenance
PostgreSQL, like any database software, requires that certain tasks be performed regularly to achieve optimum performance. The tasks discussed here are required, but they are repetitive in nature …
Read More »PG DB Optimization
Overview This article briefs us on how to tune a database or make it work faster Max connections: We can configure the maximum number of …
Read More »PG Tuning, Statistics and Indexes
Database Tuning Fundamentally, database performance tuning is done for two basic reasons, to reduce response time and to reduce resource usage, both of which can apply …
Read More »PostgreSQL Basics
Overview PostgreSQL, often simply Postgres, is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards compliance. As a database server, its primary functions are to store …
Read More »SQL Server 2017 Setup on Redhat Linux Or Migrate SQL Server 2012 DB on Window Server to SQl Server 2017 on Redhat Linux
SQL Server 2017 is supported on Red Hat Enterprise Linux (RHEL), SUSE Linux Enterprise Server (SLES), and Ubuntu. It is also supported as a …
Read More »How to build a MySQL on Linux quickly?
This article introduces how to build a MySQL on Linux quickly. This’s often used to build a temporary MySQL for testing. In short, we only need …
Read More »