United States   Change   |   All Microsoft Sites

Home

SharePoint Deployments on SQL Server 2008

Manageable, Available and Secure with Business Intelligence integration

New Graphics Enhancement in Reporting Services on SharePoint

Spotlight

New Graphics Enhancement in
Reporting Services on SharePoint

The Microsoft® SQL Server 2008® data platform supports the advanced functionality of Windows SharePoint Services 3.0 and Office SharePoint Server 2007. SQL Server enables the data-driven nature of these services, and SharePoint Products and Technologies leverage the advanced management, availability, performance, and security features of SQL Server for business-critical SharePoint deployments.

Key New Features for Enhanced SharePoint Support

 

SQL Server Management Server

SQL Server Management Studio

click image to enlarge

 

 

Policy-Based Management

Policy-Based Management

Manageability

Streamlined management tools for your database administrators to reduce complexity.

Policy-Based Management

  • Through SQL Server, define policies and apply them your SharePoint databases to conform to company policy or help meet negotiated service level agreements.

  • Create a policy, for example, that ensures SharePoint Servers do not reach a maximum duration between backups.

  • Enable a process whereby database administrators can see how the database environment and/or specific entities within are in compliance with defined intent or policies.

Central Management Server Designation

  • Implement management policies and procedures across individual managed instances through a single designated central management server.

  • As SharePoint deployments grow across multiple SQL Server instances, the Central Management Server helps simplify the implementation of policies and procedures.

Backup Compression

  • Help reduce the amount of I/O required in writing the backup SharePoint data to the backup device, significant improvements can be expected in the speed of the backup, as well as providing greater storage efficiency for your SharePoint backup sets.

 

Database Mirroring Wizard

Database Mirroring Wizard

click image to enlarge

Availability

Increase the availability of business-critical SharePoint applications.

Data Mirroring Enhancements

  • Help improve the performance of your SharePoint database mirroring and overall recovery time in a failover event with log performance enhancements.

  • Log performance enhancements include compression stream of data, write-ahead on the mirrored server, improved log caching, page read-ahead during the undo phase.

  • Improved automatic recovery from corrupted pages where the unreadable page is automatically replaced by a copy if the request is successful.

 

Encryption turned on for Content Databases

Encryption turned on for Content Databases

Security

Protect your SharePoint assets through enhanced security features.

Transparent Data Encryption

  • Removes the need for changes to the SharePoint application for encoding and decoding as required with cell-level encryption.

  • Designed to be as transparent as possible with minimal impact on the users that interact with the data.

  • For SharePoint administers, TDE can be enabled for those deployments’ content, shared services, and/or configuration databases with no changes in SharePoint Central Administration.

 

New graphics enhancements in Reporting Services on SharePoint Server

New graphics enhancements in Reporting Services on SharePoint

Business Intelligence Integration

Take advantage of embedded Reporting Services capabilities on SharePoint pages.

Enhanced Integration

  • Propagate business intelligence reporting across your SharePoint users

  • Help reduce complexity around enabling embedded reports on SharePoint pages through a simplified interface to the SQL Server report server

New Charts

  • With increased investment in new visualization capabilities, SQL Server 2008 Reporting Service offers an enhanced charting engine. This new engine brings many possibilities to SharePoint as a report center.

  • SharePoint users can choose from a large variety of chart types, which enable decision makers to view data in a friendlier format that enables them to quickly see the big picture.

Report Builder

  • Build reports directly from a SharePoint page without the need for development skills.

  • Launch a Report Builder from a SharePoint page, build reports based on semantic report models from SQL Server 2008 databases.

  • Publish reports directly to SharePoint sites for streamlined distribution of information.

Additional Resources

 

Take the next step

Try SharePoint Server 2007

Download the Essential Backpack
TechNet IT Pros Start Here
MSDN Developers Start Here