It is confirmed that Microsoft SQL Server 2008 R2, which will be released in May, is the latest version of the SQL Server database. This article will introduce the 10 new features of SQL Server 2008 R2. The R2 mark indicates that this is an intermediate version of SQL Server, not a major version. , but the R2 version also provides a lot of interesting new features for DBAs and developers. At the time of writing this article, R2 is already in the Community Release Version (CTP). In addition to new features, two new versions have also been released: SQL Server 2008 R2 Datacenter (Data Center Edition) and SQL Server 2008 R2 Parallel Data Warehouse (Parallel Data warehouse version). For more reports on SQL Server 2008, please refer to the special topic: SQL Server 2008 In-depth Application.
1.Report Builder 3.0
Report Builder is a tool set through which you can develop reports published to the Web. Report Builder can create reports containing images, charts, tables and print controls. In addition, Report Builder also supports drill-down and sorting. If you are familiar with Third-party reporting tools, such as Crystal Reports, then you will definitely use Report Builder.
New features in SQL Server 2008 R2/Report Builder 3.0 include: ○1 map layers, which can hold spatial and analytical data and can be seamlessly integrated with Microsoft Virtual Earth; ○2 indicators for Displays the status of a value; ○3 Report component, this object can be reused or shared between multiple reports; ○4 Aggregation calculation (Aggregate Calculating), allows you to calculate the summary value of other aggregate calculation results.
2.SQL Server 2008 R2 Datacenter
The Data Center Edition of SQL Server 2008 R2 is targeted at Enterprise Edition users who require better performance. 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 the Parallel Data Warehouse Edition, officially code-named "Madison". Its main goal is to process very large amounts of data. It uses large-scale parallel processing capabilities to spread large tables to multiple SQL nodes. These nodes are controlled through Microsoft's patented technology Ultra Shared Nothing, which can allocate query tasks to various computing nodes and then collect computing results from each node.
4.StreamInsight
There is a new component in SQL Server 2008 R2 called StreamInsight. This interesting component allows analyzing streaming data on the fly, that is, processing it directly from the source data stream and then saving it to the data table. If your system is a real-time system, this function is very, very useful, because the real-time system needs to analyze data without causing delays in data writing. Some common examples include stock trading data flow, Web click analysis flow, and Industrial process control that can monitor multiple input data streams simultaneously.
5.Master data service
Master Data Services (MDS) is both a concept and a product. The concept of Master Data Services is to have a centralized data entry gatekeeper for core business data. Data items such as customer billing address, employee/customer name, and Product names should be managed centrally so that all consumer application systems have the same information. Microsoft provides an example where a customer address is recorded in the customer table, but a different address is recorded in the mailing table. The Master Data Services application can ensure that all tables have only one correct address, and while an MDS can be a local application, SQL Server 2008 R2 includes an application and an interface to manage Core Data.
6.PowerPivot for SharePoint
PowerPivot is an end-user tool that works in conjunction with SharePoint, SQL Server 2008 R2, and Excel 2010 to process large amounts of data in seconds. PowerPivot acts a bit like a PivotTable in Excel, providing analytical capabilities.
7. Data layer application
Data-Tier Application (Data-Tier Application, abbreviated as DAC, I don’t know what C stands for, don’t be confused with Windows Data Access Component, because its abbreviation is also DAC) is an object that can store all the required databases for a project Information such as logins, tables and stored procedures that Visual Studio can use. By creating a data layer application, the SQL Server package version is saved with each Visual Studio compiled version, which means that the application and database can be built into a unified version to facilitate later maintenance and management.
8.Unicode compression
SQL Server 2008 R2 uses a new algorithm to provide a simple compression scheme for Unicode storage. Unicode compression can reduce the space occupied by Unicode characters. It is automatically managed by the SQL Server engine, so there is no need to modify existing applications. , the DBA does not need to make any intervention.
9.SQL Server Utility
The new SQL Server Utility is a warehouse object that centrally controls multiple SQL Server instances. Performance data and configuration policies can be stored in a single Utility. The Utility also includes a resource manager tool that can create multiple server dashboards.
10.Multi-Server Dashboard
Although SQL Server Management Studio can also connect to multiple servers, it cannot view all databases on a centralized view. Each database server needs to be managed independently. In SQL Server 2008 R2, it is possible to create dashboards that display multiple servers at the same time. plate.