Policy-Based SQL Server Management with Boris Hristov

How do you manage your SQL Servers? Richard talks to Boris Hristov about using Policy-Based Management tools in SQL Server. These tools have been in the box since SQL Server 2008, but it's amazing how many folks still don't use them - are you really RDPing into every SQL Server? Hristov talks about using the Policy-Based Management tools to sweep across all of your SQL Servers and check what various settings are at - and change them if you need to! The conversation also digs into creating a Central Management Server to have a repository of all SQL Server instances and make it easy to propagate changes. Finally, if you're ready to step up your SQL management game, take a look at the Enterprise Policy Management Framework, a CodePlex project to do detailed analysis and reporting on your entire SQL Server landscape.

Episode 417 of the RunAs Radio podcast, hosted by Richard Campbell, titled "Policy-Based SQL Server Management with Boris Hristov" was published on April 22, 2015 and runs 33 minutes.

April 22, 2015 ·33m · RunAs Radio

Summary

How do you manage your SQL Servers? Richard talks to Boris Hristov about using Policy-Based Management tools in SQL Server. These tools have been in the box since SQL Server 2008, but it's amazing how many folks still don't use them - are you really RDPing into every SQL Server? Hristov talks about using the Policy-Based Management tools to sweep across all of your SQL Servers and check what various settings are at - and change them if you need to! The conversation also digs into creating a Central Management Server to have a repository of all SQL Server instances and make it easy to propagate changes. Finally, if you're ready to step up your SQL management game, take a look at the Enterprise Policy Management Framework, a CodePlex project to do detailed analysis and reporting on your entire SQL Server landscape.

Episode Description