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 »How To Access SESSION Information in Oracle from the Process ID in the Operating System
You can use the following script to access SQL information in Oracle from a PROCESS ID on the operating system. [crayon-676a205a778c8733734827/] If your …
Read More »Difference Between Always On Failover Cluster, Database Mirroring, Always On Availability Group, Replication and Log Shipping
I wanted to write this article to make it easier for you to choose between SQL Server’s technologies used for HA (High Availability) and DR …
Read More »