From the course: SQL Server 2016: Administer a Database Infrastructure
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Introduction to Policy-Based Management - SQL Server Tutorial
From the course: SQL Server 2016: Administer a Database Infrastructure
Introduction to Policy-Based Management
- [Male Voiceover] It's likely that you're organization or company has implemented a series of best practices when it comes to the development and maintenance of your SQL server databases. It's not uncommon to codify these policies in notebooks or other physical documents that should be, but often aren't referred to regularly in an effort to maintain consistency throughout the organization. Policy-based management seeks to simplify that process. SQL servers policy-based management brings those offline paper best practices and standards into the server environment. It helps automate the enforcement of those system design policies. When implemented, policy-based management, or PBM, can ensure that all of your servers and databases across the organization conform to a set of standard operating procedures and configurations. It can operate passively and provide a detailed audit of non conforming systems that should be addressed. Or PBM can play an active maintenance role and actually…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.