Tag: data management

MySQL Performance: MyISAM vs InnoDB

MySQL Performance: MyISAM vs InnoDB

MySQL Performance MySQL Performance: Identifying Long Queries MySQL Performance: MyISAM vs InnoDB MySQL Performance: How To Leverage MySQL Database Indexing MySQL Performance: MySQL vs. MariaDB MySQL Performance: Converting MySQL to MariaDB MySQL Performance: System Configuration File & Routine Maintenance MySQL Performance: InnoDB Buffers & Directives MySQL Performance: MyISAM   A major factor in database performance…

Importing Databases and Tables with phpMyAdmin

Importing Databases and Tables with phpMyAdmin

Tutorial: phpMyAdmin I. Becoming Familiar with Databases in phpMyAdmin II. Running SQL Queries on a Database with phpMyAdmin III. Searching Through a Database with phpMyAdmin IV. Creating Tables in a Database with phpMyAdmin V. Deleting Tables from a Database with phpMyAdmin VI. Importing Databases and Tables with phpMyAdmin VII. Exporting Databases and Tables with phpMyAdmin…

Running SQL Queries on a Database with phpMyAdmin

Running SQL Queries on a Database with phpMyAdmin

Tutorial: phpMyAdmin I. Becoming Familiar with Databases in phpMyAdmin II. Running SQL Queries on a Database with phpMyAdmin III. Searching Through a Database with phpMyAdmin IV. Creating Tables in a Database with phpMyAdmin V. Deleting Tables from a Database with phpMyAdmin VI. Importing Databases and Tables with phpMyAdmin VII. Exporting Databases and Tables with phpMyAdmin…

SQL Database Migration with SSMS

SQL Database Migration with SSMS

Migrating MSSQL between servers can be challenging without the proper guidelines to keep you on track. In this article, I will be outlining the various ways to migrate Microsoft SQL Server databases between servers or instances. Whether you need to move a single database,  many databases, logins or stored procedures and views we have you…

Modifying Fields in Database Tables with phpMyAdmin

Modifying Fields in Database Tables with phpMyAdmin

Tutorial: phpMyAdmin I. Becoming Familiar with Databases in phpMyAdmin II. Running SQL Queries on a Database with phpMyAdmin III. Searching Through a Database with phpMyAdmin IV. Creating Tables in a Database with phpMyAdmin V. Deleting Tables from a Database with phpMyAdmin VI. Importing Databases and Tables with phpMyAdmin VII. Exporting Databases and Tables with phpMyAdmin…

Deleting Tables from a Database with phpMyAdmin

Deleting Tables from a Database with phpMyAdmin

Tutorial: phpMyAdmin I. Becoming Familiar with Databases in phpMyAdmin II. Running SQL Queries on a Database with phpMyAdmin III. Searching Through a Database with phpMyAdmin IV. Creating Tables in a Database with phpMyAdmin V. Deleting Tables from a Database with phpMyAdmin VI. Importing Databases and Tables with phpMyAdmin VII. Exporting Databases and Tables with phpMyAdmin…

Inserting Fields into Database Tables with phpMyAdmin

Inserting Fields into Database Tables with phpMyAdmin

Tutorial: phpMyAdmin I. Becoming Familiar with Databases in phpMyAdmin II. Running SQL Queries on a Database with phpMyAdmin III. Searching Through a Database with phpMyAdmin IV. Creating Tables in a Database with phpMyAdmin V. Deleting Tables from a Database with phpMyAdmin VI. Importing Databases and Tables with phpMyAdmin VII. Exporting Databases and Tables with phpMyAdmin…