官术网_书友最值得收藏!

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.

  1. 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)
  2. 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)
  3. 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)
主站蜘蛛池模板: 井冈山市| 顺平县| 朔州市| 万宁市| 工布江达县| 竹北市| 葫芦岛市| 苏尼特左旗| 恩施市| 应城市| 分宜县| 思南县| 涞水县| 罗平县| 本溪市| 合阳县| 津市市| 新巴尔虎右旗| 房产| 绿春县| 庆阳市| 遂溪县| 诸城市| 来安县| 安乡县| 平罗县| 原平市| 阳曲县| 双鸭山市| 宜兴市| 花垣县| 边坝县| 利川市| 清镇市| 巴东县| 沅陵县| 株洲市| 镶黄旗| 栾川县| 申扎县| 翁源县|