Microsoft® SQL Server 2008 R2

A rock-solid foundation for business, big and small.

PEER 1 Hosting is delighted to offer our Dedicated Hosting customers the new Microsoft SQL Server 2008 R2 database. With its reliability, supreme scalability and advanced security measures, it’s guaranteed to keep your business running smoothly.

If you’re looking 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 organize and manage your data efficiently, whether you’re building your next great application or storing vital business information.

Security

PEER 1 recognises that data security is a top priority for every business. With enhancements to encryption, security auditing and policy-based management, Microsoft SQL Server 2008 R2 will protect your database from unauthorised connections in a secure environment 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 ecommerce solution or SQL-powered application. 

 

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 Mobile (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;  analyse 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 organisation's master data; use models and hierarchies to group and organise data, preparing it for use in your business
  • Increased Maximum Database Size  The largest database supported by SQL Server Express has been increased from 4 GB to 10 GB.*
  • 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; collaborate through centrally stored datasets.

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