Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

SQL Server 2008 Policy-Based Management Expand / Collapse
Author
Message
Posted Sunday, January 17, 2010 11:39 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, July 3, 2014 4:16 PM
Points: 417, Visits: 759
Comments posted to this topic are about the item SQL Server 2008 Policy-Based Management

Thanks
Jay
http://www.sqldbops.com
Post #848884
Posted Monday, January 18, 2010 12:42 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 3, 2014 2:45 AM
Points: 2,531, Visits: 536
Nice question! I learned something from it.

/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
Post #848992
Posted Monday, January 18, 2010 5:17 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, June 27, 2014 5:39 AM
Points: 2,366, Visits: 1,843
learnt some thing. but how does it work?

"Keep Trying"
Post #849094
Posted Monday, January 18, 2010 5:38 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:37 PM
Points: 5,559, Visits: 24,477
ChiragNS learnt some thing. but how does it work?


These 2 blog poast might help you to learn how it works on 2005 & 2000

http://blogs.msdn.com/sqlpbm/archive/2008/07/04/using-pbm-against-sql2k-and-sql2k5.aspx

http://blogs.msdn.com/sqlpbm/archive/2008/07/04/using-pbm-against-sql2k-and-sql2k5.aspx


If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #849100
Posted Monday, January 18, 2010 7:10 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 10, 2014 2:24 PM
Points: 2,496, Visits: 3,666
Did I overthink this? Maybe. What I was think is that if you use 2008 PBM against 2005 or 2008, SQL would be using SMO under the covers and it would therefore, no longer be 2008 PBM. 2000 and 2005 do not have the DB changes necessary to use all of PBM.

Did I overthink it?

Post #849142
Posted Monday, January 18, 2010 8:19 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Wednesday, June 11, 2014 5:42 PM
Points: 33,007, Visits: 15,132
You did overthink it. PBM executes basic SQL against all editions. Many of the policy checks in 2008 are SQL as well, so they are the same checks. The things that don't exist in 2000/2005 can't be checked or error out.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #849193
Posted Monday, January 18, 2010 10:04 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 8:30 AM
Points: 137, Visits: 648
Nice question! Good thing our (Ken Simmons, Colin Stasiuk, myself) book on Policy Based Management (link here) is coming out soon </shameless plug>

=============================================================
/* Backups are worthless, Restores are priceless */

Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management
Post #849273
Posted Monday, January 18, 2010 10:35 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, February 4, 2011 7:20 AM
Points: 977, Visits: 1,499
Policies are not an item that I have worked with yet, but I do have to pass the #70-432 this year, and I'm sure knowing this is helpful.

Thanks.


Tom Garth
Vertical Solutions

"There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers
Post #849283
Posted Monday, January 18, 2010 11:08 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: 2 days ago @ 11:25 PM
Points: 21,093, Visits: 14,773
This is good information to know. Thanks for the question.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #849289
Posted Monday, January 18, 2010 11:28 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Wednesday, June 11, 2014 5:42 PM
Points: 33,007, Visits: 15,132
Jorge,
looking forward to the book

Perhaps you and your authors want to send in a few questions.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #849297
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse