SQL Server 2008 introduces automatic auditing - Sql server 2008

SQL Server 2008 introduces automatic auditing. Explain its benefits

Automatic auditing is a true auditing solution for enterprise customers. STL Trace can be used for satisfying several auditing needs. SQL Server Auditing feature offers a number of advantages that attracts and help DBAs with much more easily achievable goals. These include meeting regulatory compliance requirements. These include,
- Provision for centralized storage of audit logs and integration with system center
- Better performance that is noticeable
- Permits free-grained auditing in which an audit can be targeted for some specific actions by a principle against a particular object.
- Allows the objects of audit to be treated as first class database objects, which mean Transact-SQL DDL statements can create these objects.
- The database object is controlled by database engine’s permission model and enforcement control.
- A new level permission is featured in SQL Audit – ALTER ANY SERVER AUDIT- which allows a principle to CREATE, ALTER and DROP an Audit Specification object.
- A database level permission – ALTER ANY DATABASE AUDIT – is introduced to allow a principle to CREATE, ALTER and DROP a Database specification object.
Compression - row-level and page-level compression - Sql server 2008
Data compression is a feature which is used to reduce disk storage space and increase the performance of the query by reducing the I/O operations..........
What is filtered indexes in sql server 2008? - Sql server 2008
Filtered index in SQL Server 2008 is an index WHERE clause. A filtered index is an optimized non-clustered index.........
Resource governor - Sql server 2008
Resource Governor enables the DBA for managing the work load of SQL Server and critical system resource consumption...........
Post your comment