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

  Sometimes we need to take backups on an AG basis. Finding databases that are included in individual AG and getting their individual backups will …

  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 …