Put Your Feet Up : Simplified Management using the Enterprise Policy Management Framework

2009

TL; DR

Wouldn't you rather spend your day learning all the funky new features in SQL Server 2008 than running all your daily checks over your instances? SQL Server 2008 introduced Policy Based Management which allows a fine-grained level of configuration and control of the instance's properties. The Enterprise Policy Management Framework takes this and extends it out to allow you to manage SQL 2000 and 2005 instances through policies as well.

Session Details

In this presentation we will look at how SQL Server 2008 implements Policy Based Management and then by using Powershell and Central Management Servers, how we can take these policies and extend them out to SQL 2000 and 2005 instances.

This will also show where the EPMF can integrate with your repository database to ensure that you know all the instances installed and that they are all complying with your Company's SQL Server policies, making use of simple dashboards showing compliance levels and leaving you to study Books Online with your feet up!!

3 things you'll get out of this session

Martin Cairney's previous sessions

Smart Alerts in SQL DB using Automation and Logic Apps

Learn how to make Azure do the work for you by developing smart responses for Azure SQL DB alerts using Automation and Logic Apps.