27

Personally, I think this is dangerous to allow. Licensing is a vast landscape and there are mines everywhere. Being out of compliance is something that can get you and your company into serious hot water. Pulling up some Stack Exchange answer in the middle of an audit with Microsoft Legal is not going to get you off the hook. Ask yourself this: Do you want ...


22

These types of questions are harmful to the site and should be quickly closed and probably deleted. I know that SO has a no-shopping-list questions policy, and this feels like a shopping-list. It's not just SO, this has been established network wide for a long time. Just two meta.SE examples: List questions: Community Wiki? What is the definition of a ...


21

Ask a new (follow-up) question, including a link to the previous one if it provides useful context. The new question should still make sense on its own, of course. As a general rule, it is better to start a new question when a question edit would invalidate good answers. We don't charge by the question (but please don't go nuts - a hundred similar, very ...


20

I agree with Leigh's suggestions (see comments on the question): Remove wording from the site indicating that basic SQL is not allowed. I'm not sure if I would promote it, simply not ban it. Stop migrating basic SQL questions to Stack Overflow.


19

No, because... We have a niche, an 'expert' focus and we don't want to dilute it too much. Being flexible with the definition of 'advanced' SQL which we allow according to the help page is fine, but opening the floodgates to every 'how do I join two tables' question will eventually lead to the overall quality and perception of the site degrading. Or, as ...


19

Yes, SQL Challenges should be considered on topic because... they provide the community with new approaches to existing problems. they show the more exotic forms of SQL, and are an invaluable way to hone your craft. they are popular and may attract new expert users to the site We love fun


16

Some of the license questions and answers we have on the site are useful and I think DBA.SE is making the internet a better place by hosting them - I wouldn't like them to be banned altogether here like on SF because we don't have the same reason: they have unlimited scope as they cover thousands of software packages and license agreements. I do think we ...


16

People have asked data modelling questions on dba.se before, so it's not off-topic for the site. If you have a question that's specific enough to fit the question/answer format then it's going to be considered on-topic. Note: 'please design my database for me' is not. You will need to get to a problem that's specific enough that somebody can answer the ...


15

database-recommendation questions are not off-topic, but experience has shown that they need to be better than average to avoid being ignored or closed, especially in recent times. Click on that tag to see existing questions. Be specific about the circumstances, requirements, and constraints you face up front. For example, you should say whether the ...


12

I don't see any problem with posting it as a question at the site. We love complex issues! Depending on how sure you are about your analysis results: if you are not very sure about your findings: one question with two parts (within the question): the problem and your analysis/results. Others can answer if there are any flaws with your analysis and ...


12

It would be very rare for this sort of question to be accepted by the community here. The potential problems are many, but include: Answers tend to go out of date more quickly than for other types of question Answers are often based on personal preferences The questions are too often lacking enough detail, resulting in extended discussion These types of ...


12

I edited and upvoted your question because I found it on-topic and interesting. That said, other members of the community had already voted to close it, and left it closed after an automatic reopen review triggered by one of your edits. Also, experience has shown that database recommendation questions have to be pretty exceptional to remain open here. On ...


11

Personally, I don't think this type of question is a good fit for our site for several reasons. Bigger/more hardware will almost always lead to better performance. As such the answer "As much as your budget will allow" is always a valid answer. Too many implicit assumptions. You can't possibly fully describe all the details of your system to us so we are ...


10

The "on hold" notice placed on your question included a link to the Help Centre, which I repeated in a comment on your question here. To quote: Questions that need additional work or that are not a good fit for this site may be put on hold by experienced community members. While questions are on hold, they cannot be answered, but can be edited to make ...


10

This has been somewhat discussed before: Are DBA certification questions appropriate? Can I ask conversational questions? (Training) I think the vast majority of questions about certification will be off-topic for one of the usual reasons, but that's not quite the same as saying that any question that mentions certification will be automatically off-...


10

This stack part is quite young (at least it seems that way to me) and I'm not sure if such question would be tolerable. No, this particular Stack Exchange site (that's what they're called) is quite mature, and we're well prepared to help people, so long as it fits in with our scope, and as to: I want to ask specific question - what database should I ...


10

I don't think "this vs that" is a good fit for anything that attempts to be canonical. Each DBMS will change over time, and as such, the answers will vary substantially over time. These types of questions are just troll fodder, in my opinion.


10

Neither. SQL Challanges (as described in the question) are neither automatically on-topic, nor off-topic. Each question should be evaluated on its merits by the community. I would expect questions of this type to be well-received, if they: Fit in Q & A format Are clearly presented and explained Contain sufficient information to identify correct answers ...


10

No, why a query is "too slow", compared to a different rewriting of the query, does not sound like a "too basic" question. There may be various reasons for the performance difference, from the two being inequivalent (so the efficiency comparison is likely pointless) to being able to utilise different indexes or due to optimizer's restrictions or missing ...


9

'How do I improve this schema?' is likely to be too broad and subjective to make a really good question. If you have specific issues then you can certainly ask questions about those. In general, 'I don't know where to start' is not acceptable on SE sites, as you are expected to have at least done some research on your own. In fact, this issue was so ...


9

I agree with @ConcernedOfTunbridgeWells, data modeling (or data architecture) questions are definitely on-topic and appropriate in DBA.SE, and they are usually encompassed within the database-design tag. On the other hand, (a) due to the fact that you categorized the present question with the discussion tag, (b) making the assumption that you have the ...


8

Questions about how to circumvent licensing restrictions are off-topic, for obvious legal reasons. However, you're welcome to ask for database recommendations,just make sure your question is clearly defined.


8

"Here's my problem. Here's what I've tried. Here's why it's still a problem." This pattern will get you a lot more useful responses than "can you suggest a better design?"


8

No, SQL Challenges should be considered off topic because... they belong on Programming Puzzles & Code Golf (PPCG) (but please read their help center before posting there) our Q & A is not set up to handle this type of activity well PPCG has code snippets (to generate a leaderboard) and a sandbox etc. they're not practical, answerable questions ...


7

Couchbase is a Document-Oriented NoSQL Database according to the title of their home page: that puts it on-topic, though of course the NoSQL market is more fragmented and more cutting-edge, meaning each DB has it's own niche and the pool of Q&A here may never be big. It does seem to be related from a technology perspective to CouchDB, though not so ...


7

No, but continue to allow moderator/community discretion for questions that don't quite fit, but produce sufficiently interesting answers. Worth noting is that neither question you have linked is closed. A question that starts "What are different ways to…" is a red flag for other reasons, whether it is on-topic or not, which just goes to show that the ...


7

While elasticsearch is not off-topic here, there aren't a lot of questions being asked. As such you may wait quite a while before getting a great answer. Having said that, feel free to fire away! The link above shows questions tagged on our main site with the elasticsearch tag.


6

I think a question tagged with certification only will serve no purpose. It will be much too generic to be of value to readers. "Oh, I came here to learn about DB2 certification, why is there all this Hadoop stuff mixed in my certification tag?" Using Microsoft exam criteria, some of the questions might even violate the NDA test takers agree to. ...


6

Summary Good questions that will benefit from 'pro-level' review are on-topic here. If only a basic review is required, migrate to Code Review if it is on-topic there. Do not migrate crap questions to any SE site, ever. The question of "real or hypothetical" objects does not affect topicality here. Very basic questions are generally off-topic here,...


5

In my experience, many seemingly expert programmers struggle to understand set theory and how to use SQL to generate the sets of data they need. DBA should be a place where this theory and practice can be learned by (good) example.


Only top voted, non community-wiki answers of a minimum length are eligible