The Right SQL Server R2 Editions
by Cecille Ramirez on October 1st, 2010Each time there is a new product from Microsoft, an edition is a consideration. Each has something to do with performance, runtime, price and license requirement for individuals or corporations.
With the release of SQL Server 2008 R2, aside from people asking the meaning of R2, editions are also being asked. Which one is right for us?
This time, Microsoft divided it into Core, Specialized and Free editions. Underneath each, there are subcategories to address specific requirements.
Core is for the enterprise and small to large businesses. Specialized are for web hosting, remote access and various software developments. Free is definitely free for entry levels and those doing mobile applications.
In summary, the Enterprise and Standard editions are now under CORE. The Workgroup, Web and Developers editions are within the SPECIALIZED. Lastly, the Express and Compact 3.5 are under the FREE editions. If you happen to hear about SQL Azure Database, that’s another story. That one is for Cloud Computing.
The R2 is simply “Release 2”.