Wat is er nieuw in deze versie?
Hieronder wat dingen die mij opvielen:
- Microsoft BI Solution stack
SQL Server 2008 R2 delivers a complete data infrastructure and BI platform, works with Microsoft SharePoint Server 2010 to supply a reliable and highly secure collaboration platform, and extends Microsoft Office 2010 to provide an intuitive and familiar user platform with powerful analytics capabilities. The Microsoft BI solution stack is a cornerstone in the Microsoft BI vision to provide business insight to all employees, leading to better, faster, more relevant decisions. - Improve IT Efficiency
Administrators benefit from interoperability with SharePoint Managed Services to provide comprehensive management and monitoring of self-service BI activities - Track usage patterns over time, drill down to obtain more details, discover mission-critical solutions and make sure appropriate server resources are provisioned to ensure high availability and performance
- Centralized Visibility and Control
SQL Server 2008 R2 delivers enhancements to enable management of database instances and applications from a single location - Resource Optimization
Use new enhancements to gain insights for improved consolidation management to reduce server sprawl - Support for >64 Cores
Achieve greater single system scale with support for up to 256 logical processors when deploying SQL Server 2008 R2 on Windows Server 2008 R2 - Unicode Compression
Unicode compression in SQL Server 2008 R2 uses an implementation of the Standard Compression Scheme for Unicode (SCSU) algorithm to compress Unicode values that are stored in row or page compressed objects - MDS Management Hub
Master data hub that provides central management of master data entities and hierarchies - MDS Version ManagementThe reporting, auditing and versioning features help to protect master data and ensure compliance by maintaining change histories and logging user, date, and time for each master data update as well as pertinent audit details, such as type of change, member code and prior versus new value.
- MDS Role-based SecurityWith role-based security administrators can lock down data and have granular control over what data a given user (or group or role) may access across models, applications, and systems, even down to individual rows and columns in data sets.
- Excel worksheet integrationExcel worksheets provide all data visualization and interaction. PivotTables, PivotCharts, filters and Slicers provide the presentation of PowerPivot data you create in the PowerPivot window.
- Report Parts
Report parts are report items that you store on a report server, or on a SharePoint site that is integrated with a report server. You can reuse report parts in multiple reports, and you can update them on the server. - Sparklines, Databars
Sparklines and databars are simple charts that convey a lot of information in a little space, often in line with text - Calculating Aggregates of Aggregates
You can create expressions that calculate an aggregate of an aggregate - Supports Multiple SharePoint ZonesYou can use the alternate access mapping functionality in your SharePoint environment to access report server items from one or more of the following SharePoint zones: default, Internet, intranet, extranet or custom.
/via Bink.nu http://bink.nu/news/sql-server-2008-r2-rtm.aspx
Geen opmerkingen:
Een reactie posten