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

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)
主站蜘蛛池模板: 垣曲县| 兴海县| 太湖县| 桂平市| 桐庐县| 舒城县| 金溪县| 微山县| 股票| 平顶山市| 珲春市| 稷山县| 忻州市| 澎湖县| 阿拉善左旗| 海宁市| 延长县| 新宁县| 漳州市| 象山县| 苏尼特右旗| 澄迈县| 南召县| 澄迈县| 社会| 乌兰浩特市| 远安县| 永济市| 利辛县| 东阳市| 余姚市| 奉化市| 丹寨县| 长汀县| 纳雍县| 漳州市| 仲巴县| 乐亭县| 赤城县| 自贡市| 来宾市|