May 12, 2016 at 3:56 am
Is there a way this can be prevented?
May 12, 2016 at 5:37 am
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
May 12, 2016 at 5:50 am
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
May 12, 2016 at 1:17 pm
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.
May 12, 2016 at 1:34 pm
It has cut down some but still a pain.
May 12, 2016 at 2:02 pm
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/
May 12, 2016 at 2:22 pm
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
May 12, 2016 at 2:30 pm
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:
May 12, 2016 at 2:34 pm
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
May 12, 2016 at 2:37 pm
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/
May 12, 2016 at 2:45 pm
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
May 12, 2016 at 2:50 pm
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/
May 12, 2016 at 3:14 pm
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
May 13, 2016 at 7:00 am
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.
May 13, 2016 at 7:02 am
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