Category: Database

Performing a MySQL Upgrade

Run mysql_upgrade after every MySQL version upgrade so tables stay optimized and backups keep working.

Read More

Convert MySQL Slave to Master

Convert MySQL Slave to Master Convert MySQL Slave to Master If you ever have some sort of major failure, or you are just testing your fail over capabilities, you have…

Read More

Install Oracle Express Oracle Linux 6

Install Oracle Express Oracle Linux 6 Install Oracle Express Oracle Linux 6 Preparing Oracle Enterprise LinuxDisk/Swap Setup As you can see we have root VG for the OS (60GB)/home Volume…

Read More

Index SQL Server Database

Index SQL Server Database Index SQL Server 2008R2 Database Every once in a while it’s a good idea to re-index your tables when you are using Microsoft SQL Server. Unlike…

Read More

Create New Database SQL Server 

Create New Database SQL Server Create New Database SQL Server 2008R2 The first thing you need to do is open SQL Server Management Studio from here login with the necessary…

Read More

Fix Microsoft SQL Express Memory Issues

Fix Microsoft SQL Express Memory Issues Fix Microsoft SQL Express Memory Issues In this example, we have Microsoft SQL Server express. We know that express only can use 1GB RAM…

Read More

Backup SQL Server Express

Backup SQL Server Express Backup SQL Server Express 2008R2 Open up SQL Server Management Express Studio, and Expand Databases For this example, we will be backing up a SharePoint Server,…

Read More