Redgate will be hosting another SQL in the City event on the Monday right before the PASS Summit 2015. This is a free all day […]
Category: Policy Management
Policy Based Management White Paper
Below is a link to a white paper I wrote on Policy Based Management. It serves as a guide to not only explain the technology […]
Policy Based Management On Change: Prevent not available
Policy Based Management has 4 evaluation modes and if you are not already familiar with them you can go HERE to get more information. Today […]
SQLRally Dallas Slides
I was fortunate enough to get to present not 1 but 2 sessions at SQLRally 2012 in Dallas last week. As a core organizer of […]
Setup Alerts for PBM
PBM raises errors for policy violations. We can create alerts on those errors to be notified of policy violations. In order to setup alerts on […]
See if Auto Create Statistics is enabled using PBM
We will walk through creating a policy to evaluate the status of “Auto Create Statistics” on our server named “File2”. First we need to open […]
Import MS Best Practice Policies
Let’s take a look at how to import the Microsoft Best Practice Policies into your Policy Based Management Server. You can also import policies that you […]
PBM On Schedule Mode
Let’s take a look out how to schedule policy evalution using the PBM On Schedule mode. Start by double clicking on the policy of your choice. Next […]
PBM Evaluation Methods
There are four different ways we can evaluate policies against servers in our environment. These methods are all manual and I will cover how to automate […]
PBM Evaluation Modes
PBM has four evaluation modes that provide us with flexibility in the way we evaluate policies against our SQL instances. Here are the options and what […]
You must be logged in to post a comment.