Welcome to WebmasterWorld Guest from 54.167.46.29

Forum Moderators: open

Message Too Old, No Replies

MS SQL Server 2005

has Been released!

     
3:02 am on Nov 8, 2005 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Oct 4, 2002
posts:666
votes: 0


Curiously (or perhaps not so), they have released a free version as well - SQL Server 2005 Express. This is a very interesting move...an attempt to eat into MySQL market share perhaps?
3:05 am on Nov 8, 2005 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Aug 8, 2004
posts:1679
votes: 0


You can't run it on Linux, which means you have to run on Windows, thus costing more in the first place. I doubt it will make any effect on MySQL share even if it did not have restrictions. MySQL is free and working well, why change to something crippled even if its free?
3:11 am on Nov 8, 2005 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Oct 4, 2002
posts:666
votes: 0


The restrictions seem to be higher level functionality that a lot of developers probably don't use anyway.

I use both databases regularly but I think MSSQL is far more sophisticated and powerful and I would definitely be more inclined to use it over MYSQL if there was no cost difference.

3:27 am on Nov 8, 2005 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Aug 8, 2004
posts:1679
votes: 0


The restrictions seem to be higher level functionality

4 GB database size is not that much. They also may have concurrency limits like they had in previous free version of the database.

6:05 am on Nov 8, 2005 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Oct 4, 2002
posts:666
votes: 0


Good point re:concurrency limits - I had a look through Micorsoft's site and they claim there is no concurrency throttle.

The 4GB limit is a consideration, however this is more than enough for many of the smaller scale website/CMS's I do.

1:03 pm on Nov 8, 2005 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:June 13, 2002
posts:2162
votes: 0


Express is just the MSDE upgrade. Theres no concurrent user limit, and no workload governor like MSDE.

Theres a limit of 1GB/1 proc unklike MSDE, which stops it being used for busy ecommerce sites so I dont think its competing with MySQL at all.

SQL Agent and programmable DTS are not included either making hard to use for a business system.

IMO its aimed at application developers just like MSDE was.

3:28 pm on Nov 8, 2005 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:June 2, 2003
posts:1184
votes: 0


which means you have to run on Windows thus costing more in the first place

Not if your running in a shared hosted env.