- Microsoft SQL Server 2008 R2 Administration Cookbook
- Satya Shyam K Jayanty
- 392字
- 2021-04-02 19:33:37
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)
- ColdFusion 9 Developer Tutorial
- AutoCAD 2010中文版基礎教程(第2版)
- Flash CC中文版動畫設計與制作/微課堂學電腦
- 從零開始:Flash CS6中文版基礎培訓教程
- CakePHP 1.3 Application Development Cookbook
- Drupal: Creating Blogs, Forums, Portals, and Community Websites
- UG NX 8.0模具設計教程
- Autodesk Ecotect Analysis綠色建筑分析應用
- 剪映短視頻剪輯從入門到精通:宣傳短片+電商視頻+產品廣告+活動慶典
- Moodle Course Conversion: Beginner's Guide
- 用Studio One輕松制作你的短視頻音樂
- Maya腳本應用手冊:表達式與MEL語言
- MSC Fatigue疲勞分析標準教程
- SPSS統計分析從入門到精通(第五版)
- CAXA軟件應用技術基礎