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 Monday, January 18, 2010 11:56 AM
SSC-Addicted

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

Group: General Forum Members
Last Login: Friday, September 12, 2014 3:52 PM
Points: 417, Visits: 764
Thanks for your Questions and clarifications... Special thanks to Steve...

Still lot of tricks to learn in PBM, will post it soon...

Thanks
Jay
www.sqldbops.com


Thanks
Jay
http://www.sqldbops.com
Post #849315
Posted Monday, January 18, 2010 11:58 AM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Friday, July 11, 2014 8:30 AM
Points: 137, Visits: 648
Steve Jones - Editor (1/18/2010)
Jorge,
looking forward to the book

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


Thank you very much! I just submitted a couple of ones I think you guys will enjoy


=============================================================
/* 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 #849316
Posted Monday, January 18, 2010 12:18 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 3:14 PM
Points: 2,580, Visits: 3,834
Thanks Steve for the explanation. I thought I over-thought.
Post #849320
Posted Friday, February 12, 2010 5:41 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 8:47 AM
Points: 8,832, Visits: 9,389
A very useful question. I've learned something new. Policy-based management begins to look more useful.

But I guess MS must have changed their mind at some point but forgot to change BOL. The very first sentence in the Administering Servers by Using Policy-Based Management section (http://msdn.microsoft.com/en-us/library/bb510667.aspx) is
Policy-Based Management is a system for managing one or more instances of SQL Server 2008.
- and that was last updated as recently as November 2009.


Tom
Post #865024
Posted Sunday, February 14, 2010 7:19 AM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Friday, July 11, 2014 8:30 AM
Points: 137, Visits: 648
Tom.Thomson (2/12/2010)
A very useful question. I've learned something new. Policy-based management begins to look more useful.

But I guess MS must have changed their mind at some point but forgot to change BOL. The very first sentence in the Administering Servers by Using Policy-Based Management section (http://msdn.microsoft.com/en-us/library/bb510667.aspx) is
Policy-Based Management is a system for managing one or more instances of SQL Server 2008.
- and that was last updated as recently as November 2009.


Actually to add to your excitement, that line is a little misleading. Not only can you manage your 2008 instances but you can manage your 2000, 2005 instances as well as Express/Standard/Enterprise editions. The only caveat is that because some features didn't exist is down-level versions (i.e. no DMV's in 2000, no filestream in anything less than 2008) your policies may not work. In order to get around that when you build a policy you can do an edition restriction and specify a policy to only apply to whichever version/edition you'd like.


=============================================================
/* 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 #865254
Posted Sunday, February 14, 2010 1:56 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 8:47 AM
Points: 8,832, Visits: 9,389
Jorge Segarra (2/14/2010)
Actually to add to your excitement, that line is a little misleading.
Yes, that's what I meant when I said MS must have forgotten to change BOL.


Tom
Post #865309
Posted Tuesday, March 16, 2010 10:00 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, June 13, 2014 3:03 PM
Points: 594, Visits: 655
Tom.Thomson (2/12/2010)
A very useful question. I've learned something new. Policy-based management begins to look more useful.

But I guess MS must have changed their mind at some point but forgot to change BOL. The very first sentence in the Administering Servers by Using Policy-Based Management section (http://msdn.microsoft.com/en-us/library/bb510667.aspx) is
Policy-Based Management is a system for managing one or more instances of SQL Server 2008.
- and that was last updated as recently as November 2009.

Great question, I am glad it came up. I just taught an upgrade class from 2005 to 2008 and BOL had also led me to believe that PBM was for 2008 only. I should have looked a little deeper I guess

At least I have another selling point for my customers who are considering upgrading!

Keep 'em coming!


Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
Post #883943
Posted Tuesday, March 16, 2010 1:25 PM
SSC-Addicted

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

Group: General Forum Members
Last Login: Friday, September 12, 2014 3:52 PM
Points: 417, Visits: 764
Thanks and I've written another article about evaluating policies on mutliple instances (SQL 2008 , 2005 and 2000), that will be published end of this month, I hope that will be more fun...


Thanks
Jay
http://www.sqldbops.com
Post #884142
Posted Tuesday, March 30, 2010 10:40 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 8:59 AM
Points: 11,194, Visits: 11,166
Tough question for one measly little point.



Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #893045
Posted Tuesday, March 30, 2010 1:09 PM
SSC-Addicted

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

Group: General Forum Members
Last Login: Friday, September 12, 2014 3:52 PM
Points: 417, Visits: 764
Hope this would be useful for all...

http://www.sqlservercentral.com/articles/Policy-Based+Management/69587/



Thanks
Jay
http://www.sqldbops.com
Post #893212
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse