If your in Texas and interested in learning some tips to help you do SQL Server Performance Tuning with free tools then I highly suggest that you attend one of these presentations coming to a city near you!
If you cannot make it out no worries, you can catch a recorded version of my presentation.
Recently, it has come to my attention that there is a PowerShell User Group being born in Pittsburgh. The first user group meeting is December, 13th and Ed Wilson also known as TheScriptingGuy will be their first presenter. There are still a few seats available. If you are interested in developing scripts to automate processes I recommend you follow this user group.
You can still sign up
and registration is free
. In fact, everyone is a winner because there will be free pizza and every user group attendees knows there is no better prize than free pizza!
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.
Session goals include:
- You will be able to install, configure and run scripts against the Central Management Server
- You will be able to use Central Management Server and/or Policy-Based Management to complete a daily checklist
- You will be able to evaluate and build custom policies.
John Sterrett is a database administrator at Remote DBA Experts and a member of the Integrations team. John has been active within the SQL Server community, including hosting the first and second annual 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