SQH18 Managing SQL Server in the Enterprise

11/21/2013

3:00pm - 4:15pm

Level: Intermediate

Chad Churchwell

Premier Field Engineer

Microsoft

This session is intended to provide insight on how to achieve consistency and provide management with minimal overhead of a large scale SQL Server enterprise environment. Topics discussed will be utilizing a Central Management Server for centralized reporting and administration, utilizing Policy Based Management for enforcement of corporate standards and configurations, as well as installation topics to provide a consistent SQL Server install from server to server. When your enterprise is consistent, it makes life as a database administrator much easier, even in the largest of enterprises.

You will learn:

  • How to use a Central Management Server for registration and centralized reporting and alerting
  • How to enforce corporate and coding policies using Policy Based Management, where these are declared once and evaluated across your enterprise
  • How to standardize your SQL Server installations for consistency across the enterprise