I have earned the socratic badged, I formally received a message this morning about this, however, after I clicked track next badge I expected to see it showing on my profile, but it hasn't.
This is the only proof I got, when I try to add it for tracking it says that I already have it.
No, It d...
Friday was a lovely Spring day. I think this is my favourite time of year - not too cold, not too hot, and lots of things growing/flowering. Maybe I should write a poem :)
It's difficult to tell precisely without a sample result set, but I would imagine its your utilization of natural JOINs which is typically bad practice. Reasons being:
I would avoid using natural joins, because natural joins are:
Not standard SQL.
Not informative. You aren't specifying what co...
@dezso I've been thinking about that too, not necessarily related to the site
I think it basically boils down to attitude/curiousity
you have 2 types of people, people trying to learn how things work, and people trying to learn how to do things
The people that learned how things work end up figuring out how to do things by themselves, the people that learn how to do things end up needing constant training and having a never ending stream of questions whenever a minor detail differs from how they did the same thing before
The question reminded of a related question in this site that I have been meaning to answer, but needs a lot of time and keep forgetting it on weekends.
If user input is inserted without modification into an SQL query, then the application becomes vulnerable to SQL injection, like in the following example:
$unsafe_variable = $_POST['user_input'];
mysql_query("INSERT INTO `table` (`column`) VALUES ('$unsafe_variable')");
That's because the us...
This happened after the database automatically restarted. Is it normal for the database to automatically restart itself? The error message also says "Unknown/unsupported storage engine", I was looking for knowledge, not speculation. — vladkornea38 mins ago
"I was looking for knowledge, not speculation" -- how to annoy Phil
@ypercubeᵀᴹ I was once told that an Aussie doesn't like you if they call you "mate". If they call you a "c**t" they DO like you :) Don't know if there's any truth in it
The database-administration and dba tags are used on 1039 and 148 questions respectively.
They seem useless to me (on a site called Database Administrators) but I am curious as to how others feel.
Should we burninate (delete) these tags?
It would leave 15 unclosed questions tagless, but we cou...
We currently have 2 DBA’s, me and one other guy and we both feel the need for an additional resource (or two). I have had the conversation with my direct manager on this topic a couple different times, but am having difficulty in getting the notion sold. Most recently our manager shared with us t...
@AndriyM You're right about the synonym thing. That's where I started - thinking about making dba a synonym - but then I wondered why we have them at all, and what sort of question couldn't be tagged with one or both.
@TomV If questions about human resources are on-topic then perhaps we do?
I've been a MySQL DBA for the past 6.5 years. I've also spent some 16 years as a developer and have interacted with many DBAs. Many of them pragmatic. Some of them obnoxious. A few have no idea what it means to be a DBA.
I have come to this conclusion:
Technically speaking, DBAs who have one or...
I know a lot of Database Administrators and they are all over 28-29 years old.
Is all database administration like that? I mean, is this about getting experience more than at least 7-8 years?
Or is being a database administrator so hard?
Anyway, I don't feel much in favor of the dba tag either, and if the metrics question is the only one preventing it maybe the question should be if that one is off-topic like the 2 other ones
It kind of falls between what is on topic according to the help center but could lean close to "career advice" maybe
Looking through it seems most questions about DBAs (the people) and their duties etc. have been considered off-topic.
@TomV But this is all slightly a different question. If nothing else, we could tag the tom-answered question that started all this with [sql-server] for the time being until we come to some sort of consensus.
There is a blacklist; it's most often used for tags (like intrinsic tags, so Programming can't exist on Stack Overflow) or to temporarily block posts with a certain (spam) URL. It's developer-only, but moderators can (and do) ask a dev/the community team to block a URL/text. As a normal user I'd ...
The database-administration and dba tags are used on 1039 and 148 questions respectively.
They seem useless to me (on a site called Database Administrators) but I am curious as to how others feel.
Should we burninate (delete) these tags?
It would leave 15 unclosed questions tagless, but we cou...
Am Successfully configured the Always On with different sub nets. but I have one small glitch here every time am manually flushed out the DNS (command prompt ipconfig /flushdns) while fail over is occurred.
Please do the needful.
We don't do a lot of socialization on Stack Overflow, or even Meta Stack Overflow. In fact, we really don't do any socializing. But, that doesn't mean being social and having informal conversations is bad in any way, we'd just rather that folks do it somewhere else.
Somewhere else turns out to ...
@ypercubeᵀᴹ I think you've missed the purpose. The table fields are not relevant to the question. Those are in fact not even fields on the table it was just a few things i threw in there to visually show we have 2 tables. Sorry if that was confusing. The question is simply should we create a new table for Company or add the fields directly on each of the tables. — ozz44 secs ago
I am asking on behalf of my friend.
My friend doesn't have a gender (in other words they are gender-neutral) and on their new passport their gender is represented as X (indeterminate/unspecified). Previously booking a flight wasn't an issue because their previous passports stated they were a wom...
I thought at first to let it be, but ultimately I don't understand what they are trying to do. Both tables need to have a Company attached to them – what does that mean? Will one row from one table and one from the other need to reference the same company?
I've voted to close as "unclear" too
They may well be satisfied with the answer they've got but the question doesn't seem useful to me.
@TomV Unfortunately the situation in that question & answer has gotten a bit untidy, but I will work on clarifying the business requirements (with the help of the OP, of course) and will condense both the question and the answer once we get the requirements more clearly defined. Of course, other points of view can help to provide a better answer :)
@TomV Thank you. And yes, I totally agree, a (relational) database structure should feel natural, that's a very important point. If things feel forced, it's a common sign that something's not coherent, consistent or does not reflect the real world situation accurately. But, yes, that's my personal point of view as well.
"Do the needful" is an expression which means "do that which is needed", with the respectful implication that the other party is trusted to understand what needs doing without being given detailed instruction. The phrase is common in Indian English as well as in many African countries such as Kenya where it is commonly found in formal business correspondence. There has been recent interest in the phrase especially in the context of globalized Call Centers.
The expression is currently used mainly in Indian English, although some parody references in English literature exist imitating South Asian...