Sometimes when we get ERROR messages such as the communication failure, MySQL server not responds your requests, or we want to know what the …
Read More »Who is Running the Queries in Your Database On Oracle
You can find the queries that are run in the database from v$sql, v$sql_text views, and who are running from sys.all_users. You can create …
Read More »How To Change SQL Instance/Server Name ANS @@SERVERNAME Function
Sometimes the name of the server changes and the SQL Server instance name must change accordingly. For example, suppose your server name is a test …
Read More »Oracle 12c IDENTITY Columns & Default SEQUENCES
I will try to explain the identity feature, which is my favorite innovation in Oracle 12c. MS SQL and MYSQL users know the Identitiy …
Read More »High Availability Part II
You should read the first part of this article before reading this article. “High Availability Part I” The expectation …
Read More »Policy-Based Management(Check The Databases That Are Not Backed Up-Database Facet)
Policy-Based Management is a feature that introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to …
Read More »Step By Step Oracle Apex Installation
I tried to explain the apex installation step by step. Ensure that the Oracle Text component is also installed before you begin the installation. …
Read More »How To Read SQL Server Audit
You can read the article “How To Create SQL Server Audit” to get more information about Audit and create an audit. You can read …
Read More »How To Enable Archive Log Mode In Oracle RAC Database
Enabling the archive log mode in the RAC database is slightly different from the normal database. You can enable archive log mode in the rac …
Read More »How To Create SQL Server Audit
We will create sql server audit step by step in this article. We need to create an Audit file to record transactions made by people …
Read More »