SQL Server 2008 Policy-Based Management

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Jayakumar Krishnan » SQL Server 2008 Policy-Based Management

20 posts, Page 1 of 2

1 2 »»

SQL Server 2008 Policy-Based Management

Rate Topic

Display Mode

Topic Options

Author

Message

Jayakumar Krishnan

Posted Sunday, January 17, 2010 11:39 AM

SSC-Addicted

Group: General Forum Members
Last Login: Thursday, May 09, 2013 11:58 AM
Points: 415, Visits: 737

Comments posted to this topic are about the item SQL Server 2008 Policy-Based Management

Thanks
Jay
http://www.sqldbops.com

Post #848884

hakan.winther

Posted Monday, January 18, 2010 12:42 AM

SSCrazy

Group: General Forum Members
Last Login: Monday, May 06, 2013 5:31 AM
Points: 2,226, Visits: 438

Nice question! I learned something from it.

/Håkan Winther
MCITP:Database Developer 2008

Post #848992

ChiragNS

Posted Monday, January 18, 2010 5:17 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 5:02 AM
Points: 2,365, Visits: 1,825

learnt some thing. but how does it work?

"Keep Trying"

Post #849094

bitbucket-25253

Posted Monday, January 18, 2010 5:38 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 9:21 AM
Points: 5,099, Visits: 20,191

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

OCTom

Posted Monday, January 18, 2010 7:10 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 1:42 PM
Points: 2,012, Visits: 2,839

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

Steve Jones - SSC Editor

Posted Monday, January 18, 2010 8:19 AM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 1:47 PM
Points: 31,406, Visits: 13,722

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

Sqlchicken

Posted Monday, January 18, 2010 10:04 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 17, 2013 6:37 AM
Points: 134, Visits: 616

Nice question! Good thing our (Ken Simmons, Colin Stasiuk, myself) book on Policy Based Management (link here) is coming out soon Wink

</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

Tom Garth

Posted Monday, January 18, 2010 10:35 AM

SSC Eights!

Group: General Forum Members
Last Login: Friday, February 04, 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

SQLRNNR

Posted Monday, January 18, 2010 11:08 AM

SSCoach

Group: General Forum Members
Last Login: 2 days ago @ 1:46 PM
Points: 18,732, Visits: 12,329

This is good information to know. Thanks for the question.

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

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

Steve Jones - SSC Editor

Posted Monday, January 18, 2010 11:28 AM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 1:47 PM
Points: 31,406, Visits: 13,722

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 »

20 posts, Page 1 of 2

1 2 »»

Permissions