SQL server 2008 Question:
Download Questions PDF

What is Declarative Management Framework (DMF) in SQL Server 2008?

Answer:

Declarative Management Framework is a system for managing the instances of SQL Server 2008. It is a policy based system. The database security can be tighten with polity management, automated administration and explicit administration. A policy can be designed for prohibiting the usage of unauthorized applications and the naming conventions on the database are implied for developers.

Various tasks are planned by many DBAs and backing up databases, reviewing events logs, scanning for improper / unauthorized object creations, long running query SPIDs killing are being performed. Lot of tactical and reactionary items on the list of tasks can keep the conscientious DBA busy.

SQL Server will enforce to define the policies by using Management Studio and select certain servers for enforcing the policy. These can be monitored from SSMS, which acts as a central console.

Download SQL server 2008 Interview Questions And Answers PDF

Previous QuestionNext Question
Tell me inline variable assignment in sql server 2008 with an example?Do you know Encryption of entire databases without the need for application changes in sql server 2008?