Features of SQL Server 2008 List 1 Programming Logic and Code with Syntax

Transport Data Encryption:-
      We can enable  the encryption of an entire database, files or log files without the any need  for application changes.

 Top 100+ Sql Server Interview Questions

 Advantages -
        1- We can search encrypted data using fuzzy search and range search.
        2- We can search secure data from un-authorised users.
        3- WE can encrypt without any required changes in the Applications.


Key Management :-
        2008 delivers a good solution for Supporting Third party key.

Auditing :-

       1- DDL can be used for creating and managing auditing.
       2- Comprehensive data auditing.
       3- We can identify about the data read.

Database Mirroring :-
      1-  It provides automatic page repairing.
      2-  It provide Improved performance.
     Features of SQL Server 2008 List 1