Uninstall and Remove Multiple Database Instances of Microsoft SQL Server 2005
When database system administrator installs Microsoft SQL Server 2005 and creates a few database engine instances, there will [...]
How to Read MySQL Binary Log Files (BinLog) with mysqlbinlog
MySQL database server generates binary log files for every transaction to the databases, provided administrator does not disable [...]
Check and Optimize MySQL Database Automatically with Crontab/Cron
MySQL is a very popular free yet powerful database system. But even in great databases, the tables may [...]
How to Rename or Move Oracle Tablespace Datafile to Another Location
Oracle database does not provide an easy user interface to rename a datafile of tablespace, nor database administrator [...]
How Drop Tablespace and Recover Oracle Database When Accidentally Delete Datafile
Accident may happens, even though it's costly one. This is especially the case in Oracle database, which stores [...]
How to Remove and Drop Datafiles from Tablespace in Oracle Database
Oracle RDBMS databases stores data logically in the form of tablespaces and physically in the form of data [...]
How to Backup and Restore (Export and Import) MySQL Databases Tutorial
phpMyAdmin can be used to export or backup MySQL or MariaDB databases easily. However, if the database size [...]
MySQL Error 1170 (42000): BLOB/TEXT Column Used in Key Specification Without a Key Length
When creating a new table or altering an existing table with primary keys, unique constraints and indexes, or [...]
Remove or Trim First or Last Few Characters in MySQL Database with SQL
Another useful string function in MySQL database is TRIM() which will return a text string after removing the [...]
How to Find and Replace Text in MySQL Database using SQL
MySQL database has a handy and simple string function REPLACE() that allows table data with the matching string [...]