JoseffB — Mon, 06 Nov 2006 03:48:25 +0000

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.

Abhishek Reddy — Mon, 06 Nov 2006 03:27:33 +0000

loon;210036 wrote: Reddy thanks for the feedback

FrankR... how about MSSQL express, it is free as well...

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.

loon — Mon, 06 Nov 2006 02:13:11 +0000

Reddy thanks for the feedback

FrankR... how about MSSQL express, it is free as well...

FrankR — Sat, 04 Nov 2006 02:46:25 +0000

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.

Abhishek Reddy — Wed, 01 Nov 2006 21:24:43 +0000

loon, you could start with:

loon wrote: In fact, a lot of analysis also showed that MSSQL Server is better compared to other database system such as DB2, MySQL, PostgreSQL, etc.

Cite some of these analyses. I think it would be interesting and helpful for a lot of people here.

loon wrote: However, MSSQL Server is also been categorised by many developers as a very expensive database management system to use [...] shift from MSSQL server to cheaper or free database system.

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?

loon wrote: 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.

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).)

Greg K — Wed, 01 Nov 2006 13:24:26 +0000

Abhishek Reddy;209793 wrote: But it does read like a sales brochure, and is filled with unsubstantiated claims.

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

Abhishek Reddy;209793 wrote: Note the "tip".

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).

loon — Wed, 01 Nov 2006 01:32:29 +0000

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.

JoseffB — Wed, 01 Nov 2006 00:17:55 +0000

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.

Abhishek Reddy — Tue, 31 Oct 2006 20:06:32 +0000

Greg K;209792 wrote: 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.

But it does read like a sales brochure, and is filled with unsubstantiated claims.

Quote:
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.

Note the "tip".

Greg K — Tue, 31 Oct 2006 18:50:19 +0000

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