SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Jayakumar Krishnan / SQL Server 2008 Policy-Based Management / Latest Posts

RE: SQL Server 2008 Policy-Based Management

Jayakumar Krishnan — Tue, 30 Mar 2010 13:09:17 GMT

Hope this would be useful for all...[url]http://www.sqlservercentral.com/articles/Policy-Based+Management/69587/[/url]

RE: SQL Server 2008 Policy-Based Management

Paul White — Tue, 30 Mar 2010 10:40:05 GMT

Tough question for one measly little point.

RE: SQL Server 2008 Policy-Based Management

Jayakumar Krishnan — Tue, 16 Mar 2010 13:25:47 GMT

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... :-)

RE: SQL Server 2008 Policy-Based Management

Peter Trast — Tue, 16 Mar 2010 10:00:44 GMT

[quote][b]Tom.Thomson (2/12/2010)[/b][hr]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 ([url]http://msdn.microsoft.com/en-us/library/bb510667.aspx[/url]) is [quote]Policy-Based Management is a system for managing one or more instances of SQL Server 2008.[/quote] - and that was last updated as recently as November 2009.[/quote]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 :-DAt least I have another selling point for my customers who are considering upgrading!Keep 'em coming!

RE: SQL Server 2008 Policy-Based Management

L' Eomot Inversé — Sun, 14 Feb 2010 13:56:57 GMT

[quote][b]Jorge Segarra (2/14/2010)[/b][hr]Actually to add to your excitement, that line is a little misleading. [/quote] Yes, that's what I meant when I said MS must have forgotten to change BOL.

RE: SQL Server 2008 Policy-Based Management

Sqlchicken — Sun, 14 Feb 2010 07:19:55 GMT

[quote][b]Tom.Thomson (2/12/2010)[/b][hr]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 ([url]http://msdn.microsoft.com/en-us/library/bb510667.aspx[/url]) is [quote]Policy-Based Management is a system for managing one or more instances of SQL Server 2008.[/quote] - and that was last updated as recently as November 2009.[/quote]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.

RE: SQL Server 2008 Policy-Based Management

L' Eomot Inversé — Fri, 12 Feb 2010 17:41:52 GMT

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 ([url]http://msdn.microsoft.com/en-us/library/bb510667.aspx[/url]) is [quote]Policy-Based Management is a system for managing one or more instances of SQL Server 2008.[/quote] - and that was last updated as recently as November 2009.

RE: SQL Server 2008 Policy-Based Management

OCTom — Mon, 18 Jan 2010 12:18:42 GMT

Thanks Steve for the explanation. I thought I over-thought. :-D

RE: SQL Server 2008 Policy-Based Management

Sqlchicken — Mon, 18 Jan 2010 11:58:38 GMT

[quote][b]Steve Jones - Editor (1/18/2010)[/b][hr]Jorge, looking forward to the bookPerhaps you and your authors want to send in a few questions.[/quote]Thank you very much! I just submitted a couple of ones I think you guys will enjoy :-P

RE: SQL Server 2008 Policy-Based Management

Jayakumar Krishnan — Mon, 18 Jan 2010 11:56:02 GMT

Thanks for your Questions and clarifications... Special thanks to Steve...Still lot of tricks to learn in PBM, will post it soon...ThanksJaywww.sqldbops.com

RE: SQL Server 2008 Policy-Based Management

Steve Jones - SSC Editor — Mon, 18 Jan 2010 11:28:51 GMT

Jorge, looking forward to the bookPerhaps you and your authors want to send in a few questions.

RE: SQL Server 2008 Policy-Based Management

SQLRNNR — Mon, 18 Jan 2010 11:08:05 GMT

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

RE: SQL Server 2008 Policy-Based Management

Tom Garth — Mon, 18 Jan 2010 10:35:06 GMT

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.

RE: SQL Server 2008 Policy-Based Management

Sqlchicken — Mon, 18 Jan 2010 10:04:05 GMT

Nice question! Good thing our (Ken Simmons, Colin Stasiuk, myself) book on Policy Based Management [url=http://www.amazon.com/gp/product/1430229101?ie=UTF8&tag=httpsqlchicco-20&linkCode=as2&camp=1789&creative=390957&creativeASIN=1430229101](link here)[/url] is coming out soon ;-) </shameless plug>

RE: SQL Server 2008 Policy-Based Management

Steve Jones - SSC Editor — Mon, 18 Jan 2010 08:19:27 GMT

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.

RE: SQL Server 2008 Policy-Based Management

OCTom — Mon, 18 Jan 2010 07:10:21 GMT

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?

RE: SQL Server 2008 Policy-Based Management

bitbucket-25253 — Mon, 18 Jan 2010 05:38:17 GMT

[quote]ChiragNS learnt some thing. but how does it work? [/quote]These 2 blog poast might help you to learn how it works on 2005 & 2000[url]http://blogs.msdn.com/sqlpbm/archive/2008/07/04/using-pbm-against-sql2k-and-sql2k5.aspx[/url][url]http://blogs.msdn.com/sqlpbm/archive/2008/07/04/using-pbm-against-sql2k-and-sql2k5.aspx[/url]

RE: SQL Server 2008 Policy-Based Management

ChiragNS — Mon, 18 Jan 2010 05:17:09 GMT

learnt some thing. but how does it work?

RE: SQL Server 2008 Policy-Based Management

hakan.winther — Mon, 18 Jan 2010 00:42:22 GMT

Nice question! I learned something from it.

SQL Server 2008 Policy-Based Management

Jayakumar Krishnan — Sun, 17 Jan 2010 11:39:01 GMT

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