Got a Slashdot link today to a Builder article by Steve Turvey comparing databases for small companies. By the time I got to the paragraph that said: “SQL Server Express is one of two free databases we tested and is actually Microsoft’s replacement for its earlier free offering the Microsoft Desktop Engine (MSDE) which was based on the old Access technology. “, I was groaning. The MSDE is very close to Express, is a version of SQL Server 2000 and a long way from Access. That’s just nonsense.
It then goes on to mix up concepts of numbers of connected users vs numbers of users of a web site, etc. etc., totally ignoring concepts like connection pooling.
He then later draws the conclusion that “There is no denying that SQL Server Express is the weakest of the databases in this group” (without justifying why) and then goes on to talk about it being expensive to upgrade to standard edition (completely ignoring workgroup edition which is targeted at enterprises like the target of the article and ignoring Small Business Server premium edition which also would target this area). He also never even justifies this “expensive” claim, even though he then goes on to compare it with software that costs $39,000 odd. SQL Server Standard Edition sure doesn’t cost anything like that and Workgroup Edition owns the low-end (but not free) territory now.
The most common use of SQL Express is an embedded database with an application. Unlike MySQL which is endlessly described as free but isn’t really, Express really is free. MySQL is only free for companies pulling it down themselves for their own use. If it’s shipped with an app, the person writing the app is meant to license it. That isn’t free.
In the summary pane, Express is described using words like “limited” or “very limited” or “good features set” whereas MySQL is described with words like “brilliant” and as having a “very strong feature set”. I’d love to see the basis on which the feature set of Express could ever be described as “good” with MySQL described as much stronger. Not on the planet I live on. The feature set in Express is “stunning” compared to MySQL, on any rational assessment.
I love the comments like “While version 4.x of MySQL did not trap data input errors, for example alpha characters in a date field, and only issued “warnings”, version 5 now has a strict mode that rolls back the transaction if a violation is encountered.”. What a novel idea! I suppose we can ignore all the other nonsense like accepting the 31st February as a valid date, etc. I’m told that’s not a bug because they’ve documented how it works. And endless other examples at:
I’m also struggling with both of them being described as having a “very good user interface”. Sorry, but there’s no comparison whatsoever between the tools that come with MySQL and the cut-down version of SQL Server Management Studio for Express.
Steve then proceeds to compare Express to Oracle 10g, which costs over $19,000 AUD. Guess what? The Oracle version is superior. What a surprise. Why wasn’t this compared to a relevant SQL Server edition instead? My step-daughter’s Hyundai Getz isn’t much of a comparison to my neighbour’s latest BMW either but she’s never felt the need to compare them. And wasn’t the article meant to be comparing performance on 2 processor boxes? Doesn’t the Oracle license cost jump up to much higher figures (like over $30,000) because of the way they count “processors”?
In the DB2 section, he offers golden nuggets like “While DB2′s 512GB per table may appear a little small when compared with MySQL’s 64TB for example…” Again, on what planet is that an issue? The target comparison was for “a relatively small e-commerce company with less than 200 employees. The company sells DVDs and books over the Internet and will initially have around 1000 customers and an online inventory of 50,000 items.” Hard to imagine them blowing out a 512GB table here, well not in the near future at least…
And again in the DB2 section, poor old Express (free) is being compared to a database server that’s $8106 AUD per processor.
On the specifications page, there are just endless errors. Simple example: MySQL is listed as having FULLTEXT indexes and Express is listed without them. However, full-text indexing is supported on Express and it’s far superior.
Anyway, couldn’t just let this one go through to the keeper without comment.