tutorial-administering-servers-by-using-policy-based-management.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	helpviewer_keywords
Tutorial: Managing servers using Policy-Based Management	This tutorial teaches you how to create and apply an off-by-default policy, and a naming-standards policy.	VanMSFT	vanto	03/14/2017	sql	security	tutorial	tutorials [Policy-Based Management] Policy-Based Management, tutorials

Tutorial: Managing servers using Policy-Based Management

[!INCLUDE SQL Server] Welcome to the Administering Servers by Using Policy-Based Management Policies tutorial. This tutorial is intended for users who are familiar with [!INCLUDEssNoVersion] but new to the Policy-Based Management.

What You Will Learn

This tutorial creates a policy to administer your server and a policy that applies to a single database. One policy is run on demand to test for compliance. The other policy enforces future compliance.

This tutorial is divided into two lessons:

Lesson 1: Create and Apply an Off By Default Policy
This lesson creates a policy that specifies that Database Mail is not enabled on the server. Then, it checks to see whether your server complies with the policy, and configures the server by disabling Database Mail.

Lesson 2: Create and Apply a Naming Standards Policy
This lesson creates a policy that defines and enforces a naming standard for tables.

Requirements

This lesson requires basic database knowledge and a basic understanding of [!INCLUDEssManStudioFull].

To use this tutorial, your system must have [!INCLUDEssManStudioFull] installed.

Start the Tutorial

Lesson 1: Create and Apply an Off By Default Policy

See Also

Administer Servers by Using Policy-Based Management