1 / 12

Mastering Policy-Based Management in SQL Server: Best Practices and Insights

Dive into Policy-Based Management (PBM) for SQL Server, a powerful tool for maintaining consistency and compliance within your databases. This presentation covers the architecture, essential features, and actionable demos for effectively managing one or more instances of SQL Server (2000/2005/2008). Discover the benefits of PBM, including ease of management, policy enforcement, and real-time compliance monitoring to meet regulations like HIPAA and SOX. Connect with our IT team to amplify your SQL Server management capabilities and streamline operations seamlessly.

kairos
Télécharger la présentation

Mastering Policy-Based Management in SQL Server: Best Practices and Insights

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Policy Based Management 101 Jorge Segarra Email: jorge@sqlchicken.com Blog: http://sqlchicken.com Twitter: http://twitter.com/sqlchicken

  2. University Community Health • Serving Tampa since 1968, started with 208-bed facility • Today: UCH-Main Campus (Fletcher, 357-bed facility), UCH-Carrollwood, Pepin Heart Hospital, Women’s Center, Breast Care Center, Helen Ellis Memorial Hospital, LTAC + various Physician Care branches • ~4,000 End users • IT Dept 40-50; 15 in Technical Services • Over 400+ applications! • ~100+ SQL Servers (2000/05/08) • Almost 50% virtualized!

  3. Agenda • What is PBM • Architecture • Demos/Examples • Questions

  4. What is PBM? • A system for managing one or more instances of SQL Server 2008* (BOL) • *Can manage 2000/2005 as well

  5. Why Policy Based Management? • Ease of Management • CMS (Req. SQL 2008 Std or higher) • Consistency • Apply policies across multiple servers • Policy control on SQL 2000 and higher* • Control • Compliance (HIPAA,SOX) • Prevent / Notify Changes • “Free” *Not all features/policies apply on < 2008

  6. Model / Architecture • Policies • Includes condition/expected behavior • Desired state / what targets / when to check • Can only contain one condition • Conditions • Boolean Expression specifies target type • i.e. Name LIKE ‘sp_%’ • Facet • Logical dimension properties • Category • Classification to help manage policies. • 1 Category per Policy

  7. Model / Architecture

  8. Key Features • Policies • Expressive conditions • Facets • Ad hoc evaluation • Policy Automation • Policy Violation Alert • Policy Health • Policy Category • Create Policy from State • Multiple Server Mgt • Non-DB Engine Support • Surface Area configuration facets • Down-level Support • 2000 and above • Out-of-Box Best Practices (demo)

  9. DEMO

  10. Resources • Download SQL 2008 Enterprise(180 days) • http://www.microsoft.com/sqlserver/2008/en/us/trial-software.aspx • Free SQL 2008 Hosted Test Labs • http://sqlserverbeta.com • SQLPBM Blog • http://blogs.msdn.com/sqlpbm/default.aspx • Using PBM in SQL 2008 (HongeiGuo) • http://tinyurl.com/ll2kzw • MSDN • http://msdn.microsoft.com/en-us/library/bb510667.aspx • Enterprise Policy Mgt Framework • http://epmframework.codeplex.com/

  11. EPM Framework

  12. Questions?Contact info:email: jorge@sqlchicken.comblog: http://SQLCHICKEN.COMTWITTER: @SQLCHICKENfeedback:http://speakerrate.com/sqlchicken

More Related