Useful tips for everyday
Is Oracle Data Guard real time? Data Guard Log Apply Services can automatically apply information from redo logs to standby databases, keeping data synchronized with…
How to configure log shipping in SQL Server? Using SQL Server Management Studio. To configure log shipping. Right click the database you want to use…
How do I export SQL query result to text file in SQL Server? Getting Started If you want to save the results in a txt…
How to return NULL for an empty XML Path? This means if you want the XML element, etc. to have a value of NULL rather…
How do you compare values in two tables? The EXCEPT statement returns the rows from the first query (left query) that are not returned from…
How is the transaction log implemented in SQL Server? The transaction log is implemented as a separate file or set of files in the database.…
How can I copy data from one table to another in phpMyAdmin? How to copy a database table with phpMyAdmin phpMyAdmin is a popular application…
When to use Index on expression in PostgreSQL? Once you define an index expression, PostgreSQL will consider using that index when the expression that defines…
How do I create a database schema in PostgreSQL? First, create a new schema in the database: CREATE SCHEMA census; ALTER TABLE nyc_census_blocks SET SCHEMA…
How to create a physical standby database using RMAN? In this article, we will see Physical Standby database creation and configuration using RMAN backup and…