Useful tips for everyday
How does the InnoDB buffer pool improve performance? The innodb_buffer_pool_instances divides the InnoDB buffer pool into separate instances. Dividing your buffer pool into separate instances…
How to start the first node in a Galera Cluster? To start the first node–which should have MySQL, MariaDB or Percona XtraDB Cluster, and Galera…
What is Cassandra storage? Apache Cassandra is a free and open-source, distributed, wide-column store, NoSQL database management system designed to handle large amounts of data…
How often should you do a differential backup? How Often Should You Backup Data? The only way to protect your business from losing valuable data…
How do we eliminate duplicates from a select result set? The go to solution for removing duplicate rows from your result sets is to include…
Why is materialized view not fast refreshable in Oracle? The materialized view is not fast refreshable because DML has occurred to a table on which…
What is row level security in Oracle? Oracle Label Security (OLS) provides row-level security for your database tables. This feature secures your database tables at…
How do I group rows in Excel? To group rows or columns: Select the rows or columns you want to group. In this example, we’ll…
How can I tell how many times a server has been rebooted? Follow these steps to check the last reboot via the Command Prompt: Open…
Is no unique or exclusion constraint matching the on conflict specification? U125: No unique or exclusion constraint matching the ON CONFLICT specification. Explanation: Your INSERT…