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

  Constaint allows us to set specific rules for data in a table. For example; to make sure that the data in a column is …

  We can use “NOT NULL Constraint” to prevent values in a column from containing null data. Example: In the following example, when creating a …

  Result Cache is the memory space in the shared pool area within the Shared Global Area (SGA). In this memory area, the database query …

In some cases, SSMS (SQL Server Management Studio) is not installed on the server and you may need to connect to SQL Server from the …

We use the LIKE operator with WHERE clause. I suggest you read the following article about WHERE clause. “Where Clause in SQL Server and SQL …

If you are using SQL Server Availability Group and you have multiple availability groups and instances; if you want to list Availability Group Names, Database Names, …

When you search for different files while working, you can see the file named dead.letter. Why does dead.letter occur? The cause of dead.letter is to …

If you notice that there is an error in the PostgreSQL time when you make time-dependent queries in PostgreSQL, you can change it by following …

If your Linux server does not match the local time, you may experience problems when making date-based configurations. You can make mistakes due to these …

  NFS is the abbreviation of the Network File System. NFS is a useful technology for file sharing. It works as a server and client …