SQL Server 2005 Express Edition - More than you expect

Many of you have heard about the express edition of SQL Server 2005, and you know its free. But most of the developers I have talked to believe it is just another version of MSDE, or some fairly handicapped SQL Server look alike. SQL Server 2005 Express is neither of these, so please read on and help me spread the word about what SQL Server 2005 Express really is.

Isn’t SQL Server 2005 Express just the next version of MSDE?

No. While SQL Server 2005 Express is intended to supersede MSDE it is not MSDE. SQL Server 2005 Express is the same code as SQL Server 2005 but with some limitations. However the complete core of the engine is intact, stored procedures, triggers, XML, SQLCLR, encryption, etc. This means no more if statements or forked code to deploy to MSDE and SQL, but instead one code base because there is only one database, not two similar ones.

What’s missing from SQL Server 2005 Express thats in SQL Server 2005?

Business Intelligence, Reporting Services, things like that. Fantastic features, but things that most users do not need in small and desktop databases.

What can SQL Server 2005 Express be used for?

Anything you like, however the most common scenarios are:

  • Small companies with minimal storage requirements
  • Local data storage and caching for smart clients
  • Stand alone desktop applications
  • Caching of data (from another SQL Server instance, or even one of those “other” databases) in multi tier and web applications
  • Distributed data processing
  • Web applications with minimal storage requirements

Can SQL Server 2005 Express accept client network connections?

Absolutely.

What are the limitations of SQL Server 2005 Express?

Limitations do exist, however they are very reasonable. The basic limitations are as follows:

  • 32 bit only. SQL Server 2005 Express will run on a 64 bit OS, but only in 32 bit mode.
  • 1 GB of RAM. SQL Server 2005 Express will utilize a maximum of 1 GB of RAM, even if more RAM is available.
  • 4 GB per database. Each database can be a maximum of 4 GB in size.
  • 1 CPU. SQL Server 2005 Express will only utilize one CPU, even on a multi processor machine.
  • Basic reporting services

What if I need just a little more than SQL Server 2005 Express? Do I have to buy SQL Server 2005 Enterprise?

No, with SQL Server 2005 we now offer a broad range of editions including Express, Workgroup, Standard, and Enterprise. You do not have to choose between low end and high end. You can choose the size and features you need and is appropriate for your budget.

Can I redistribute SQL Server 2005 Express with my application?

Yes. You just need to register first (it is free too) to obtain a redistribution license.

How can I get SQL Server 2005 Express?

Go here and click download now on the right side.

Are there any management tools available?

Yes. If you already have SQL Server 2005 Express, or are downloading it now do not forget to get the management too. It is free too but it is a separate download. Its available from the same link.