14

It's almost February in 2018, which isn't supposed to be the proper time to cycle these, but for this year it'll be once again, so we'll be refreshing the Community Promotion Ads for this year now!

What are Community Promotion Ads?

Community Promotion Ads are community-vetted advertisements that will show up on the main site, in the right sidebar. The purpose of this question is the vetting process. Images of the advertisements are provided, and community voting will enable the advertisements to be shown.

Why do we have Community Promotion Ads?

This is a method for the community to control what gets promoted to visitors on the site. For example, you might promote the following things:

  • the site's twitter account
  • cool events or conferences
  • anything else your community would genuinely be interested in

The goal is for future visitors to find out about the stuff your community deems important. This also serves as a way to promote information and resources that are relevant to your own community's interests, both for those already in the community and those yet to join.

Why do we reset the ads every year?

Some services will maintain usefulness over the years, while other things will wane to allow for new faces to show up. Resetting the ads every year helps accommodate this, and allows old ads that have served their purpose to be cycled out for fresher ads for newer things. This helps keep the material in the ads relevant to not just the subject matter of the community, but to the current status of the community. We reset the ads once a year, every December.

The community promotion ads have no restrictions against reposting an ad from a previous cycle. If a particular service or ad is very valuable to the community and will continue to be so, it is a good idea to repost it. It may be helpful to give it a new face in the process, so as to prevent the imagery of the ad from getting stale after a year of exposure.

How does it work?

The answers you post to this question must conform to the following rules, or they will be ignored.

  1. All answers should be in the exact form of:

    [![Tagline to show on mouseover][1]][2]
    
       [1]: http://image-url
       [2]: http://clickthrough-url 
    

    Please do not add anything else to the body of the post. If you want to discuss something, do it in the comments.

  2. The question must always be tagged with the magic tag. In addition to enabling the functionality of the advertisements, this tag also pre-fills the answer form with the above required form.

Image requirements

  • The image that you create must be 300 x 250 pixels, or double that if high DPI.
  • Must be hosted through our standard image uploader (imgur)
  • Must be GIF or PNG
  • No animated GIFs
  • Absolute limit on file size of 150 KB
  • If the background of the image is white or partially white, there must be a 1px border (2px if high DPI) surrounding it.

Score Threshold

There is a minimum score threshold an answer must meet (currently 6) before it will be shown on the main site.

You can check out the ads that have met the threshold with basic click stats here.

5
  • 4
    Hi Grace. In your example above, for the image title you have "Tagline to show on mouseover". I have not seen that any of the ads on this page show this title on mouseover. It would be possible to get something to appear when doing a mouseover by specifying tooltip text, which goes after the image URL (e.g. [1]: http://image-url (ToolTip text) ). Is this something that we can do without invalidating our submission? You are very clear that we are to use the provided format and not deviate from it, so I have been assuming that adding this is a deviation. Am I right or can we add a Tool Tip? Commented Feb 14, 2018 at 20:14
  • 1
    @SolomonRutzky Within this thread, the text there is only shown as title text, which isn't mouseover text. However, to my knowledge, when the ad is served on the main site's sidebar proper, it should show up as proper mouseover text. I can't actually confirm this now myself because no ads seem to want to load at all for me, but I'll have someone look into it if they're not showing up for some reason.
    – Grace Note StaffMod
    Commented Feb 27, 2018 at 12:50
  • 3
    It's been confirmed that the mouseover does work properly on the actual ads served - i.sstatic.net/WsMUS.png
    – Grace Note StaffMod
    Commented Feb 27, 2018 at 14:03
  • Grace: awesome! Thank you very much for confirming that 🤛 🐱 🐲 🍣... Commented Feb 27, 2018 at 21:37
  • @GraceNote thank you. I've just confirmed it, too, and I as coming to inform all but you had beat me to it ;) Commented Feb 28, 2018 at 13:42

7 Answers 7

30

Instance migrations and best practice implementations have never been safer, faster or freer.

24

Designed to complement DBA.SE, by enabling contributors to share editable database scripts and examples

22

Plan Explorer - Unrivaled execution plan analysis. Now completely free!

14

Follow us on Twitter!

2
  • This is a demonstration post to indicate how this should look when an ad is posted. It also doubles as your twitter ad, but it's up to you if you wish to promote it by voting
    – Grace Note StaffMod
    Commented Jan 29, 2018 at 6:16
  • I downvoted. Largely because the twitter functionality of Stack Exchange is horrible from any aspect. If you really want to keep up with SE, use the RSS functionality. Which is actually pretty decent and much better at this. That said, it's a good example. I just don't want to push that service. Commented Feb 26, 2018 at 21:11
13

The world's most advanced open source database.

0
9

Head over to Aireforge to learn more

8

Over 180 free SQLCLR functions and stored procedures that improve and extend what you can do in T-SQL

6
  • 1
    I thought it was a tick-tack-toe game implemented in SQL! Commented Feb 14, 2018 at 19:21
  • @ypercubeᵀᴹ It probably doesn't help that the tooltip containing the tagline doesn't seem to be working (at least not for me on any of the ones posted on this page). So, maybe not tic-tac-toe, but 3 in a row = you win (which is the overall goal of SQL# :-) Commented Feb 14, 2018 at 19:44
  • I've added a tooltip. Edit as you want! Commented Feb 14, 2018 at 20:01
  • @ypercubeᵀᴹ Thanks. I considered doing that but refrained due to the statements in the question regarding "All answers should be in the exact form of" and "Please do not add anything else to the body of the post". How about I remove it for now and post a comment on the question asking if we can do that. The other reason I was hesitant to try it was that the question seems to imply that the "title" of the image mark-down is what will be used for the "mouseover", which I took to mean the tooltip, but there could be another usage within their ad rotation system. I will ask / confirm. Commented Feb 14, 2018 at 20:08
  • I saw how to do it here: meta.stackoverflow.com/questions/318932/… I suppose the method to add images with kinks/tooltips was changed at some point but the community promotion usage text was not updated. But sure, go ahead and ask the mods! Commented Feb 14, 2018 at 20:13
  • @ypercubeᵀᴹ I don't think you are wrong, I just prefer to know that you are correct :-). I've been caught before doing things that made perfect sense only to be reprimanded that, as rational as it appeared to be, it was still a violation of stated rules. So, I will let the rule-maker(s) render an official ruling on it: dba.meta.stackexchange.com/questions/2901/… Commented Feb 14, 2018 at 20:20

Not the answer you're looking for? Browse other questions tagged .