Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

  As you know, when you define SQL Server services through sql server configuration manager, they are automatically authorized with the minimum privileges they may …

  In this article I will describe how to connect to remote PostgreSQL database with PostgreSQL dblink. Dblink usage is similar to other databases. but …

  Script to monitor Health Instance on MongoDB Cluster [crayon-674190e016d1d169229224/] Note: Requires username and password with RootPrivileges.

  PostgreSQL supports the CSV file format as a native. You can import data from a CSV file and add it to a table, or …

  If you increase the INITRANS parameter in tables and indexes with very high I/O, it will make less I/O because multiple operations can be …

  When creating a SQL Login, you can select the Enforce Password Policy option as described in my article “How To Create a Login On …

  After SQL Server Setup has been performed, it is necessary to make some settings in Security Policy in Windows for the performance of SQL …

  You can use the between command (including the first and last value) to read the data between the two values in the table in …

  First, delete previous delimiter files which were offloaded from the archive log. This can be regenerated. [crayon-674190e0172a2421934177/]   Below command will archive Instance level …

First, check audit parameter in DB2 LUW; as you can see “audit active” is FALSE, which shows that currently auditing is not enabled on your instance. …