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.
Bio: John Sterrett is a database administrator at Orrick Herrington & Sutcliffe, an international law-firm, and is responsible for over 100 instances of SQL Server. John has been active within the SQL Server community, including hosting the first SQL Saturday in West Virginia. John also presented a lightning talk and chalk-talk at the SQL Server 2010 Member Summit , presented sessions at three SQL Saturday's, and presented to the Pittsburgh SQL Server User Group. John is a syndicated blogger at SQLServerPedia and contributes tips at MSSQLTIPS. You can find his blog at www.johnsterrett.com
The meeting starts at 6:00 PM CST with food, Introduction by Experis and a QA session. Main presentation starts at 6:30 PM
301 Congress Avenue, Suite 360
Austin, TX 78701
Upon arriving at Experis, you may part on the street for free after 5:30PM CST.
We will not validate parking in the building garage.