MSSQL or MySQL?
Microsoft SQL Server 2005 database engine was a favour of many web developers due to its ability in providing more secure, reliable storage for both relational and structured data. It enabling developers to build and manage highly available, performant data applications that developers can use to take their business to the next level. In fact, a lot of analysis also showed that MSSQL Server is better compared to other database system such as DB2, MySQL, PostgreSQL, etc. However, MSSQL Server is also been categorised by many developers as a very expensive database management system to use, even until now. Due to this, a lot of developers started to shift from MSSQL server to cheaper or free database system.
When comparing linux server and windows server, people tend to relate linux server with mysql and windows server with mssql. Linux server become the preference of many developers because it is cheap, mysql is free. Windows servers with mssql is very expensive.
Now, Microsoft has come out with a new product, MSSQL Express. Microsoft SQL Server 2005 Express Edition (SQL Server Express) is a powerful and reliable data management product that delivers rich features, data protection, and performance for embedded application clients, light Web applications, and local data stores. SQL Server Express is available at no cost, easy to use, redistributable version of SQL Server 2005 designed for building simple data-driven applications. Developers can design schemas, add data, and query local databases, all inside the Visual Studio 2005 environment. Furthermore, if developers need more advanced database features, then SQL Server Express can be seamlessly upgraded to more sophisticated versions of SQL Server.
MSSQL Server 2005 Express Edition is been designed in such a way that it remains good features from MSSQL Server 2005 while in the same time benefited developers by giving it out for free. SQL Server 2005 Express Edition is easy to install; easy to use and manage; rich with database functionality; better security; simple pricing and licensing; with xml support; deep integration with Visual Studio 2005; better scalability and performance; etc. Please visit http://www.microsoft.com/sql/editions/express/features.mspx for more information.
Database system is now considered as a critical factor in choosing a web hosting providers and MSSQL Express is simply the best choice, good yet cheap.
*Tips: Type "Free MSSQL Express hosting" or "MSSQL Express windows hosting" in google search to search for web hosting company that have MSSQL express ready in their control panel.
loon
WebhostforASP.NET Support Team
ASP.NET Hosting
http://webhostforasp.wordpress.com
Greg K posted this at 14:24 — 31st October 2006.
He has: 2,145 posts
Joined: Nov 2003
Just a note for those wondering, as I did when I first found out about Visual Studio Express:
-Greg
ohrana posted this at 15:01 — 31st October 2006.
They have: 156 posts
Joined: Sep 2006
Thanks for useful information.
Abhishek Reddy posted this at 18:45 — 31st October 2006.
He has: 3,348 posts
Joined: Jul 2001
What is this, a sales pitch? I'm tempted to run the original post through a round of buzzword bingo.
loon, feel free to substantiate your claims if you'd like to hold a reasonable discussion. Otherwise there's not much to say in this thread, since you're basically just promoting your service.
Greg K posted this at 18:50 — 31st October 2006.
He has: 2,145 posts
Joined: Nov 2003
I must have misread the post, I thought he was letting people know there was a free version of MS SQL server that they could use as an alternative to mySQL which is free.
I knew of the Visual Studio Express, but did not know they had an express version of MS SQL until this post.
I don't feel he is "basically just promoting your service" anymore than you are, as you both only mention your site in your signature.
-Greg
Abhishek Reddy posted this at 20:06 — 31st October 2006.
He has: 3,348 posts
Joined: Jul 2001
But it does read like a sales brochure, and is filled with unsubstantiated claims.
Note the "tip".
Greg K posted this at 13:24 — 1st November 2006.
He has: 2,145 posts
Joined: Nov 2003
I'll give you that, but so are a lot of posts when it comes to discussing one one program over another. I gues it is all in how you read it. I'm open to MS SQL server, as it does have features that mySQL lacks, but would never seriously look into it becasue of the costs. (not only the database, but the OS as well) They should make Windows Express lol
I just did a google for the two items in the tip, didn't see the site that is listed in the signature come up on either search (within the first results page).
JoseffB posted this at 00:17 — 1st November 2006.
He has: 52 posts
Joined: Oct 2006
Cool two Mods going at it. Pass the beer and popcorn!
For real though, I read this this morning and had the same notion as Abhishek. It does seem to be one sided. I use MySQL because I feel its a better partner to PHP.
I also feel that once you know PHP it's easy to move over to coldfusion and asp.net, but again thats just my opinion.
loon posted this at 01:32 — 1st November 2006.
He has: 13 posts
Joined: Sep 2006
My purpose of writing this article is to let people "who still don't know about this" to know about this.
Sorry if i have confused you, pls tell me how should i change it to make it better.
loon
WebhostforASP.NET Support Team
ASP.NET Hosting
http://webhostforasp.wordpress.com
Abhishek Reddy posted this at 21:24 — 1st November 2006.
He has: 3,348 posts
Joined: Jul 2001
loon, you could start with:
Cite some of these analyses. I think it would be interesting and helpful for a lot of people here.
That's misleading. Many developers find various other problems with MSSQL. Also, many developers aren't using MSSQL in the first place -- often by choice -- and so don't "shift from" it. Have you researched what other objections and criticisms developers have of MSSQL?
You just mentioned PostgreSQL and DB2 (what about SQLite, MaxDB, Informix?). It would be ridiculous to assert that most developers oversimplify like this. Not to mention that *BSD and Solaris are major platform choices too.
If you were writing just to let developers know about it, I'd expect more detailed, objective descriptions of its interesting features, with links to further information, preferably from non-Microsoft sources. Personal bias is fine, hype is another thing.
(Greg, strange, I thought it turned up in my search yesterday, maybe Google updated coincidentally. I'm not sure now if the result was the site in the signature or one of those webhost listing pages linking to it. Or maybe it was one of the posts on other forums saying exactly the same thing (copied verbatim).)
FrankR posted this at 02:46 — 4th November 2006.
He has: 45 posts
Joined: Oct 2006
Microsoft SQL Server, in its variants, works if the developer wants to be tied to a pricey proprietary system that only runs on Windows servers and clients.
A lot of web developers use MySQL because it is what their web host provides. The hosting provider uses it because its fast and cheap and is available under both a free software license and a commercial license. Others choose PostgreSQL because of its long history, extensiveness, and availability under a totally free BSD license.
For a large traditional database, I would think one would still look at Oracle and DB2 hard before choosing the go with the Microsoft solution. I believe both Oracle and IBM provide free developer licenses these days.
A software developer or project manager must balance the scalability needs and then ask how much it will cost to expand later. Often, the open source systems will be the most cost effective in the long run as one can keep adding servers with minimal additional licensing costs.
Author of SQL Converter for Excel, which is an Excel add-in for converting data to MySQL.
loon posted this at 02:13 — 6th November 2006.
He has: 13 posts
Joined: Sep 2006
Reddy thanks for the feedback
FrankR... how about MSSQL express, it is free as well...
Abhishek Reddy posted this at 03:27 — 6th November 2006.
He has: 3,348 posts
Joined: Jul 2001
Any chance of addressing the points I raised? I'd especially like to see the analyses that showed MSSQL to be better than all other database systems.
MSSQL Express seems be free only in terms of price. MySQL (GPL licence) or PostgreSQL (BSD licence) provide complete software freedom in addition to zero cost.
JoseffB posted this at 03:48 — 6th November 2006.
He has: 52 posts
Joined: Oct 2006
I work for a fortune 100 IT company and we prefer Oracle over MSSQL because of the fact that you ARE tied to only one OS with MSSQL. I've been told that we need to be able to develop on our internal systems and then migrate to the customers systems. We don't necessarily know what the customer will have a system.
Another side note that I personally have noticed is that as an organization we stay away from opensource (sucks cause I love opensource) because of own-ability and the tricky licensing of some of the opensource software. (also the company execs don't want to share source).
I guess you can do that when you got deep pockets.
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.