Evaluating database properties
I still remember the days when a DBA's life was not as easy as it is today. Some of the database configurations are very important, and changes in those properties can cause big issues. So, we had to write a customized script to check those database properties, schedule them in SQL Server Agent, and get a report by e-mail every day, so that if any change were found in an important property of the database, we could take action immediately, before it started creating an issue. Life is not that difficult now; we can use PBM to keep an eye on those properties.
Getting ready
The following are the prerequisites for the recipe:
SQL Server Denali (2012) CTP 3 or higher
Login credentials that have the sysadmin role in SQL Server, may be
SAor an administrator login for windows, if we connect through windows authentication
How to do it...
Follow the steps given here to perform this recipe:
Connect to the server, using Object Explorer, and move to Management | Policy Management...
