Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
In SQL Server, you can write query in a query. You can write the subqueries in the SELECT section, FROM section, and the WHERE …
Read More »
How To Move an Azure SQL Database to a Local Instance
Today a software developer friend has requested to move a database in Azure SQL Database to a local server with its data. What I …
Read More »ORACLE_OCM ORA-12012 ORA-29280
Ora-12012, Ora-29280 errors relate to Oracle configuration manager (OCM). Typically, OCM jobs fail due to the old installation after database upgrade operations. Possible errors …
Read More »Checking Database Consistency Using Maintenance Plan
We perform maintenance operations on SQL Server using Maintenance Plan. In this article I will describe the process of checking the database consistency (dbcc checkdb). …
Read More »IN Operator in SQL Server(TSQL)
When filtering through the Where Clause during data reading from the database, the IN operator can check whether the column is within certain values. …
Read More »Between Operator in SQL Server(TSQL)
When reading data from the database with Between Operator, we can specify a range for the data we filter in WHERE Clause. Let’s make …
Read More »Unable to access the ‘database_name’ database because no online secondary replicas are enabled for read-only access
ERROR: Error: Microsoft ODBC Driver 11 for SQL Server : Unable to access the ‘database_name’ database because no online secondary replicas are enabled for read-only …
Read More »ADR Command Interpreter(ADRCI)
ADR Command Interpreter (ADRCI) is a command-line tool in the fault detection infrastructure of Oracle databases. With ADRCI; We can see the diagnostic data in …
Read More » How To Create Log Backup Using SQL Server Maintenance Plan
We perform maintenance operations in SQL Server using Maintenance Plan. In this article we will create a maintenance plan for Log Backup. I will share …
Read More »DISTINCT Clause in SQL Server(TSQL)
With Distinct Clause, you can return only one of the recurring records as a result when reading data from the table. In other words, if …
Read More »