Are the posted questions getting worse?
-
Security is fun, isn't it (not)
- Steve Jones - SSC Editor wrote:Phil Parkin wrote:
Out of interest, are the spammers (and their bots) using the standard GUI to create these posts, or is there a back door that they've hacked into?
No backdoor. They're using WGET/CURL quite a bit. We've blcoked those.
This isn't a hole, it's how the Internet works. Your browser does a GET, renders data, and when you click post/submit/etc, you send an HTTP POST (or PATCH) to the server. That HTTP POST can be automated (as can GETs) with various tools.
We've added some things looking for CLI tools as opposed to browsers, but potentially those can be spoofed. We're looking at other things
Thanks, Steve
That implies that they need a valid username to do the submit. Which brings us back round to whether it's possible to validate people with <n posts differently from others? Max one post per hour until 50 posts, perhaps?
-
Certainly we're looking at other things. The incident is still open, though not a P1/Sev1 right now. My boss' boss is still pressuring the IT Director and staff to continue to work on this and find better ways to limit things.
I've also been barraged with SPAM submissions in a similar way, so throttles are something I'd like as well. If you want to send a few complaints/concerns and express yourselves, marketing @ red-gate is good one to hit.
-
Hey I know we mostly just talk about SQL stuff here but I thought I would ask a job oriented question. Does anyone know anyone that could use a good quality SQL Developer for fairly low cost. I am semi-retired but would like to still help out others using my skills. I have developed with MS SQL, Oracle, MySQL, SQLite, MS Access and even MS Excel and could easily jump into just about any database software out there. However, getting this across to the folks that could possible use me is rather problematic with the AIs that most HR use. Also a deer kissed my car and so I am looking for remote work as I have no transportation at this time.
If you know of anyone feel free to give them my email address -- djensen765 at gmail
Thanks in advance either way.
- Dennis Jensen wrote:
Hey I know we mostly just talk about SQL stuff here but I thought I would ask a job oriented question. Does anyone know anyone that could use a good quality SQL Developer for fairly low cost. I am semi-retired but would like to still help out others using my skills. I have developed with MS SQL, Oracle, MySQL, SQLite, MS Access and even MS Excel and could easily jump into just about any database software out there. However, getting this across to the folks that could possible use me is rather problematic with the AIs that most HR use. Also a deer kissed my car and so I am looking for remote work as I have no transportation at this time.
If you know of anyone feel free to give them my email address -- djensen765 at gmail
Thanks in advance either way.
I don't know if any of the product teams at Allstate are looking, but check out Allstate dot com slash careers. We do fully remote work for most positions.
-
Sooooo... Last post I got this error when I hit Submit.
"Error: Slow down; you move too fast."
Then it bounced me to the start of the thread instead of the last page.
I thought maybe I hit Submit twice by accident, so I typed up another post to comment on it, only hit Submit once, and got the same error. Apparently we have some spam prevention going on that is preventing fast typers from posting too many times as well.
Now that I see it, I know to watch for it and take a few minutes between each post.
Steve, what is the timeout on this? Apparently "a few minutes" isn't good enough because it still bounced me on my second attempt to post this reply.
-
not sure if it is global, but spammers posts are having a delay of around 7 minutes.
I would expect IT to review how to implement this and potentially allow this delay to be bypassed/reduced for long time members / high(ish) activity posters.
- Brandie Tarvin wrote:
What is it with people claiming they are an 8 out of 10 on SQL Server, or in one case a 10 out of 10 on Oracle, and then not knowing how recovery models work with specific restore scenarios, how AG data movement works, or how to get the date and time from the server?
I mean, seriously. If you claim 10/10, you'd best have invented the platform and know things that no person interviewing you understands about the platform, right?
...
Lots of people claim to be the GOAT in things, which is like 10/10.
I never think I'm there, even in things I'm very, very good at. I would tend to think 8/10 for me.
- Brandie Tarvin wrote:
Sooooo... Last post I got this error when I hit Submit.
"Error: Slow down; you move too fast."
Then it bounced me to the start of the thread instead of the last page.
I thought maybe I hit Submit twice by accident, so I typed up another post to comment on it, only hit Submit once, and got the same error. Apparently we have some spam prevention going on that is preventing fast typers from posting too many times as well.
Now that I see it, I know to watch for it and take a few minutes between each post.
Steve, what is the timeout on this? Apparently "a few minutes" isn't good enough because it still bounced me on my second attempt to post this reply.
No idea on timeout. I'm not sure there is on. It's posting and everything is a separate post. There might be some check to prevent dups, but noidea on what time has to pass
-
Well, it's happening to me...
I'm starting to use AI. Granted, I used it to trim a resume down to 2 pages to fit the requirements of an online application system, but still, me, the "I still think we're going to end up with a cross between SKYNET and Talkie Toaster with this AI stuff." LoL
But at least it save me the aggravation of trying to modify the resume, although I still need to do a cross-check against the longer one to make sure the high-points are there.
-
AI does a lot of things, especially targeted, easily explained things, well.
The more you use it, the more you realize how hard it is to communicate sometimes. If nothing else, spending time with an LLM will help you better work with junior people over time.
-
AI has lied to me quite often about SQL Server things because it scrapes the internet and picks up the bad answers as well as the good. I've actually had arguments in the workplace because my coworkers "answered" my questions by using AI and I have to sit and explain to them each and every line of the AI answer and why it's wrong.
And I'm talking specific things like tempdb and temp tables and AG functionality that is hard to get wrong if you know your stuff. But easy to get wrong if you're an accidental DBA who doesn't need / care to do the learning about the stuff.
-
Brandie, I've found this to be true quote often. AI can do some things well, but it acts like a "consensus engine" on many things, leading to answers that are just flat-out wrong. Other things are okay, but not ideal, because that's what the majority of people do.
I had an especially problematic procedure with 6 loops up to 3 levels deep. It was horrible to even look at the code and wouldn't complete a run in 2 hours. It took Claude paid to actually try to convert it to set-based...and it did it! It was wrong, but it did the conversion.
I ran it and it hit an error in 30 minutes, which is much better than the original. Well, I spent that 30 minutes fixing what I thought Claude got wrong. My version took only 8 seconds to hit the same error. After I dealt with a total of 4 errors, the whole thing runs in 4 seconds. There were no NCIs or other DDL - just the code.
I think the bottom line is that while AI is good at some things, we're still needed. I get the same feedback from the front-end developers. It's a great productivity tool, but you still need someone who knows what they're doing to use it effectively.
-
I'm on a pretty steep learning curve with a new technology at the moment and AI is probably hindering as much as helping. The problem is, I don't know what I don't know so if AI tells me something, it can take me a while before I realise that it's bollocks and I'm doing things wrong. When it works first time, I'm suspicious that it's actually wrong and will cause problems later. What it is certainly useful for is menial tasks like "put this lengthy list into this format" and "create a something n times," the kind of time-consuming stuff that it can't get too badly wrong.
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a PhilosopherHow to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
-
Just a heads up for Steve Jones, the links to comment on the editorial from today "Would You Retire Rather Than" aren't working.
And I was all set to comment. 🙂
Viewing 15 posts - 66,886 through 66,900 (of 66,905 total)
You must be logged in to reply to this topic. Login to reply