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

This article contains information about mysql safe mode such as start mysql in safe mode, find mysqld_safe location, changing password. MySQL Safe Mode Sometime you …

  1.Check error log to find the tempdb full. 2.Find out the space free in tempdb using [crayon-67d48ec2ba451881893697/] 3.dum tran with truncate only if still …

  In this article I will explain some information about SQL Server System databases. System databases are created automatically when you install SQL Server. The …

  What is Teradata: Teradata is a relational database management system (RDBMS) that is: an open system, running on a UNIX MP-RAS or Windows server platform. capable of …

  The prevalent influence of technology has resulted in a widespread use of a variety of devices such as cell phones, sensors, web API’s and …

Replication lag Typically, in our replica sets, we monitoring the replication lag, that is a measure of who far a secondary is behind the primary: …

Error : The DBSNMP user is locked after a certain period of time. Reason: An application (possibly an application in EM) is trying to login …

Description: Drop tables is such a common content of a DBA’s daily work. Drop a small table( such as less than 100 Mega Bytes ), we …

  With using triggers in PostgreSQL, you can trigger another event before an event occurs (BEFORE TRIGGER). Or you can trigger another event after it …

Description: Recently, when i checked my data on two MySQL servers( version: 5.7.17 ), i found data differences between to servers, which surprised me. Because …