The PASS Data Architecture Virtual Group focuses on data architecture concerns as they impact users, developers and DBAs on the Microsoft SQL Server platform.

Login to Subscribe

Meeting Details

Enforce Best Practices with CMS and Policy Based Management

Wed, Aug 14 2019 18:00 UTC

Enforce Best Practices with CMS and Policy Based Management

You have a lot of servers and need to make sure you have consistent settings configured like disabling auto shrink, disabling extended stored procedures, or enabling database mail. I'll show you how to check those settings across all your servers with Central Management Server and how you can manage a disperse environment. You will learn how to leverage the power of Policy Based Management to enforce those settings and standards in your enterprise. Best of all, you will see how to get alerts sent to you when one of your settings is changed.


Ryan Adams

Ryan Adams is a Senior Premier Field Engineer for Microsoft. He works directly with customers to help them realize their business potential and accelerate their digital transformation on premises and in the cloud. Previously, Ryan was a Microsoft Data Platform MVP and spent 19 years working for a fortune 100 company. His passion is the SQL Server Engine, High Availability, and Disaster Recovery. He also served on the Board of Directors for the North Texas SQL Server User Group, was President of the PASS Performance Virtual Chapter, was a PASS Regional Mentor, and served as a Director for the PASS organization.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids