With the DBMS_REDEFINITION package in the Oracle database, it is possible to modify the structure of the tables online. We can convert a non-partitioned table …

New Dmw sys.dm_db_log_stats in SQL Server 2017 To understand SQL Server architecture, you must understand the architecture of the SQL Server Transaction Log file. Transaction …

What is Oratab Oracle creates a record for each Oracle RAC database in the oratab configuration file. The oratab file is created by the root.sh …

What is Automatic Seeding? Automatic Seeding is a feature introduced with SQL Server 2016. We need to add SEEDING_MODE = AUTOMATIC when creating the Availability …

If there is a difference with the db_name parameter when opening the Oracle database, you receive an error as follows. “ORA-00205: error in identifying control …

What is Basic Availability Groups? As of SQL Server 2016, we can create Always ON Availability Groups in Standard Edition with some limitations. You should …

ORA_ROWSCN returns the SCN information for the last modified date of the row for each row in a table. You can use this pseudo-column to …

What is Dynamic Data Masking? Dynamic Data Masking is a feature announced in SQL Server 2016. With Dynamic Data Masking, you can restrict unauthorized access …

It is possible to convert SCN (system change number) to date and date to SCN in Oracle databases. This allows us to find out when …

What is Row Level Security in SQL Server? Row-Level Security is a feature introduced in SQL Server 2016 that allows each user to see only …