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

  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 …

  The concept of normalization was created by Edgar F. Codd, the founder of the relational database model. During the design of the tables, we …

  It is useful to check occasionally whether everything is normal in the Oracle ASM instance. To do this, some information should be collected and …

You may encounter this error when taking a backup to a NFS Mounted disk. You will see the error through SQL Server as follows. Msg …