SQL Server 2008 Question:

Download Job Interview Questions and Answers PDF

Do you know the policy based administration feature of SQL Server 2008?

MS SQL Server 2008 Interview Question
MS SQL Server 2008 Interview Question

Answer:

Policy based database administration allows the DBA for managing the instances and objects of SQL Server 2008 across the enterprise by a defined policies that are set. These policies are the rules and regulations which determine the possible ways of what to do and what not to do and the way the violations of policies are enforced and reported. The policies are well defined by using facets and conditions.

Facet: An object which contains the properties which well describes a component.

Condition: A logical expression that is defined on a facet. It is used for identification of acceptable property values of the facet.

Download MS SQL Server 2008 Interview Questions And Answers PDF

Previous QuestionNext Question
Tell me TIME data type, datetime2, datetimeoffset data type in sql server 2008?What is Change Data Capture (CDC) feature?