Ms Sql / Mysql - A Case Study
By John Malco, Mon Dec 26th
Contact: John Malco Tel: 1-888-898-9699 Cell:206-799-9696
MS SQL SERVER 2005 POWERS DATA DRIVENSITES Case Study of Two Web Companies
The release of Microsoft SQL Server 2005 on November 7th 2005created a buzz around the office for IT professionals. The useof SQL server by businesses as in an in house data server hasbecome increasingly more popular, this same popularity is nowbeginning to shift to the web industry.
Withthe release of MS SQL 2005 Microsoft had this to say "MicrosoftSQL Server 2005 provides an integrated data management andanalysis platform that helps organizations reliably managemission-critical information and confidently run complexbusiness applications. With embedded reporting and data analysistools included with SQL Server 2005, companies can gain greaterinsight from their business information." The norm for hostingcompanies has forever been mySQL. mySQL is a free licensedatabase server which has an easy to use php based interfacecalled phpmyadmin.
The difference in these two databaseplatforms has become more apparent since the release of MS SQL2005. We will look at two website companies one of whichoffers only mySQL on a windows server (http://www.6squared.com)and one which offers both a mySQL and MS SQL 2005 database toits customers (http://www.fivecubed.com)
It is verydifficult to make a performance comparison between SQL Server2005 and MySQL version 4.1. The performance of your databasesdepends upon the experience of the database developers anddatabase administrator rather than the database's provider. Youcan use both of these RDBMS to build stable and efficientsystems. It is also possible to define typical transactions usedin inventory control systems such as airline reservation systemsand banking systems. After defining these typical transactions,it is possible to run them under the different databasemanagement systems working with different hardware and softwareplatforms.