Microsoft SharePoint Server 2010 deployments can grow exponentially across an organization, quickly becoming an essential business platform for collaboration, content management, and business intelligence (BI). Protect information, ensure availability, and minimize storage costs by deploying Microsoft SQL Server 2008 R2 Enterprise alongside SharePoint Server 2010. Provide people with the scalable, reliable tools that they need to collaborate and unlock business insights.
Enable business insight throughout an organization with the integrated BI capabilities of SQL Server 2008 R2 Enterprise and SharePoint Server 2010.
Enable real-time access to information for thousands of employees.
Control access to specific reports and data.
Publish reports directly to report libraries or embed in SharePoint Server pages.
Take advantage of automatic configuration and synchronization between SQL Server Reporting Services and SharePoint Server.
Enable employees to create compelling, self-service BI solutions.
Streamline integration of data from multiple sources.
Examine large sets of data in the familiar Microsoft Excel interface.
Facilitate sharing and collaboration on user-generated insights.
Empower employees to analyze massive quantities of data.
Monitor and manage how users share and collaborate from a management dashboard.
Empower users and enable visual decision making with interactive maps.
Create reports with geospatial data in Report Builder.
Enhance location-based data reports with Bing Maps.
Include mapping, routing, and custom shapes to help put data in context.
Scale up to meet the most demanding performance and storage requirements, and enhance search and BI by deploying SharePoint Server 2010 on SQL Server 2008 R2 Enterprise.
Scale up to eight CPUs with SQL Server 2008 R2 Enterprise with no limit on the number of cores.
Support up to 2 TB of physical memory with SQL Server 2008 R2 Enterprise or the operating-system maximum with SQL Server 2008 R2 Datacenter.
Add CPU or physical memory to a live system without stopping database services.
More easily plan downtime when adding hardware.
Execute parallel index and consistency check operations.
Improve query performance by partitioning large tables onto separate file groups and making operations parallel.
Lower costs for your SharePoint Server deployment by taking advantage of enhanced compression, storage, and virtualization capabilities in SQL Server 2008 R2 Enterprise.
Host multiple databases in the same instance.
Install multiple instances on the same database server.
Implement multiple virtual database servers on the same physical server.
Compress SharePoint Server lists and backups.
Store SharePoint Server documents on less expensive hardware with Remote BLOB Storage while managing them as though they are part of the database.
Protect against data loss and unplanned downtime with high-availability technologies in SQL Server 2008 R2 Enterprise, including failover clustering, database mirroring, and log shipping.
Enjoy native support for database mirroring in SharePoint Server 2010.
Increase data protection with redundancy of data.
Ensure availability of data by bringing online a standby copy of the database.
Take advantage of mirroring enhancements in SQL Server 2008 R2 Enterprise.
Enable seamless failover capabilities in the event of a CPU, memory, or other nonstorage hardware failure.
Share disk access among nodes and restart SQL Server on a working node in the event of a failure.
Automatically send transaction log backups from a primary database on a primary server instance to one or more secondary systems.
Combine log shipping with database mirroring or failover clustering for more complete business continuity management.
Add resiliency against administrator or user error, or during routine updates and patching.
Use database snapshots when exporting or backing up sites with SharePoint Server 2010.
Maintain historical data for report generation.
Create a test database to run test protocols that require the same data for each test scenario.
Reduce risk of unauthorized access and comply with regulatory codes in a SharePoint Server 2010 deployment with key security and audit features in SQL Server 2008 R2 Enterprise.
Encrypt the entire database on the disk to protect against lost or stolen disks or backup media.
Enjoy transparent data encryption without making any changes to SharePoint Server.
Automatically encrypt backups.
Protect against direct access to database files.
Minimally impact performance and avoid increasing database size.
Meet government or industry requirements such as the Payment Card Industry Data Security Standards.
Track and log event changes to database objects and stored procedures, server configuration settings, or audit configuration settings.
© 2013 Microsoft Corporation. All rights reserved.