Jasne i ciemne strony baz danych

… w szczególności MS SQL Server ;-)

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

Export 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 ;-)


Komentarzy 49 to “SQL Server 2008 – Szybkie tworzenie polis”

  1. 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.

  2. 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.

  3. 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?

  4. 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.

  5. 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

  6. I all the time emailed this blog post page to all my contacts, since
    if like to read it then my friends will too.

  7. 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
    Remorseful in my english language :) it really is never ever my personal natural terms, anticipation you’re able to fully understand

  8. 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?

  9. 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?

  10. 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.

  11. 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.

  12. 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.

  13. 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.

  14. At this time I am ready to do my breakfast, later than having
    my breakfast coming yet again to read additional news.

  15. 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

  16. 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?

  17. 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

  18. 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.

  19. 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.

  20. I visited various websites but the audio quality for audio songs existing at
    this web site is truly marvelous.

  21. 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.

  22. Seriously, are there weight loss pills out there that really work and are not just some big scam?.

  23. 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

  24. 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?

  25. Stephaine said

    Hi, all is going sound here and ofcourse every onee is sharing facts, that’s
    genuinely fine, keep up writing.

  26. 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.

  27. Hі, afteг reading this awesome article i am
    too happy to share mmy knowledge here with mates.

  28. Bernardo said

    Hi friends, fastidious piece of writing and fastidious
    urging commented at this place, I am really enjoying by these.

  29. 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.

  30. 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.

  31. 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

  32. lose weight fast

    SQL Server 2008 – Szybkie tworzenie polis « Jasne i ciemne strony baz danych

  33. I could nnot resist commenting. Very well written!

  34. What’s up, yeah this article is genuinely pleasant and I have learned lot of things from it about blogging.

  35. 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.

  36. 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.

  37. 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.

  38. 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!

  39. 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?

  40. 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

  41. 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?

  42. garcinia camboja

    SQL Server 2008 – Szybkie tworzenie polis « Jasne i ciemne strony baz danych

  43. 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.

  44. 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.

  45. 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.

  46. professional resume services san jose

    SQL Server 2008 – Szybkie tworzenie polis « Jasne i ciemne strony baz danych

  47. 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.

  48. 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

  49. 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


Wprowadź swoje dane lub kliknij jedną z tych ikon, aby się zalogować:

Logo WordPress.com

Komentujesz korzystając z konta WordPress.com. Wyloguj /  Zmień )

Zdjęcie na Google

Komentujesz korzystając z konta Google. Wyloguj /  Zmień )

Zdjęcie z Twittera

Komentujesz korzystając z konta Twitter. Wyloguj /  Zmień )

Zdjęcie na Facebooku

Komentujesz korzystając z konta Facebook. Wyloguj /  Zmień )

Połączenie z %s

%d blogerów lubi to: