SIOS is proud to sponsor the New England User Group’s February meeting. If you’re in the area, I highly recommend checking out this month’s session “Do More With Less: SQL Central Management Server and SQL Agent” presented by SQL Server MVP and Database Administrator, Mike Hillwig.
Location: Microsoft Technology Center, One Cambridge Center, Cambridge, MA
Date: March 11, 2014
Time: 6:00 PM
Do More With Less: SQL Central Management Server and SQL Agent
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.
About Mike Hillwig
SQL Server MVP and Boston resident Mike Hillwig is a senior DBA for a global financial institution. He’s been working with SQL Server since version 7. He’s got a background in infrastructure and networking. In his current role, Mike’s portfolio of SQL servers grows weekly, sometimes daily. He’s quite passionate about automating administrative tasks. You can follow him on Twitter (@mikehillwig) and at his blog, mikehillwig.com.