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

  Hello Everyone , I am back with next part of Database monitoring . You should read the first article of this series. “DB2-Database Monitoring-1” …

  In this article We create a share on a server and then we map this share on a server. I selected MSSQL as Category. …

  In this article, I will share the necessary steps to connect to Oracle through the linux operating system and the solutions to the problems …

  Let’s assume that the sql_id of the query that we will improve is “bjyanqt9q718f”. First of all, we run the following procedure and create …

  RUNSTATS utility perform statistics in DB2. Should be perform Weekly or Monthly basis. Following Script helps to gather statistics on all tables excluding XML …

Following script is useful when you have multiple databases on single instance. When you need to provide your operation team to take backup of DB1 …

  With PostgreSQL, it is very easy to manage the case “update if there is a record, if not, add”. In traditional methods, we first …

  In Always On Availability Group Architecture, you can read from the Secondary Server. So how do you use it in your applications? In this …

  As you know, when you define SQL Server services through sql server configuration manager, they are automatically authorized with the minimum privileges they may …

  In this article I will describe how to connect to remote PostgreSQL database with PostgreSQL dblink. Dblink usage is similar to other databases. but …