SQL Server 2008 (code name 'Katmai') delivers on the Microsoft data platform vision by enabling organizations to run their mission critical applications. Following are the main qualities of the new platform:
It is now possible to encrypt your entire database, data files, log files without needing any application changes and without affecting end users. This enables organizations to meet the demands of regulatory compliance and overall concern for data privacy. SQL Server 2008 provides excellent support for managing security keys within the enterprise by supporting third-party key management and hardware security module (HSM) products. For the growing need of auditing related compliance needs, this version of SQL Server can be used to audit activities on your data such as when particular data was read, what data was modified and by whom, etc. You can define audit specifications on each database, so auditing can be ported with databases. Filtering of audit of specific objects allow better performance in audit generation and flexibility in configuration.
It is now possible to encrypt your entire database, data files, log files without needing any application changes and without affecting end users. This enables organizations to meet the demands of regulatory compliance and overall concern for data privacy.
SQL Server 2008 provides excellent support for managing security keys within the enterprise by supporting third-party key management and hardware security module (HSM) products.
For the growing need of auditing related compliance needs, this version of SQL Server can be used to audit activities on your data such as when particular data was read, what data was modified and by whom, etc. You can define audit specifications on each database, so auditing can be ported with databases. Filtering of audit of specific objects allow better performance in audit generation and flexibility in configuration.
Hot Add CPU allows a database to be scaled on demand. More CPU resources can be added on supported hardware platforms without requiring any application downtime.
Other important features like extended events, backup compression, data compression, resource governor and plan freezing. Resource Governor enables DBAs to define resource limits and priorities for different workloads, which enables concurrent workloads to provide consistent performance to end users. Plan freezing enables greater query performance stability and predictability by providing new functionality to lock down query plans. This enables organizations to promote stable query plans across hardware replacements, server upgrades, and production deployments
Other important features like extended events, backup compression, data compression, resource governor and plan freezing. Resource Governor enables DBAs to define resource limits and priorities for different workloads, which enables concurrent workloads to provide consistent performance to end users.
Plan freezing enables greater query performance stability and predictability by providing new functionality to lock down query plans. This enables organizations to promote stable query plans across hardware replacements, server upgrades, and production deployments
Microsoft has annouced that it will launch SQL Server 2008, along with Windows Server 2008 and Visual Studio 2008, at an event in Los Angeles on Feb. 27, 2008.