Sad to see spamming being flooded in this forum.

  • Is there a way this can be prevented?

  • Hi,

    for me as a human user, it would be OK to type a captcha to post something.

    Or, only confirmed accounts can post something. I think, it should be possible to avoid this kind of spam.

    Kind regards,

    Andreas

  • kreuzer (5/12/2016)


    Hi,

    for me as a human user, it would be OK to type a captcha to post something.

    Or, only confirmed accounts can post something. I think, it should be possible to avoid this kind of spam.

    Kind regards,

    Andreas

    agreed; even a "i am not a bot " checkbox would probably instantly address a huge portion of the spam we are buried under.

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • Yea, very strange. I'm curious as to why it's an issue suddenly now?

    Automatic suppression of posts reported as spam by a certain threshold number of users might help mitigate the issue until the root problem can be addressed.

  • It has cut down some but still a pain.

  • sestell1 (5/12/2016)


    Yea, very strange. I'm curious as to why it's an issue suddenly now?

    Automatic suppression of posts reported as spam by a certain threshold number of users might help mitigate the issue until the root problem can be addressed.

    It has been a pretty big problem for at least 6 months. There has always been some amount, as I am sure most forums have to deal with. But here it has been rampant to the point that I really find this site painful quite frequently. I have had far more luck lately finding spam postings than I have finding people who actually need help. Quite sad really. Probably the best atmosphere and knowledge base for sql server being destroyed by something that could be prevented.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • There are certain keywords like "testosterone", "distressed furniture", and "butt cream" that seem to be a recurring theme for the spammers, but are highly unlikely to naturally occur in a legitimate forum discussion. Perhaps there is an analytical method to automatically flag and suppress these things.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • Eric M Russell (5/12/2016)


    There are certain keywords like "testosterone", "distressed furniture", and "butt cream" that seem to be a recurring theme for the spammers, but are highly unlikely to naturally occur in a legitimate forum discussion. Perhaps there is an analytical method to automatically flag and suppress these things.

    You don't have any tables named "butt cream" in your databases? :Wow::Whistling:

  • Eric M Russell (5/12/2016)


    There are certain keywords like "testosterone", "distressed furniture", and "butt cream" that seem to be a recurring theme for the spammers, but are highly unlikely to naturally occur in a legitimate forum discussion. Perhaps there is an analytical method to automatically flag and suppress these things.

    And "live feed" to various sporting events also seems to be very popular.

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

  • Sean Lange (5/12/2016)


    sestell1 (5/12/2016)


    Yea, very strange. I'm curious as to why it's an issue suddenly now?

    Automatic suppression of posts reported as spam by a certain threshold number of users might help mitigate the issue until the root problem can be addressed.

    It has been a pretty big problem for at least 6 months. There has always been some amount, as I am sure most forums have to deal with. But here it has been rampant to the point that I really find this site painful quite frequently. I have had far more luck lately finding spam postings than I have finding people who actually need help. Quite sad really. Probably the best atmosphere and knowledge base for sql server being destroyed by something that could be prevented.

    Don't forget "kitchen cabinets" and "live streaming". I always laugh at the live streaming of football (err soccer) games. Here in the states we get all of them with just a couple of cable/satellite packages.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • sestell1 (5/12/2016)


    Eric M Russell (5/12/2016)


    There are certain keywords like "testosterone", "distressed furniture", and "butt cream" that seem to be a recurring theme for the spammers, but are highly unlikely to naturally occur in a legitimate forum discussion. Perhaps there is an analytical method to automatically flag and suppress these things.

    You don't have any tables named "butt cream" in your databases? :Wow::Whistling:

    I've got a trigger named "ButtCream".

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • Eric M Russell (5/12/2016)


    sestell1 (5/12/2016)


    Eric M Russell (5/12/2016)


    There are certain keywords like "testosterone", "distressed furniture", and "butt cream" that seem to be a recurring theme for the spammers, but are highly unlikely to naturally occur in a legitimate forum discussion. Perhaps there is an analytical method to automatically flag and suppress these things.

    You don't have any tables named "butt cream" in your databases? :Wow::Whistling:

    I've got a trigger named "ButtCream".

    A butt cream hair trigger?!?!?!? EEEWWWWW!!!!!!!! :w00t:

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • Sean Lange (5/12/2016)


    sestell1 (5/12/2016)


    Yea, very strange. I'm curious as to why it's an issue suddenly now?

    Automatic suppression of posts reported as spam by a certain threshold number of users might help mitigate the issue until the root problem can be addressed.

    It has been a pretty big problem for at least 6 months. There has always been some amount, as I am sure most forums have to deal with. But here it has been rampant to the point that I really find this site painful quite frequently. I have had far more luck lately finding spam postings than I have finding people who actually need help. Quite sad really. Probably the best atmosphere and knowledge base for sql server being destroyed by something that could be prevented.

    I very much appreciate that this site is "a community service from REDGATE" (top right in the header for those that have missed it).

    The site has an extraordinary amount of content, posts , threads etc that are invaluable to me, and I expect many other people.

    Sadly though, I think that the sponsors have demonstrated little desire to improve it over recent years...either in layout / functionality or addressing some its shortcomings (eg spam).

    I know that to make such changes incurs further significant costs over and above the ongoing provision of the site (anyone got an idea what it costs to support this site???)

    ...so maybe its a "business decision" to not invest any further.

    There have been several threads on suggested improvements...but I am not sure that any have been acted upon.

    So, for the time being, until some better and greater site appears from a competitior, then I will put up with the spam etc.

    Or to put it another way.. Redgate pull the plug on the site...whatcha going to do now?

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • Hmm, maybe they could utilize the point system for this.

    Add up the point total of everyone who reports a posting. If the point total is greater than some threshold, the posting would be marked as abusive and hidden by default.

    That way people who have contributed more would have more weight in declaring a post abusive.

  • J Livingston SQL (5/12/2016)


    Sean Lange (5/12/2016)


    sestell1 (5/12/2016)


    Yea, very strange. I'm curious as to why it's an issue suddenly now?

    Automatic suppression of posts reported as spam by a certain threshold number of users might help mitigate the issue until the root problem can be addressed.

    It has been a pretty big problem for at least 6 months. There has always been some amount, as I am sure most forums have to deal with. But here it has been rampant to the point that I really find this site painful quite frequently. I have had far more luck lately finding spam postings than I have finding people who actually need help. Quite sad really. Probably the best atmosphere and knowledge base for sql server being destroyed by something that could be prevented.

    I very much appreciate that this site is "a community service from REDGATE" (top right in the header for those that have missed it).

    The site has an extraordinary amount of content, posts , threads etc that are invaluable to me, and I expect many other people.

    Sadly though, I think that the sponsors have demonstrated little desire to improve it over recent years...either in layout / functionality or addressing some its shortcomings (eg spam).

    I know that to make such changes incurs further significant costs over and above the ongoing provision of the site (anyone got an idea what it costs to support this site???)

    ...so maybe its a "business decision" to not invest any further.

    There have been several threads on suggested improvements...but I am not sure that any have been acted upon.

    So, for the time being, until some better and greater site appears from a competitior, then I will put up with the spam etc.

    Or to put it another way.. Redgate pull the plug on the site...whatcha going to do now?

    Agreed. This is by far my go to source for all things sql server. And of course from Redgate the challenge is that this site doesn't make any money, in fact it probably costs them. I just wish there was a reasonably easy way to deal with the massive amounts of spam. The admin team does seem to do a good job of deleting posts once they are reported.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Viewing 15 posts - 1 through 15 (of 22 total)

You must be logged in to reply to this topic. Login to reply