Useful tips for everyday
What database is used for sensor data? [7] have discussed the possibilities to use NoSQL databases such as MongoDB and Cassandra in large-scale sensor network…
How to repair MyISAM tables in MySQL? Do so as follows: Move the data file to a safe place. Use the table description file to…
What is authorization in create schema? AUTHORIZATION owner_name. Specifies the name of the database-level principal that will own the schema. This principal may own other…
Is there a plugin for MySQL audit log? In terms of whether there is a plugin available, technically the mysql audit log plugin is only…
Why is my availability database in an unhealthy synchronization state? Error: At least one availability database on the replica has an unhealthy data synchronization state.…
How to convert a string to an integer in PostgreSQL? The following statement converts a string constant to an integer: SELECT CAST ( ‘100’ AS…
Why is VIP needed? By using a VIP address, Oracle eliminates the problem with TCP timeouts on the initial connection, without the need to make…
How to catch SQL Server 2016 DB restore taking long time? Whoever has source database ask him to shrink log file and then take backup,…
What should you do if your database is having problems? Databases need to be resilient, frequently backed up, and monitored constantly to catch issues before…
How do I move an index to another tablespace? We can move the indexes & tables to separate tablespaces using below query. ALTER TABLE MOVE…