Microsoft SQL Server 2008 R2 Express with SP1 is a free, feature-rich edition of SQL Server that is ideal for learning, developing and powering desktop, web and small server applications, and for redistribution by ISVs.
There are three Editions of SQL Server 2008 R2 SP1 Express:
- SQL Server 2008 R2 Express with Tools: Core edition of Express that supports development. Includes SQL Server 2008 Database Engine and SQL Server Management Studio Express
- SQL Server 2008 R2 Express with Advanced Services: Extends SQL Server 2008 Express with tools to include support for Integrated Full-text Search and Reporting Services
- SQL Server 2008 R2 Express (Runtime Only): Includes the SQL Database Engine only and is designed for deployments and ISV redistribution
Features includes;
- Supports stored procedures, triggers, functions, and views
- Store all kinds of business data with native support for relational data, XML, FILESTREAM and spatial data
- Improved performance, usability, visualization, in addition to integration with the Microsoft 2007 Office System in SQL Server Reporting Services
- Simplify development efforts by leveraging existing T-SQL skills, ADO.NET Entity Framework and LINQ
- Closely integrated with Visual Studio and Visual Web Developer





Posted by Download: Microsoft SQL Server 2008 Service Pack 2 « Windows Info Portal on August 5, 2011 at 3:02 pm
[...] may also download SQL Server 2008 R2 Express Edition with Service Pack 1 and SQL Server 2008 R2 Service Pack 1 [...]
Posted by Microsoft SQL Server 2008 Express Edition Service Pack 3 (SP3) now available « Windows Info Portal on August 23, 2011 at 9:32 am
[...] can download Microsoft SQL Server 2008 R2 Express Edition with Service Pack 1, here. Advertisement GA_googleAddAttr("AdOpt", "1"); GA_googleAddAttr("Origin", "other"); [...]