SQL Server 2008 R2 十个新特性复习
SQL Server 2008 R2 十个新特性复习
1. Report Builder 3.0
Report Builder is a set of tools, through which can be developed to Report on the Web, through the Report Builder can create contains images, graphs, tables and print control Reports, in addition, the Report Builder also supports drill-down and sorting, if you are familiar with the third party reporting tools, figure Crystal Reports, Crystal Reports), then you will be using Report Builder.
The new features in SQL Server 2008 R2/Report Builder 3.0 include: map layer 1, which can accommodate space and analysis data, which can be seamlessly integrated with Microsoft Virtual Earth;
The level 2 indicator is used to display the state of a value;
A report component, which can be reused or Shared between multiple reports;
Aggregate calculation allows you to calculate summary values of other Aggregate computed results.
2.SQL Server 2008 R2 Datacenter
SQL Server 2008 R2's data center version is aimed at enterprise users who want better performance, and the new version supports 256 logical processors, more instances and more memory.
3.SQL Server 2008 R2 Parallel Data Warehouse
Another new version of SQL Server 2008 R2 is a parallel version of the data warehouse, formal code is "Madison", its main goal is to deal with very large amount of data, it USES massively parallel processing capabilities will be big table across multiple SQL nodes, the nodes through the patent technology of Microsoft, Ultra Shared Nothing to control, it can query tasks assigned to each compute nodes, then collecting results from various nodes.
4. The StreamInsight
SQL Server 2008 R2 in the emergence of a new component, called the StreamInsight, this interesting component allows analysis of stream data in the running, which is directly from the source data stream processing, and then save the data in the table.
If your system is a real-time system, the function is very, very useful, because the real-time system needs to analyze the data, but it can't cause the delay when writing data, some common examples such as stock trading data streams, Web click flow analysis and industrial process control, and can simultaneously monitor multiple input data stream.
5. Master data service
Master Data Services (Master Data Services, MDS) is a concept and a product, the concept of Master Data service is the core business Data have a centralized Data entry, the custodian Data items such as client billing address, employee/customer name, as well as the product name should be centralized management, so that every consumer has the same information application system.
Microsoft provides an example, in the customer table records the address of a customer, but in the mailing list record a different address.
Master data services applications can ensure that all tables only a correct address, and a MDS can be a local application, SQL Server 2008 R2 includes a core data application and an interface management.
6. PowerPivot for SharePoint
PowerPivot is an end-user tool, it with SharePoint, SQL Server 2008 R2 and Excel 2010 joint use, can handle a large number of data in a few seconds, PowerPivot role is a bit like the Excel pivottables, provides the analysis function.
7. Application of data layer
Application Data layer (Data - Tier Application, abbreviated DAC, don't know what meaning, on behalf of C should not be confused with Windows Data access components, because it is the abbreviation of DAC) is an object, it can store all your needs for a project of database information, such as login, tables, and Visual Studio can use stored procedures.
By creating a data layer application, SQL Server package version save with each compiled versions of Visual Studio, is the application and the database can be built into a unified version, convenient maintenance and management.
Unicode compression 8.
SQL Server 2008 R2, using a new algorithm for Unicode storage provides a simple compression scheme, through the Unicode compression, can reduce the Unicode characters of space occupied, it automatically by a SQL Server engine management, so there is no need to modify an existing application, the DBA also does not need to do any interference.
9. SQL Server Utility
New SQL Server Utility is a central control object, multiple instances of SQL Server warehouse performance data and allocation strategy can be stored in a single Utility, the Utility also includes a resource manager tool, you can create multiple Server dashboard.
10. Multi-server dashboard
Although the SQL Server Management Studio also can connect to multiple servers, but not on a centralized view to see all the database, each database Server requires independent Management, in SQL Server 2008 R2, can create the dashboard display multiple servers at the same time.
Report Builder is a set of tools, through which can be developed to Report on the Web, through the Report Builder can create contains images, graphs, tables and print control Reports, in addition, the Report Builder also supports drill-down and sorting, if you are familiar with the third party reporting tools, figure Crystal Reports, Crystal Reports), then you will be using Report Builder.
The new features in SQL Server 2008 R2/Report Builder 3.0 include: map layer 1, which can accommodate space and analysis data, which can be seamlessly integrated with Microsoft Virtual Earth;
The level 2 indicator is used to display the state of a value;
A report component, which can be reused or Shared between multiple reports;
Aggregate calculation allows you to calculate summary values of other Aggregate computed results.
2.SQL Server 2008 R2 Datacenter
SQL Server 2008 R2's data center version is aimed at enterprise users who want better performance, and the new version supports 256 logical processors, more instances and more memory.
3.SQL Server 2008 R2 Parallel Data Warehouse
Another new version of SQL Server 2008 R2 is a parallel version of the data warehouse, formal code is "Madison", its main goal is to deal with very large amount of data, it USES massively parallel processing capabilities will be big table across multiple SQL nodes, the nodes through the patent technology of Microsoft, Ultra Shared Nothing to control, it can query tasks assigned to each compute nodes, then collecting results from various nodes.
4. The StreamInsight
SQL Server 2008 R2 in the emergence of a new component, called the StreamInsight, this interesting component allows analysis of stream data in the running, which is directly from the source data stream processing, and then save the data in the table.
If your system is a real-time system, the function is very, very useful, because the real-time system needs to analyze the data, but it can't cause the delay when writing data, some common examples such as stock trading data streams, Web click flow analysis and industrial process control, and can simultaneously monitor multiple input data stream.
5. Master data service
Master Data Services (Master Data Services, MDS) is a concept and a product, the concept of Master Data service is the core business Data have a centralized Data entry, the custodian Data items such as client billing address, employee/customer name, as well as the product name should be centralized management, so that every consumer has the same information application system.
Microsoft provides an example, in the customer table records the address of a customer, but in the mailing list record a different address.
Master data services applications can ensure that all tables only a correct address, and a MDS can be a local application, SQL Server 2008 R2 includes a core data application and an interface management.
6. PowerPivot for SharePoint
PowerPivot is an end-user tool, it with SharePoint, SQL Server 2008 R2 and Excel 2010 joint use, can handle a large number of data in a few seconds, PowerPivot role is a bit like the Excel pivottables, provides the analysis function.
7. Application of data layer
Application Data layer (Data - Tier Application, abbreviated DAC, don't know what meaning, on behalf of C should not be confused with Windows Data access components, because it is the abbreviation of DAC) is an object, it can store all your needs for a project of database information, such as login, tables, and Visual Studio can use stored procedures.
By creating a data layer application, SQL Server package version save with each compiled versions of Visual Studio, is the application and the database can be built into a unified version, convenient maintenance and management.
Unicode compression 8.
SQL Server 2008 R2, using a new algorithm for Unicode storage provides a simple compression scheme, through the Unicode compression, can reduce the Unicode characters of space occupied, it automatically by a SQL Server engine management, so there is no need to modify an existing application, the DBA also does not need to do any interference.
9. SQL Server Utility
New SQL Server Utility is a central control object, multiple instances of SQL Server warehouse performance data and allocation strategy can be stored in a single Utility, the Utility also includes a resource manager tool, you can create multiple Server dashboard.
10. Multi-server dashboard
Although the SQL Server Management Studio also can connect to multiple servers, but not on a centralized view to see all the database, each database Server requires independent Management, in SQL Server 2008 R2, can create the dashboard display multiple servers at the same time.
原文链接：http://www.jxszl.com/biancheng/shujuku/445473.html
