Level: Intermediate
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