|
SQL Server 2008
 |
Published By: Microsoft
» Call me about this product
» Other products by this publisher
» Similar Products
|
|
| Not what you're looking for? Use our free
sourcing request
service. |
SQL Server 2008 delivers on Microsoft’s Data Platform vision by helping organisations manage any data, any place, any time. It enables users to store data from structured, semi-structured, and unstructured documents, such as images and music, directly within the database. SQL Server 2008 delivers a rich set of integrated services that enable users to do more with your data such as query, search, synchronise, report, and analyse. Data can be stored and accessed in your largest servers within the data center all the way down to desktops and mobile devices, enabling you to have control over data no matter where it is stored. |
Protect valuable information
- Transparent Data Encryption - enable encryption of an entire database, data files, or log files, without the need for application changes. Benefits of this include: Search encrypted data using both range and fuzzy searches, search secure data from unauthorised users, and data encryption without any required changes in existing applications
- Extensible Key Management - SQL Server 2005 provides a comprehensive solution for encryption and key management. SQL Server 2008 delivers an excellent solution to this growing need by supporting third-party key management and HSM products
- Auditing - create and manage auditing via DDL, while simplifying compliance by providing more comprehensive data auditing. This enables organisations to answer common questions, such as, "What data was retrieved?"
Ensure business continuity
- Enhanced Database Mirroring - SQL Server 2008 builds on SQL Server 2005 by providing a more reliable platform that has enhanced database mirroring, including automatic page repair, improved performance, and enhanced supportability
- Automatic Recovery of Data Pages - SQL Server 2008 enables the principal and mirror machines to transparently recover from 823/824 types of data page errors by requesting a fresh copy of the suspect page from the mirroring partner transparently to end users and applications
- Log Stream Compression - database mirroring requires data transmissions between the participants of the mirroring implementations. With SQL Server 2008, compression of the outgoing log stream between the participants delivers optimal performance and minimises the network bandwidth used by database mirroring.
Enable predictable response
- Resource Governor - provide a consistent and predictable response to end users with the introduction of Resource Governor, allowing organisations to define resource limits and priorities for different workloads, which enable concurrent workloads to provide consistent performance to their end users
- Predictable Query Performance - enable greater query performance stability and predictability by providing functionality to lock down query plans, enabling organisations to promote stable query plans across hardware server replacements, server upgrades, and production deployments
- Data Compression - enable data to be stored more effectively, and reduce the storage requirements for your data. Data compression also provides significant performance improvements for large I/O bound workloads, like data warehousing
- Hot Add CPU - dynamically scale a database on demand by allowing CPU resources to be added to SQL Server 2008 on supported hardware platforms without forcing any downtime on applications.
|