Join Martin Guidry for an in-depth discussion in this video Introduction to policy-based management, part of Designing Database Solutions for SQL Server 2012.
- In this section, I'd like to talk about…using policy-based management…to help you administer your SQL Server 2012 databases.…Policy-based management is a nice tool…that scales very well.…It's a tool that allows us to check certain characteristics…of every database on every server that we have.…So for example, we could look for a certain size table…and the machine would automatically check every table…in every database on every server.…
Therefore, as your infrastructure grows…and you get more databases…and more servers and more tables,…this tool still works equally well.…So here inside of SQL Server Management Studio,…I'm gonna open up the Management branch of the tree.…And the top item is Policy Management.…Under that, we see three things,…Policies, Conditions and Facets.…Let's start off talking about the bottom one, Facets.…And facets are collections of items that we can check,…and they are grouped…into some of the logical entities of a database.…
So for example, there's one on Data Files.…If we double-click on that,…
- Planning the database infrastructure
- Designing databases vs. data warehouses
- Designing the physical database implementation
- Planning for partitioning
- Adding FileStream data
- Monitoring server health
- Managing SQL Server with PowerShell
Skill Level Intermediate
1. Designing a Database Server Infrastructure
2. Designing a Logical Database Schema
3. Designing a Physical Database Implementation
4. Incorporating Data Files into Databases
5. Tuning Database Performance
6. Policy-Based Management
7. Monitoring Server Health
Exploring health data5m 3s
8. Managing SQL Server with PowerShell
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.