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…
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…
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…
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…
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,…
Install SQL Server 2012 Express
Install SQL Server 2012 Express Install SQL Server 2012 Express on Server 2008 Start here by downloading SQL Express with Tools from here: http://www.microsoft.com/en-us/download/details.aspx?id=29062 download SQLEXPRWT x64 version once Downloaded…
Install SharePoint 2013
Install SharePoint 2013 Install SharePoint 2013 I have a new 2008R2 VM Setup with SQL Server 2012 Express freshly installed (if you are not yet at this point, get the…
Change SQL Database Single and Multiuser Mode
Change SQL Database Single and Multiuser Mode Change SQL Database Single and Multiuser Mode this i unfortunately had to learn on the fly, not sure how it happened, but…
Install PostgreSQL on RHEL/CentOS/Oracle/Rocky/Alma
Install PostgreSQL on RHEL/CentOS/Oracle/Rocky/Alma Install PostgreSQL on CentOS PostgreSQL is used for alot of business applications, and runs arguably much better on Linux than Windows (then again what doesn’t?) Anywho:…