Internet, Networking, & Security Web Development Microsoft SQL Server 2008 R2 By Mike Chapple Writer Former Lifewire writer Mike Chapple is an IT professional with more than 10 years' experience cybersecurity and extensive knowledge of SQL and database management. our editorial process Twitter Mike Chapple Updated August 19, 2019 Microsoft Web Development SQL CSS & HTML Web Design Tweet Share Email SQL Server 2008 R2 has long been a favorite of Microsoft’s enterprise relational database platform series. As an upgrade to the SQL Server 2008 platform, SQL Server 2008 R2 comes at a higher price point. The Various Editions of SQL Let’s take a look at the seven different editions of SQL Server 2008 R2 that you can use: SQL Server 2008 R2 Express Edition replaces the Microsoft Data Engine (MSDE) as the free version of SQL Server for application development and lightweight use. It remains free and retains the limitations of MSDE with respect to client connections and performance. It’s a great tool for developing and testing applications and extremely small implementations, but that’s about as far as you can run with it.SQL Server 2008 R2 Workgroup is billed as a “small business SQL Server” and it offers an impressive array of functionality for a price tag per processor or available under a 5-user license. Workgroup edition maxes out at 2 CPUs with 3GB of RAM and allows for most of the functionality you’d expect from a server-based relational database. It offers limited replication capabilities as well.The workhorse SQL Server 2008 R2 Standard Edition remains the staple of the product line for serious database applications. It can handle up to 4 CPUs with an unlimited amount of RAM. Standard Edition 2005 introduces database mirroring and integration services.SQL Server 2008 Enterprise Edition is now more limited than in the past. It previously supported unlimited processors but is now capped at 8 CPUs. It's also more expensive than it was before but has discounted options for 25 users.SQL Server 2008 R2 Datacenter Edition supports up to 256 logical processors and provides high-end scalability. Datacenter edition provides access to SQL Server's multiserver administration tools and allows the use of unlimited memory.SQL Server 2008 R2 Parallel Data Warehouse Edition provides an appliance-based solution for highly scalable data warehouse applications. It supports the standard hub-and-spoke data warehouse architecture.Developers needing the full features of SQL Server 2008 R2 Enterprise Edition for use in a non-production environment may find SQL Server 2008 R2 Developer Edition the right tool for the job. This product has the exact same functionality as Enterprise Edition and only differs in the license. Microsoft also offers a direct upgrade path to convert Developer servers to production licensingSQL Server 2008 R2 Web is a specialized version of SQL Server for use in web hosting environments. Like Standard edition, it has no limitations on the amount of memory used and supports the use of up to 4 CPUs.SQL Server 2008 R2 Compact is a free version of SQL Server for use in embedded environments, such as mobile devices and other Windows systems. That sums up the licensing options available for SQL Server 2008 R2. As you’ve discovered, Microsoft offers a wide variety of licenses and choosing the correct one for your environment can save you thousands of dollars. Microsoft will no longer be supporting SQL Server 2008 and 2008 R2 starting on On July 9, 2019, which will mean the end of their regular security updates.