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.

Ask this episode

“What did the council decide on item 42?” — answered with the speaker and the moment.

Transcript

Related