Abstract
Before you can apply and enforce policies, you need to create them, because no policies are implemented by default in SQL Server 2008. You can create a policy in several ways, such as manually from scratch, using Transact SQL (T-SQL), exporting a policy based on your current SQL Server configuration, or even importing one of Microsoft’s policies based on best practices. In addition, by using advanced conditions when creating a policy, you will see that there is almost no limit to the types of policies you can create for your environment. As you start creating policies, you will also find it helpful to create categories, which allow you group and manage similar policies.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2010 Ken Simmons, Colin Stasiuk, Jorge Segarra
About this chapter
Cite this chapter
Simmons, K., Stasiuk, C., Segarra, J. (2010). Creating Policies. In: Pro SQL Server 2008 Policy-Based Management. Apress. https://doi.org/10.1007/978-1-4302-2911-7_2
Download citation
DOI: https://doi.org/10.1007/978-1-4302-2911-7_2
Publisher Name: Apress
Print ISBN: 978-1-4302-2910-0
Online ISBN: 978-1-4302-2911-7
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books