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 »Group By Clause, SUM, MAX, MIN, AVG, COUNT and COUNT_BIG Functions in SQL Server(TSQL)
When reading data from the database, we can use GROUP BY clause when we want to group data and process on the groups we …
Read More »CONCAT Function in SQL Server(TSQL)
I would like to talk to you about a new Built-in Function, CONCAT, that comes with SQL Server 2012. As you know, before SQL …
Read More »