Do More With Less: SQL Central Management Server and SQL Agent - Mike Hillwig

Two of the of the most under-utilized management features of SQL Server are the Central Management Server and the SQL Agent Multi-Server Administration tools. The CMS is a powerful little tool creates a catalog of servers that allows you to execute any query or script against multiple servers at the same time. The SQL Agent Multi-Server Administration (MSX) tool allows you to create a SQL Agent job on one server and then deploy it to multiple servers instantly. When used in conjunction with each other, you have a powerful set of features that make managing your enterprise a lot simpler.

SQL Server MVP Mike Hillwig will show you how to to deploy these two powerful features right out of the box without writing a single line of new code.