SQL Server Express
SQL Server Express http://www.microsoft.com/sql/express is the next generation of free relational database that allows both developers as well as administrators the ability to build and integrate relational databases for free. Taking a first look at the differences between MSDE and SQL Server Express you will see a few that are very evident.
- There is a GUI for administration Express Manager (XM)
- Symmetrical Multiprocessing is not available.
- Database Size has increased to 4GB
- Common language runtime (CLR) integration
- Graphical installation with command line available
- Deep integration with Visual Studio
- No transaction Throttle
- 1 CPU 1GB RAM
- XCopy support
SQL Server Express doesn't include high availability features such as data mirroring and clustering, full-text search, SQL Agent, DTS, Reporting Services, Analysis Services, Notification Services, or full management-tools suite called SQL Management Studio which is formally know as the Enterprise Manager.
SQL Server Express will no make a more viable choice for everyone from developers as well as to Service providers that want to offer a solution to low end relational databases. At the same time offer an up sell to SQL Server as the business or applications needs more availability.