Microsoft SQL Server has built-in an identity column (fields) which
How to Change Auto Increment Value of MySQL / MariaDB Database
Almost all database tables have a unique column which serves
How to Get Current Auto_Increment Sequence Number for MySQL / MariaDB Table
Most tables in database have a column with auto increment
Error $2501 & $210D While Attempting to Initialize Borland Database Engine (BDE)
When using applications that utilize Borland Database Engine (BDE), one
SQL Command to List & Show All Databases in MySQL & MariaDB
mysql is a simple and easy to use SQL shell
Display Full SQL Query in Show Processlist of MySQL
In MySQL database system, by default the SHOW PROCESSLIST query
Disable Root Login in phpMyAdmin
phpMyAdmin is a very useful and powerful web-based GUI administration
Upgrade MySQL to MariaDB 10 (Part 2 – Upgrade MariaDB/MySQL 5.5 to Version 10.0)
MariaDB is a relational database management system (rDBMS) that was
Upgrade MySQL to MariaDB 10 (Part 1 – Install MariaDB 5.5)
MariaDB is a relational database management system (rDBMS) that was
Virtualmin: You Do Not Have Access to This MySQL Database After Changing Password
After changing password of MySQL or MariaDB administration user, such
MariaDB: Webmin MySQL Startup Script /etc/rc.d/init.d/mysqld Was Not Found
MariaDB, the enhanced in-place upgrade of MySQL database management system,
Convert PostgreSQL Template0 & Template1 Encoding to UTF8 (SQL_ASCII Incompatible)
After installing Odoo 8 (also known as OpenERP), and other
Optimize SQL Server 2000 / 2005 / 2008 in Large RAM System by Locking Pages in Memory and AWE
Microsoft SQL Server is a data-intensive and disk I/O (read
Error Has Occurred While Establishing A Connection To SQL Server 2005 / 2008 / 2012 / 2014 Which Does Not Allow Remote Connections
When connecting to an instance of Microsoft SQL Server 2005
Oracle PL/SQL ORA-00947 Not Enough Values Error
In Oracle database, the following error message may appear when
Uninstall and Remove Multiple Database Instances of Microsoft SQL Server 2005
When database system administrator installs Microsoft SQL Server 2005 and
How to Read MySQL Binary Log Files (BinLog) with mysqlbinlog
MySQL database server generates binary log files for every transaction
Check and Optimize MySQL Database Automatically with Crontab/Cron
MySQL is a very popular free yet powerful database system.
How to Rename or Move Oracle Tablespace Datafile to Another Location
Oracle database does not provide an easy user interface to
How Drop Tablespace and Recover Oracle Database When Accidentally Delete Datafile
Accident may happens, even though it’s costly one. This is