SQL Server 2008 – Szybkie tworzenie polis
Posted by C3PO w dniu 22 lipca 2010
Ostatnio zdarzyło mi się parę razy użyć mechanizmu Policy-Based Management dostępnego w SQL Server 2008 (i 2008 R2). Zacząłem eksperymentować i szukać wszelkich opcji, które umożliwiłyby w miarę szybkie i sprawne tworzenie polis takiemu leniwemu DBA, jak ja :-)
Jedną z takich opcji jest opcja dostępna w menu kontekstowym okna Object Explorer w Management Studio. Klikamy na przykład prawym przyciskiem myszy na nazwie instancji SQL Servera i wybieramy opcję Facets.
Pojawia się okno właściwości obiektu (w tym przypadku serwera) w kontekście wybranego szablonu (pole Facet). A na samym dole okna… Tada! Przycisk Export Current State as Policy :-)
Klikamy, zapisujemy polisę do pliku XML albo od razu na instancję SQL Server, otwieramy świeżutko utworzoną polisę, edytujemy. Czysta przyjemność! A wszystko w oparciu o przygotowany wzorzec serwera, bazy, obiektu w bazie danych (można sprawdzić, że pozycja Facets pojawia się w menu kontekstowym po kliknięciu w zasadzie na cokolwiek w oknie Object Explorer).
Nie powiem, zabawka w sam raz dla takich leniuszków, jak ja. Łatwiej zrobić polisę opartą o nieco bardziej rozbudowany warunek i usuwać zbędne właściwości z warunku, niż tworzyć wszystko rękami w pocie czoła ;-)
Jasne i ciemne strony baz danych 
Mason said
Zongzi according to the origin: record „, renewal neat harmonic qu yuan’s fifth vote in the Gu Luo – Jiang, Truman cry, the date to lay aside meters, bamboo, to cast the she offering seki, leaves with colour silk, not for dragon bind that stolen. Do not take cold water bath immediately after a heavy work out, traveling, a long walk etc. Bacon is fairly popular in Sichuan, Huanan and Guangdong Province. Games: The Brau’s favorite pastime activities are spinning top, flying butterfly-shaped kites, swimming in the river, rope tug of war rope seizing, hide and seek, stick walking, etc. Choose very fresh of them, cut to small pieces, marinated with spice of pepper, chili sauce, onion, fish sauce for absorbed.
burn fat said
Hello There. I discovered your weblog using msn. This is a very well
written article. I’ll make sure to bookmark it and come back to learn extra of your helpful info. Thanks for the post. I’ll certainly comeback.
Anonim said
I am really enjoying the theme/design of your web site.
Do you ever run into any browser compatibility problems?
A couple of my blog readers have complained about my
blog not working correctly in Explorer but looks great in Safari.
Do you have any tips to help fix this issue?
http://healthychoicegarciniacambogia.net said
I’m amazed, I must say. Seldom do I encounter a blog that’s equally
educative and amusing, and without a doubt, you have hit the nail
on the head. The problem is something that too few
folks are speaking intelligently about. I am very happy that I found this in
my search for something concerning this.
click here said
Thanks a lot lots with regard to sharing the following operating individuals that you know what you’re really talking about! Book marked. Make sure you furthermore take a look at my website Equals). You can employ a link exchange deal amongst us
chinese weight loss tea said
I all the time emailed this blog post page to all my contacts, since
if like to read it then my friends will too.
Darryl said
I personally much loved your entire blog page and also feelings.
You may be impressive.
Thanks a ton for installing this important plus i dream to start reading incredibly more on your behalf down
the road.
Incredible perform holding your web site correct as well as , some
really good without needing any and all useless posts.
Does a person have a methods with regard to my very own blog keeping keep
in mind this free of spammy?
For just about any inspiring ideas in order to
jot down because of fantastic high-quality prefer your
home?
Remorseful in my english language :) it really is never ever my personal natural terms, anticipation you’re able to fully understand
Muscle Rev Xtreme said
I was wondering if you ever thought of changing the page layout of your
blog? Its very well written; I love what youve got
to say. But maybe you could a little more in the way
of content so people could connect with it better.
Youve got an awful lot of text for only having one or two pictures.
Maybe you could space it out better?
Sabine said
This really is an outstanding website, thanks because of this.
I have to be able to bing designed for lots of hrs to look for
this region.
We hate anytime anytime I really the search engines designed for content for you to undertake I personally typically reveal
pointless content articles together with loads of junk.
An individual evidently require treatment method for each of the unsolicited mail plus
retain your web site pick up together with top quality.
Does one have got approaches for our weblog?
Pro nutra green coffee bean reviews said
If some one wishes to be updated with most recent technologies therefore he must
be pay a quick visit this site and be up to date every day.
Maximum Shred Review said
I’ve been browsing online more than 2 hours today, yet I never found any interesting article like yours. It’s pretty worth enough for me.
In my opinion, if all site owners and bloggers made good content as you did, the net will be much more useful than ever before.
Transportation Services & Sales said
I’m really impressed with your writing skills and also with the layout on your weblog. Is this a paid theme or did you customize it yourself? Anyway keep up the nice quality writing, it’s rare to see a nice blog
like this one these days.
patriceayres said
You can certainly see your enthusiasm in the work you write.
The sector hopes for more passionate writers like
you who aren’t afraid to say how they believe. At all times follow your heart.
Buy instant income said
At this time I am ready to do my breakfast, later than having
my breakfast coming yet again to read additional news.
abusive relationships abusive relationships signs abusive relationships stories abusive relationships quotes abusive relationships hotline abusive relationships quiz abusive relationships tumblr abusive relationships movies abusive relationships articles said
abusive relationships abusive relationships signs abusive relationships stories abusive relationships quotes abusive relationships hotline abusive relationships quiz abusive relationships tumblr abusive relationships movies abusive relationships arti…
SQL Server 2008 – Szybkie tworzenie polis « Jasne i ciemne strony baz danych
types of plastic surgery said
Awesome issues here. I am very satisfied to peer your post.
Thanks a lot and I am taking a look ahead to touch you.
Will you please drop me a e-mail?
Web Fortune Master Income said
Hello! Would you mind if I share your blog with my myspace group?
There’s a lot of people that I think would really enjoy your content.
Please let me know. Many thanks
weight loss said
Good day! Do you use Twitter? I’d like to follow you if that
would be ok. I’m definitely enjoying your blog and look forward to new updates.
relationshipadvice said
We are a bunch of volunteers and starting a brand new scheme in our
community. Your website provided us with useful info to
work on. You have performed a formidable job and
ourwhole community shall be thankful to you.
Raspberry Ketones Ultra said
I visited various websites but the audio quality for audio songs existing at
this web site is truly marvelous.
Defibrillator Costs said
If you desire to increaae your know-how only keep visiting this website and be updated with the most up-to-date news posted here.
pure green coffee capsules dr oz said
Seriously, are there weight loss pills out there that really work and are not just some big scam?.
United National Moving and Storage said
Hi, I do think this is a great web site. I stumbledupon it ;) I’m going to revisit once again since I book-marked it.
Money and freedom is the best way to change, may you be rich and continue to help
others.
typy bukmacherskie said
I was wondering if you ever thought of changing the layout
of your site? Its very well written; I love what
youve got to say. But maybe you could a little more in
the way of content so people could connect with it better.
Youve got an awful lot of text for only having 1 or 2 images.
Maybe you could space it out better?
Stephaine said
Hi, all is going sound here and ofcourse every onee is sharing facts, that’s
genuinely fine, keep up writing.
http://www.nosecontour.com said
Excellent post. I was checking constantly this weblog and I’m impressed!
Very helpful information specially the last phase :
) I take care of such information a lot. I was seeking this
certain information for a long time. Thank you and good luck.
natural garcinia cambogia dr oz said
Hі, afteг reading this awesome article i am
too happy to share mmy knowledge here with mates.
Bernardo said
Hi friends, fastidious piece of writing and fastidious
urging commented at this place, I am really enjoying by these.
how to lose weight said
whoah thius blog is fantastic i love reading your posts. Stay up the great
work! Yoou realize, many individuals are hunting round for thi info,
you could help them greatly.
thinmagicmax.com said
If some one needs expert view on the topic of blogging and site-building afterward i recommend him/her to
go to see this website, Keep up the nice work.
YELP said
Everything published was very logical. But, what about
this? what if you added a little content? I ain’t suggesting your content
is not solid., but suppose you added a title that grabbed
people’s attention? I mean SQL Server 2008 –
Szybkie tworzenie polis Jasne i ciemne strony baz danych is a little boring.
You might look at Yahoo’s front page and watch how
they create post headlines to get viewers to open the links.
You might add a related video or a related pic or two
to grab people interested about what you’ve written.
In my opinion, it could bring your blog a little bit more
interesting.
lose weight fast said
lose weight fast
SQL Server 2008 – Szybkie tworzenie polis « Jasne i ciemne strony baz danych
cheats trainer said
I could nnot resist commenting. Very well written!
work from home said
What’s up, yeah this article is genuinely pleasant and I have learned lot of things from it about blogging.
thanks.
azurite malachite said
Our intuitive powers are greatly enhanced and
we will be able to see things before they occur.
Use Chrysoberyl to attract your creative energy
and attract your creativity to you, you will find that
the creative vibes will just flow to and thru you when you carry this
crystal. Additionally, (9) An internet kill switch approval
for the U.
Williemae said
whoah this weblog is great i love reading your articles.
Stay up the great work! You already know, many persons are searching round
for this info, you could aid them greatly.
garcinia vs green coffee bean said
What’s up, for all time i used to check blog posts here early
in the dawn, since i enjoy to find out more and more.
Julianne said
Very great post. I just stumbled upon your blog and wished to mention that I’ve truly
enjoyed browsing your blog posts. After all I’ll be subscribing
on your rss feed and I’m hoping you write once more soon!
Bighospeda.Net.Br said
I leave a comment when I appreciate a article on a website or if I
have something to add to the discussion. Usually it is triggered by the fire communicated in the article
I read. And after this article SQL Server 2008 – Szybkie tworzenie polis Jasne
i ciemne strony baz danych. I was excited enough to drop
a thought ;) I actually do have a couple of questions for you if you don’t mind.
Is it simply me or do some of the comments appear like
coming from brain dead visitors? :-P And, if you are writing on additional online sites,
I would like to keep up with you. Would you list every
one of your public pages like your twitter feed, Facebook page
or linkedin profile?
Gretchen said
whoah this blog is excellent i like reading your posts.
Stay up the good work! You already know, a
lot of people are hunting around for this information, you can aid them
greatly.
lipo g3 trial said
Heya! I just wanted to ask if you ever have any trouble with hackers?
My last blog (wordpress) was hacked and I ended up losing a few months of hard work due
to no backup. Do you have any methods to prevent hackers?
garcinia camboja said
garcinia camboja
SQL Server 2008 – Szybkie tworzenie polis « Jasne i ciemne strony baz danych
More Clients said
Admiring the commitment you put into your site and in depth information you provide.
It’s awesome to come across a blog every once in a while that isn’t the same out of
date rehashed information. Excellent read! I’ve saved your
site and I’m adding your RSS feeds to my Google account.
glutenfree34.kazeo.com said
You can still get an excellent meal at a restaurant that doesn’t participate directly in the program, because the restaurants often have
gluten-free pasta stashed away for their regular clients, and they’re
already well familiar with celiac disease and gluten-free food.
In contrast to high priced drugs and medical care, the improvement dietetic therapy is free of
charge. Cool the baking sheet for 5 minutes before adding more
cookies to it.
Basketball Coach said
Extend the arm and hand at 90 degrees toward the ball, palm down (as in first photo).
A code of ethics takes care of these violations,
which have caused spectacular scandals in the history of
baseball. For example, an award certificate for
service might include a concise description of what the recipient has done for the
organization or community.
professional resume services san jose said
professional resume services san jose
SQL Server 2008 – Szybkie tworzenie polis « Jasne i ciemne strony baz danych
gummy bear implants said
Hey there, You have done a great job. I’ll certainly digg it and personally
recommend to my friends. I am confident they’ll be benefited from this website.
Ameer Akram said
Very helpful post!! Followed you over here from Mugwump. Being from India I have never needed such knowledge, but you never know when things will change. Gynecomastia Surgery in Hyderabad
prashanth ellendula said
Very useful post. This is my first time i visit here. I found so many interesting stuff in your blog especially its discussion. Really its great article. Keep it up. Rhinoplasty in Hyderabad