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

  You can use the following queries to monitor the performance of the database or to find and kill queries that cause lock. The following …

  In the article “How To Authorize non-admin Logins To Read DMWs and DMFs“, I explained how to give dmw and dmf read privileges to …

  Some logins may want to see queries that requested from the database. They can see these queries from SQL Server  DMWs(Dynamic Management View) and …

  Sometimes when we want to insert rows into a table which contains duplicate keys, then we consider using ‘replace into’ or ‘insert into … …

We will upgrade POSTGRESQL 10 To 11 on CENTOS in this article. Before I start the upgrade process, I want to make the following critical …

  Policy-Based Management is a feature that introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to …

  A materialized view is a database object that contains the results of a query. The FROM clause of the query can name tables, views, …

  With the Log Shipping technology, the backup of the SQL Server Transaction Log file is periodically transferred to another instance and recovered on the …

  In some cases, we may need to know how many percent of the ASM disks are used. The following query shows the percentage of …

  I will use SQL Server 2014 in this article. Other versions can be installed in similar ways. SQL Server Always On Failover Cluster was …