Microsoft SQL Server 2008

Microsoft SQL Server 2008 CTP

Boost the performance of your data warehouse

Easily manage a growing number of users and data

Lower the cost of managing data, with SQL Server 2008

Run your mission-critical applications on a trusted platform that provides high levels of security and reliability. With Microsoft SQL Server 2008, you can drive better insight and business intelligence throughout your entire organisation by integrating information into your data warehouse faster and more efficiently.

Protect your information:
  • Encrypt data in an entire database or in data files without changing application codes.
  • Centralise auditing with new comprehensive data auditing capabilities, such as auditing when data has been read or when data modifications have been made.
  • Monitor all events at both the server and database levels.
Reduce total cost of ownership by simplifying administrative tasks:
  • Enforce configuration policy compliance and apply policies throughout your organisation with Declarative Management Framework.
  • Troubleshoot, tune, and monitor one or more instances of SQL Server across your organisation with Performance System Analysis.
  • Schedule automated administrative tasks, and respond proactively to events.
Deliver business intelligence where your users want it:
  • Control workload resource prioritisation and provide consistent performance to end users with Resource Governor.
  • Maximise storage, and increase query performance with built-in data compression.
  • Take advantage of improved performance, usability, and integration with the Microsoft Office 2007 system in SQL Server Reporting Services (US).
  • Efficiently store, manage, and analyse any kind of structured or unstructured data for a diverse range of data types, including relational data, XML documents, FileStreams, and spatial data.
Top features

Centralised auditing
Consolidate enterprise-wide audit records from multiple sources.

Declarative Management Framework
Define configuration policies, and apply them across the organisation.

Resource Governor
Define limits and priorities for different workloads.

Built-in data compression
Optimise your storage.

Performance Studio
Centralise and consolidate data services monitoring.

Transparent data encryption
Protect sensitive data.

Top of pageTop of page