A rock-solid foundation for businesses and data, both big and small.

With its reliability, supreme scalability and advanced security measures, Microsoft SQL Server 2008 R2 keeps your business and your data running quickly and smoothly.

If you’re searching for business-critical data storage and optimum performance, SQL Server 2008 R2 is among the most powerful and flexible databases on the market. It allows you to organise and manage your data efficiently, whether you’re building your next great application or storing vital business information.

Security

PEER 1 Hosting recognises that data security is a top priority for every business. With enhancements to encryption, security auditing and policy-based management, SQL Server 2008 R2 protects your database from unauthorised connections in a secure environment that is designed for maximum uptime.

Advanced Search Capabilities

Microsoft SQL Server 2008 R2 offers ‘fuzzy search’ technology, retrieving data based on similar spellings when you’re searching for objects that fall within a certain range of possibilities. The function identifies similarities in error-prone data, greatly enhancing your SQL-powered application or eCommerce solution.

 

Key Features

Resource Governor

Defines limits and priorities for concurrent workloads and consistent performance

Transparent Data Encryption

Enables encryption of a single database file or an entire database without having to change your application.

External Key Management

Support for third-party key management and Hardware Security Module (HSM) products.

Declarative Management Framework

Manage one or more instances of SQL Server 2008.

Server Group Management

Manage server groups from one central location including multiple SQL Server 2008 instances.

Performance Data Collection

Get performance data on disk usage, server activity and query statistics.

Backup Compression

Create and store backups using compression technology, saving space and making restoration faster and more efficient.

New Features

PowerPivot for Excel®

Assemble and create relationships in large amounts of data, and analyze data in Excel using the power of pivot tables.

Multi-server Administration and Data-Tier Application

Centralise your database administration and streamline the development, deployment and management of database objects used by your application.

Master Data Services

Manage and audit your organization's master data by using models and hierarchies to group and organise data.

Increased Maximum Database Size

The largest database supported by SQL Server Express has been increased from 4GB to 10GB.*

Better Security

Use service binding and channel binding to help prevent an authentication relay attack.

Reporting Services

Enhance reports with maps, spark lines, data bars and indicators to depict data and collaborate through centrally stored datasets.

*Maximum file size may also be subject to OS limitations.