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

  Pre-Installation Setup Before installing Cassandra in Linux environment, we require to set up Linux using ssh (Secure Shell). Follow the steps given below for …

  Following query will verify if any DBQL rule exists: locking table DBC.DBQLRuleTbl for access [crayon-673f26ff8c278945376296/]   Note: View DBC.DBQLRules OR DBC.DBQLRulesV can also be …

ERROR: When opmn services are started, the following error is being received. BIND (Address already in use) x.x.x.x: 393478144 – listener BIND failed [crayon-673f26ff8c5d5723465655/] When …

In this article, we will install SQL Server 2014. Other versions can be installed in similar ways. Stand-Alone means installing only one instance on a …

  As a Database Administrator, Monitoring of database is the most important part. As all we know Prevention is better than cure, So. I am …

  You can encounter this problem on HP-UX platforms. PROBLEM: Many trace files are being created with the error “Ioctl ASYNC_CONFIG error, errno = 1”. …

  Pre-Migration : Questionnaire That need to ask from the client before planning to migrate SAP Sybase ASE database servers from physical machines to virtual. …

  The Percona Toolkit contains many tools for MySQL. Usually, we use the pt-archive to archive our data. Pt-archive can archive the table data to …

  On day to day activity we often get situation when the database has a lot of space left but query fails with “2644: No …

  We are going to create warm standby backup of SAP Sybase ASE Prod1 server to Standby1 server using Sybase Replication Server REP15_7 for a database …