The goal of the DBA Virtual Group is to provide a PASS community for the DBA. It provides a forum for open discussion and education on issues that face SQL Server database administrators.

Central Management Server and Multi-Server Administration – sponsored by Dell Software

Wed, Jul 08 2015 18:00 UTC

Central Management Server and Multi-Server Administration – sponsored by Dell Software

Two 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 deploy these two powerful features right out of the box without writing a single line of PowerShell code.

Mike Hillwig

SQL Server MVP Mike Hillwig is a Native Pittsburgher and resident of the Boston suburbs. He's a senior DBA for a provider of private cloud-based solutions for the financial industry 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.

Interested in Presenting to the DBA VG?

We can always use people to give a talk at one of our bi-monthly events. If you are interested in giving a presentation, please send your title, a brief abstract and a brief bio to Sharon Dooley.

Want to become a member of the DBA VG Leadership team?

Members of this team moderate meetings and interact with the speakers during the Q&A sessions. Contact Sharon Dooley, if you'd like to become part of the team.

Have a speaker to recommend?

Send the email address of the proposed speaker together with any relevant information about the speaker to Sharon Dooley.


Meeting Recordings

The DBA Virtual Group presentations are recorded. On the Meeting Archive page, you will find  .WMV files that can be viewed on-line. Select the event you are interested in, click the Show More button if it is visible, and the recording and any associated files will be visible.

Regular Meeting Schedule

The DBA Virtual Group holds two regular webinars each month. The first one is on the second Wednesday at noon, Mountain time and the second one is on the fourth Wednesday at noon, Eastern time. These 1 - 1¼ hour presentations include slides, demos and a time for questions and answers. The meetings are recorded and archived.


Follow us on Twitter: @PASS_DBA_VC

Back to Top