Scheduled Policy Evaluation on multiple servers using MSX/ TSX in SQL Agent

One of our customer was looking for ways to schedule a policy evaluation on multiple servers using their existing MSX/TSX infrastructure.  I thought it would be better to blog an article that could help others looking for similar information http://blogs.msdn.com/b/sqlagent/archive/2010/11/19/scheduled-policy-evaluation-on-multiple-servers-using-msx-tsx-in-sql-agent.aspx  This posting is provided “AS IS” with no warranties, and confers no rights. Use of included…

0

SQL 2008 Powershell Script for creating a Policy and saving to file

############################################################ SQL 2008 Powershell Script for Policy Based Management # Scenario: Create a  server policy to check if XPCmdShell is disabled and save it to file# # To run this Powershell script# 1) Install SQL Server 2008# 2) Run SQL PowerShell ( Start -> Run -> sqlps.exe)# 3) Copy the following script and paste it…

1