Join Martin Guidry for an in-depth discussion in this video Extending policy-based management to repair problems, part of SQL Server 2012: Designing Database Solutions.
- In this section, I'd like to show an example of using…policy management to correct some problems…on our SQL Server.…In previous examples, we saw how policy management…can help us find problems on the SQL Server,…and really if the tool did just that,…it would still be a great tool,…but the tool can go beyond that,…and in some cases it can help us not only find the problem…but also correct the problem.…To do this we'll need to create a new condition.…The facet I'm interested in is Database.…
Now I'm interested in the field AutoShrink.…Some DBAs really like AutoShrink.…Some DBAs really don't like AutoShrink.…I'm not going to get into that debate right now.…I'm just going to say, for purposes of this example,…I would like AutoShrink to be set to true…on all of my databases.…So I will test for, is it equal to true,…and I'll need to give this a name.…I'll just call it AutoShrink and hit okay.…Then we'll create a new Policy based on that condition.…
So the Check condition is AutoShrink.…I'll call this the AutoShrinkPolicy.…
- 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.