Join Martin Guidry for an in-depth discussion in this video Using policy-based management to prevent problems, part of Designing Database Solutions for SQL Server 2012.
- Now I'm going to demonstrate how Policy Management…can be used to prevent certain changes…from happening in our SQL Server.…We can create a Policy that states rules…about how the SQL Server should be implimented…and then when we attempt to impliment…something in a different way…the Policy will block that change from happening.…For this example we'll need to set up a new Condition,…so I'll right-click and hit New Condition.…The Facet I'm interested in is Stored Procedures,…and the Field is the name of the Stored Procedure.…
I would like that name to be LIKE a phrase…that shows that all of our Stored Procedures…are named in a consistent way…with some phrase that identifies them as Stored Procedures.…So some people use sproc_…in front of every Stored Procedure…as a naming convention.…Here I've created a rule that will check for that,…so I'm looking for sproc_ and then the % sign.…The % sign is a wild card in this case,…so every Stored Procedure needs to start…with those certain characters…and then have any number of characters after 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.