SQL Server 2008 R2 new enhancements
SQL Server 2008 R2 meets the large-scale requirements with first-hand enhancements such as two new premium editions and comprehensive additions to existing server editions. The new additions to server and specialized editions of SQL Server 2008 R2 can accommodate the requirement from the lowest level to the highest level of Enterprise needs by offering manageability and straightforward monitoring capabilities.
The installation requirements vary based on the application requirements, and the different editions of SQL Server 2008 R2 which support different features independent to other editions. They offer rich functionality to support mission-critical transactional (OLTP) and Business Intelligence (OLAP) analytical workloads that can be synchronized to access from any type of device. The newest service provision in SQL Server 2008 R2 is SQL Azure, which is a cloud-based relational database service built on SQL Server technologies.
To develop a data management solution to offer performance, scalability, and availability, the selection of SQL Server edition is essential. Though SQL Server 2008 R2 is classified as a marginal change to SQL Server 2008 version, the new editions meet the needs of large-scale data centers and data warehouse deployment. The existing core server edition is coupled with robust and enhanced offerings to enable the highest service levels for mission-critical data loads and provide optimized results. SQL Server editions are classified into three categories: Other, Core, and Premium editions.
- The Other category of editions is as follows:
- SQL Server 2008 R2 Express and Express with Advanced Services (free and lightweight to use)
- SQL Server 2008 R2 Compact (standalone and mobile devices)
- SQL Server 2008 R2 Workgroup (to host branch applications and provide remote synchronization capability)
- SQL Server 2008 R2 Web (secure and scalable platform for websites)
- SQL Azure (cloud-based offering with relational data model)
- SQL Server 2008 R2 Developer (equivalent to Enterprise edition for builds and test purpose only)
- The Core category of editions is as follows:
- SQL Server 2008 R2 Standard (reliable data management and BI offering for small and medium-sized organizations)
- SQL Server 2008 R2 Enterprise (comprehensive data management solution with end-to-end BI solutions for large organizations)
- The 'new' Premium category of editions is as follows:
- SQL Server 2008 R2 Datacenter (highest levels of scalability for mission-critical applications in large-scale data centers)
- SQL Server 2008 R2 Parallel Data Warehouse (accelerate data processing by using Massive Parallel Processing (MPP) technology)