MSSQL or MySQL?

[loon loon]

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.

[DavidsAwesome]

... are you by chance trying to increase your post count?

[ExpertWebHost]

i think he is trying to promote microsoft product more than comparing mysql & mssql!

bp.

[Wojtek]

... are you by chance trying to increase your post count?
More like his sales :)

[Lester128]

I've already seen that on some of the forums!
But I benefited from the information.

[krakjoe]

you have to be joking, mssql is a hairy bag of sweets compared to MySQL, and M$ didn't release it to be good to software developers, they released it so they can try to get thier grubby little mits on some of the MySQL teams hard earned customers.

[James]

Check the price differences - Simple.

[oates151]

Only time i ever used MS SQL databases was for my SAM Broadcaster and it worked like s---, crashed all the time, but then again, my computer was also crap at that time

Personally, I would never think of anything other than MySQL - might just be my grudge against Microsoft :P

[monaghan]

Nothing at all wrong with MS-SQL, I've been using it since 6.0, it just gets better each time, however that being said, most web apps don't even use the full features of MySQL 3, so it make very little difference to the average web punter which DBMS is installed as they're not going to tax it either way. I've had no real issues with up to about 80Gb databases on MS-SQL 7 :)

MySQL 5 will scale well and you can get commercial support from MySQL or other vendors, so there's not really any real requirement for MS-SQL. If you need a really big system, then generally Oracle on a big Unix box is the accepted way to go.

The key with any database server is to set it up correctly and put it on a suitable box and to have a DBA to manage it for you :)

[Megaphile]

... are you by chance trying to increase your post count?

Nope Hes just trying to make money, Check his referral link in the Signature :lol:

[Tree]

MSSQL likes to insert hundreds of spaces into places where it should really be a null value. I spent hours trying to figure out why a simple select query wouldn't work.

It does have a nice interface though.

[loon loon]

there are some drawback as well

started from mssql server 2005 and mssql expres, there is surface area configuration difficulties, setting up sql express is not straightforward, it is been locked down by default.
Unlike sql 2005 & express, mssql server 2000 allow you to connect directly to the server by default setting.