John Sterrett 4.8
Abstract: You will walk away from this session with an understanding of how to use the Policy Based Management and Central Management Server to complete a daily checklist against your whole SQL Server farm. We will cover the basics to evaluate, monitor and apply best practice policies, which are included out of the box with SQL Server 2008. We will also make custom policies to cover additional best practices to evaluate daily checklist items. Finally, we will combine Policy-Based Management and Central Management Server with the Enterprise Policy Management Framework on codeplex to automate the monitoring process and create manager friendly reports to monitor your checklist items against the whole SQL Server farm.
Deliverables: You will be able to install and configure Central Management System You will be able to use CMS and/or PBM to complete a daily checklist You will be able to evaluate and build custom policies.
Session Prerequisites: Session prerequisites assume you are familiar with SQL Server Management Studio, have an instance of SQL Server 2008, and that you have administrative access with SQL Server. You don't have to be familiar with Policy-Based Management or Central Management Server, you will learn the basics during this session.