SQLServerPedia Syndication
All posts in this category get syndicated to SQLServerPedia.com
-
PASS Performance VC Reboot
The PASS Performance Virtual chapter is getting a reboot. We all know that responsibilities and schedules change, and that meant this chapter needed some additional hands on deck. Erin Stellato (Blog|Twitter) valiantly volunteered to take the helm and she put out an SOS for volunteers. The response was great with some wonderful people volunteering to help. I…
-
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 these errors there are three prerequisites. Note that violations for the “On Demand” evaluation mode do not raise errors. A policy must be set to “Enabled” to raise an error,…
-
SQLRally 2012 Registration Open
The Professional Association for SQL Server and the North Texas SQL Server User Group have been working hard behind the scenes to bring SQLRally 2012 in Dallas Texas to the SQL Community. We are excited to announce that event registration opens November 30, 2011. Make sure to get registered soon and take advantage of the…
-
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 SQL Server Management Studio and connect to our server. Then we need to enable Policy Management by expanding the Management node, right clicking on Policy Management, and selecting Enable. You…
-
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 have exported from other servers. The Microsoft Best Practice Policies are a great place to start learning what you can do with PBM, by simply importing them and inspecting their…
-
SQLSaturday #97 Wrap-up
#97 This was a great event! This was Austin’s first SQLSaturday, so it’s quite an accomplishment and something to celebrate. I brought my family with me since my wife wanted to do some shopping in San Marcos. The drive down went well and we only had two hickups. The first was just a minor hold…
-
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 we need to change the evaluation mode to On Schedule. As soon as you make this change you will notice a red warning appear at the top of the dialog…
-
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 them in another post. This is just a quick list to show your available options, and where they are located. We can evaluate a single policy against a single instance by…
-
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 we can use them for: On Demand – This is a manual policy evaluation. Policies in this mode can only be evaluated by performing a policy evaluation in SSMS. On Schedule…
-
Speaking at SQLSaturday #97
I will be speaking at SQLSaturday #97 in Austin, TX on October 1st, 2011. I will be delivering my presentation on database mirroring. I know the event team for this SQLSaturday and I can say without a doubt that it will be an event to be remembered. Wes Brown (Blog|Twitter), Jim Murphy (Blog|Twitter), and AJ Mendo (Blog|Twitter) are…
-
I’m a PASS Regional Mentor!
This past weekend I was speaking at SQLSaturday #90 in Oklahoma City. During the event I had the pleasure of sitting down and getting to know Karla Landrum (PASS Community Evangelist). We met each other at a SQLSaturday in Houston earlier this year, but we didn’t have much time to chat. We had a great…
-
SQLSaturday #90 Wrap-up
#90 This was a fantastic event! This was Oklahoma City’s first SQLSaturday, so it’s quite an accomplishment and something to celebrate. Tim Mitchell, Russell Loski, and I started off by heading from Dallas to Oklahoma City which only took about 3 hours. The speaker dinner was held at the Embassy Suites hotel restaurant. The hotel and restaurant…