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

  We use Telnet Client to check if the port we want to use is open when we access a server from another server. In …

  I will explain GETDATE, GETUTCDATE, SYSDATETIME and SYSUTCDATETIME functions in this article. GETDATE Function in SQL Server(TSQL): We can obtain current database timestamp as …

IOPS (Input/Output Operations Per Second) is a common performance metric used to compare computer storage devices. IOPS in Oracle databases is the total number of …

  Sometimes you cannot copy your scripts or files to the database server. If you don’t know the solution, it can be a very frustrating. …

  We can find the day using DAY function, month using MONTH function and  year using YEAR function from a date. It takes the date() …

  Some of the disks may be in CLOSED and IGNORED status when “v$asm_disk” is queried after a broken disk on the Exadata storage is …

Synonym is to give alias (an alternative name) to some objects on a database basis. The synonym can be created for following objects. Table View …

A friend ask to me to conversion about gregorian date to hijri date or hijri date to gregorian date. I will explan this conversions in …

  We can get a date by combining the values such as year, month and day with the help of DATEFROMPARTS, DATETIMEFROMPARTS, DATETIME2FROMPARTS, SMALLDATETIMEFROMPARTS functions. …

  When a database owner changes his password, you may receive errors as follows. Therefore, it would make more sense to set the owner of …