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

  When you want to monitor “SQL Server” servers with a monitoring tool, you must grant the user who will monitor access to WMI. To …

  In Oracle databases, when the Automatic Memory Management (AMM) is active, if the memory values grow and shrink too frequently, wait events can be …

You need to know about Primary Key and Foreign key before you can read this article. You can read the article “What is Primary Key …

  Before reading this article, I suggest you read my article “Identitiy Insert On SQL Server” to see what the identitiy property is in the …

  Recently, i used a user-defined variable to store some values, and it showed an unexpected result. I updated rows using ‘where a in (@var)’, but this query …

  When we need to transfer data from SQL Server or transfer data to SQL Server, we can use the import export methods in SQL …

  To understand this article, we need to know the following concepts. Page: It is the most basic unit in SQL Server storage. Each Page …

  Oracle_client is required to connect to remote Oracle databases. For Oracle Foreign Data Wrapper, this installation needs to be done as follows. First of …

  The ARBn background process starts the rebalance process automatically when you delete or insert a disk from the ASM disk groups. This process is …

  If your computer is not connected to the domain, you can get this error when you try to connect to a SQL Server in …