How To Create, Check And Change Identity Column In Microsoft SQL Server

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