MS SQL / MySQL - A Case Study

The release of Microsoft SQL Server 2005 ondifferent hardware and software platforms.
November 7th 2005 created a buzz around theThe comparison aspect being looked at here is
office for IT professionals. The use of SQLhow the two web hosting companies sell their
server by businesses as in an in house datahosting packages and which company in turn
server has become increasingly more popular, thisproduced a greater number of sales based on its
same popularity is now beginning to shift to thedatabase offerings. who offers MSSQL anteed up
web hosting industry.a large amount of money to host MSSQL for its
With the release of MS SQL 2005 Microsoft hadcustomers in the hopes that more customers
this to saywould use the service solely for the MSSQL. The
"Microsoft SQL Server 2005 provides anbreak-even point for was $8,000 because they
integrated data management and analysispurchased the MSSQL 2005 standard edition
platform that helps organizations reliably manageprocessor specific. This puts at a huge advantage
mission-critical information and confidently runover
complex business applications. With embeddedBoth companies offer hosting for all price levels
reporting and data analysis tools included with SQLand incorporate a large array of features, which
Server 2005, companies can gain greater insightputs them on a somewhat even playing field if
from their business information."marketing is ignored. and were studied over a
The norm for hosting companies has foreverperiod of 1 month. The results of their sales from
been mySQL. mySQL is a free license databasethe period beginning November 7th, and Ending
server which has an easy to use php basedDecember 7th were as follows: had new sales of
interface called phpmyadmin.only database additions (not including hosting
The difference in these two database platformspackages without database access) totaling 189
has become more apparent since the release ofsales which translates into $2,632. The databases
MS SQL 2005. We will look at two websiteare sold based on two criteria size and quantity.
hosting companies one of which offers onlyoffered its databases free during this one-month
mySQL on a windows server ( and one whichperiod and generated no additional revenue from
offers both a mySQL and MS SQL 2005database sales. This puts ahead of by $5,368 at
database to its customers (the end of one month by not purchasing MS SQL
It is very difficult to make a performanceserver.
comparison between SQL Server 2005 andNow for a projection of sales by fivecubed.com's
MySQL version 4.1. The performance of yourfinance department. They determined a growth
databases depends upon the experience of therate of 10% per month for the next 24 months.
database developers and database administratorAt the end of this time the total number of
rather than the database's provider. You can usedatabases sold will equal 1,692.36, which translates
both of these RDBMS to build stable and efficientinto $13,538.88. As long as these forecasts hold
systems. It is also possible to define typicalwill reach its break even point by the 18th month
transactions used in inventory control systemsand will turn a profit on the 19th month.
such as airline reservation systems and bankingThe demand for MSSQL shown in the first month
systems. After defining these typical transactions,that implemented it was enough to create a profit
it is possible to run them under the differentafter only 18 months.
database management systems working with