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…
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:…
Connect CentOS to MySQL ODBC
Connect CentOS to MySQL ODBC Connect CentOS to MySQL ODBC There are many uses for this, usually reporting, or some other data manipulation. Let’s get started, login and su to root…
MySQL Replication CentOS All Databases
MySQL Replication CentOS All Databases MySQL Replication CentOS All Databases ** THIS BLOG WORKS ONLY WITH MySQL VERSION 5.1 or EARLIER ** If you’re going to do it, do it…