SQL Server Express 2005 compared to MSDE2000
Alex Thissen gives a summary on his weblog from what he has heard at the SQL Pass 2005 conference about SQL Server Express (SSE).
First and foremost, SSE will be free! Comparing it to MSDE2000, that version had a limit of 10 connections, where SSE will be able to share more, although Alex doesn’t tell us how much. Probably because Microsoft is still figuring out how many they’ll provide, as with more options Alex describes. The .NET CLR will be hosted in SSE and you’ll be able to do in SSE what you’re able to do in SQL Server 2005. SSE has some limits on memory and CPU-s, so it’s not as scalable as the full product, but that won’t be needed. When you’re in need of scalability, you’ll probably want the full product. Also the SQL Express Manager is a stripped down version of the full SQL Server Manager, and SSE will also support Reporting Services, although with less functionality than the full product. Other things like replication, Service Broker and more is supported.
This seems like an ideal product for small companies that aren’t always willing to pay top dollar (or euros) for a product of which most functionality they’ll never use. I’m currently at a client that’ll probably want to use some sort of database. But it only has so few customers who’ll use the application (to be written) only a few times per week or so, that it doesn’t need SQL-Server 2000. Backups are created on tape, no need for mirroring or anything. SQL Server Express seems the ideal solution here. Worth spending some more time investigating it.
And it’s database limit is also twice the size of MSDE 🙂
… and it probably has the same kind of license as MSDE. Mostly MSDE is free because of a Office license within the company.
If not.. then this is really a good alternative for other db’s.
Because I didn’t phrase that clear enough: MSDE had no connection limits. It was just that only 10 of them could perform simultaneous work. That limit is gone in SSE. It’s just that you only have 1 GB of RAM to work with. That’s your main limit.
And as far as I know, you can use and distribute SSE for free, without any small print (just like MSDE).
But will it come with maintenance tools like Enterprise Manager – or whatever the SQL Server 2005 equivelant is?
As said : Also the SQL Express Manager is a stripped down version of the full SQL Server Manager. 🙂
Only this stripped down version isn’t there yet. But there’ll probably some others tools around. Problem is that their most of the time, not nearly as good.