The SQL Server Best Practices Analyzer and Policy Based Management

The SQL Server Best Practices Analyzer (BPA) came out for SQL Server 2008 R2 recently, and I’ve been asked what the difference is between the BPA and Policy Based Management (PBM) that was introduced in SQL Server 2008. While it’s true both of these tools can do similar things, each has strengths and weaknesses. The…

4

Policy Based Management

One of the biggest new features in SQL server 2008 is Policy Based Management (PBM), which used to be called Declarative Management Framework (DMF). This feature can be compared to a “state machine” – that means it can set a state for you and either enforce that state or report on the state.   You…

0