Master Database

 The Heap™ – Consultancy ©®

General on- and off-site discussion for dba.stackexchange.com....
Jul 6 22:48
0
Q: Tob be a bot or not to be a bot

MBEVery interesting. I have complained about checked not being a bot. This site is using bots. Does it accur to anyone, that this may be offensive? Ok, maybe it occurs to the human contributors, that they are exploited. This post will be deleted.

Jul 2 22:21
0
Q: Recommendation Letter from DBA StackExchange

Aleksey VitskoDon't know if this forum is the best place to ask, but right now I can't think of any other. Currently I am in United States and working as a database administrator. I have family members here, who are citizens. Of course I would like to stay in the United States for much longer period, because o...

May 30 12:11
0
Q: Table not rendered after saving

Sergey ZolotarevTable rendering looks differently before and after saving a question. Before: After: Looks like a bug.

Apr 12 17:59
1
Q: Why was our main site read only overnight?

Aaron BertrandOn April 10th, 2025, from roughly 00:49:30 UTC until 11:10:15 UTC, Database Administrators was in read-only mode. What happened? Was this due to the migration to GCP?

Feb 7 01:51
0
Q: Aaron Bertrand vanished?

Erwin BrandstetterNot to infringe on anybody's privacy, but it's hard to overlook this glaring void. Aaron Bertrand has been prominently visible across the site as one of the leading SQL-Server experts. Recently, it was even publicly stated that he did work for SO in this role. But today, when I looked at the user...

Jan 15 16:40
0
Q: 2024: a year in moderation

JNat It’s that time of the year again! As we bid farewell to the year that's concluded and welcome the new one, we have a tradition of sharing moderation stats for the preceding calendar year. As most of you here might be aware, sites on the Stack Exchange network are moderated somewhat differently t...

Jan 10 12:38
0
Q: Should I ask a question about "how" DAX works in here, or over at Stack-Overflow?

jonnybolton16I'm currently learning DAX, and I have an issue regarding the syntax of a function being applied on a filtered table. I think the root question/answer I'm looking at lies in how DAX works, and why that means the syntax that I am struggling with does indeed work. For context, I'm familiar with oth...

Jan 9 08:23
0
Q: When editing a post should one edit the title to a "proper" question?

A-TechI recently edited a post among some minor grammar/format issues and removing fluff I changed the title from Cannot do a backup of a read_only database to Why does the read_only mode fail my database backup? That title change appears to be the reason for the edits' rejection. Is that an unnece...

Jan 2 18:34
0
Q: Is t pssible to reopen automatcally closed questoin

IgorALL, I'm talking about this particular one - https://dba.stackexchange.com/questions/161869/cant-start-sybase-server TA!! P.S>: I solved it, but don't remember how as I don't have access to that system ATM. But when I will, I'd like to update it.....

Dec 30, 2024 15:13
0
Q: what to do when we find an answer that is not helpful for anyone?

Marcello MiorelliSometimes I find answers that are not helpful to anyone, but they stay there, hanging around, I would like to flag them for a moderator to delete them. I wonder as we have voting for closing questions, why we don't have a voting for deleting answers too. one of such answers is this one

Oct 18, 2024 12:00
0
Q: how to blur up sensitive information on questions or answers?

Marcello Miorellias it was just recently the case on this question of mine - I want to show the result of a query, but I cannot show server names and other specific properties that would potentially cause harm. however, I enjoy details and clarity, my question is: visually the way I did - blurring all with red on...

Aug 24, 2024 09:57
0
Q: Question with a clear error message and an easy fix that was closed as "too localized", likely "not relevant to most of our audience". Reopen or Move?

questionto42Could this question How do I avoid error "Request to run job refused because the job is already running" if no job is shown as "running" when I start a chosen step? be reopened or moved to: Server Fault SE (since it is about a server error while running an SQL Agent job) or Super User SE (since ...

Aug 6, 2024 11:40
0
Q: Revision is gone, likely just rejected, but how could it vanish without any trace?

questionto42I have changed Getting a "Request to run job refused because the job is already running" When no job is running? to Why do I get a "Request to run job refused because the job is already running" when no job is running? at Getting a "Request to run job refused because the job is already running"...

Jul 11, 2024 18:02
0
Q: Burninate [sa], [root], and [administrator]?

Peter VandivierShould we burninate (delete) these tags? Tag Questions Created On sa 5 May 6, 2021 root 15 May 21, 2020 administrator 4 March 13, 2024 Some considerations. None of these tags has any usage guidance All of the questions using these tags have other clarifying tags In every case, it a...

Jul 5, 2024 14:35
0
Q: Could this question be salvaged? If so, how?

Yano_of_QueenscastleThe question Are MSSQL window functions logically redundant? got closed, because it "needs more focus". Is the question completely unsalvageable (since this stack is about practical problems and the question seem more like idle intellectual exercise)? Or is there something OP could do to get it r...

Jun 12, 2024 15:27
0
Q: Is this an OK question for DBA SE site ? (related to Top mistakes developers make writing T-SQL that lead to performance problems)

Aleksey VitskoI would really like to ask a particular question on DBA SE, in order to collect some knowledge from experienced DBA/Perf.Tuning guys and this way have a good reference for my developers that I can share with (send them link to DBA SE question). Question is below, please review: Topic: Most common...

Jun 6, 2024 14:53
0
Q: Are questions about problems with DB in container on-topic?

PM 77-1I saw a question on SO and voted for its migration to DBA site, but now not sure if it was a right choice. [I'm not putting a link here to avoid meta-effect]. It boils down to Oracle errors when running Oracle container in Docker.

May 13, 2024 13:35
0
Q: Tag ordering - should the OP or the system decide?

VéraceI've just submitted a question and I put the tags that I had chosen in a particular order but looking at my question after posting, the system has changed the order of the tags. The system appears to have opted for listing the tags in order of the tag's popularity, whereas I originally listed the...

Apr 30, 2024 14:13
0
Q: Why my post about comparing date is off-topic?

Elikill582 weeks ago, I posted this question : Why is it selecting date from another month that requested one? Few minutes after, I received an answer that proposed a nice way to fix it. Last hour, this question have been closed because it seems "off-topic, too localized". (Note: The explaination refer to...

Apr 9, 2024 08:37
0
Q: Answer got deleted as not an answer even though I show in the tested code that the temp tables have their data only in one of three main methods

questionto42My answer got deleted, see DFT drops connection and its temporary table after leaving any DFT item, tested with two Script Components. How do I keep the temp table alive?. I gave the tested code, taking up the main hint of the other answer to release but not close the connection, but also showing...

Mar 21, 2024 19:56
0
Q: Google Cloud will be Sponsoring Database Administrators SE

SashaWe're excited to announce that Google Cloud will be sponsoring Database Administrators Stack Exchange April 2nd through June 30th, in the United States and Canada. We wanted to give you a heads-up and walk you through what it will look like. How and where will the sponsorship be displayed? For us...

Jan 24, 2024 19:23
0
Q: 2023: a year in moderation

JNat It’s that time of the year again! As we wave goodbye to last year and welcome the new one, we have a tradition of sharing moderation stats for the preceding calendar year. As most of you here might be aware, sites on the Stack Exchange network are moderated somewhat differently to other sites on...

Jan 15, 2024 11:37
0
Q: Add an answer box banner warning against generative AI?

Paul WhiteWe decided in Are ChatGPT answers allowed here? that generative AI answers are not allowed on our site. There is now an option to add a banner to the answer box informing people of this. The options are described in Sites can now request to enable a banner to warn about their policy on AI-generat...

4
Dec 3, 2023 14:29
0
Q: Learning Resource Needed: How do popular databases store their data on disk?

Bogdan FloareșI started a project about trying to create my own simple DBMS using C# and Java. I created a simple SQL-like language which I called RTQL(Rudimentary Testing Query Language). This "thing" has 3 components: The server: An .exe process made in C# that runs a TCPListener waiting for clients to conn...

Jul 2, 2023 08:27
-1
Q: GO FUCK YOURSELF f fuck stack exchange worst site ever! got my accounts banned for absolutely no reason

KEMONO_PANTSU_1003 I have a question about my Database Administrators Stack Exchange post: MariaDB - SQL Injection on insert GO FUCK YOURSELF f fuck stack exchange worst site ever! got my accounts banned for absolutely no reason

Jun 16, 2023 12:54
0
Q: questions tagged sql server 2005 but I have a better answer for sql server 2019

Marcello Miorellisometimes I see questions tagged sql 2005 but I things have changed and I find it a good opportunity to add my answer just it is done in a slightly different way as it is a new version. is it ok to post my scripts? this is an example.

Jun 6, 2023 20:42
0
Q: Ongoing Moderation Strike

Hannah VernonSince Monday, June 5th, 2023, moderators and content curators (that's you, dear reader) from across the Stack Exchange Network, including the moderation team on this site, have decided to protest recent statements taken by the Stack Overflow corporate team. The protest consists primarily of not r...

Jun 4, 2023 23:24
0
Q: Can I find out why this question was deleted?

NewSitesCan I find out why this question was deleted and whether there are changes that could allow it to be undeleted? I have found an answer and would like to post that. https://dba.stackexchange.com/questions/302471/why-does-access-recalculate-a-stored-query-when-i-copy-it-can-i-tell-it-not-to

May 14, 2023 16:14
0
Q: Is asking about a list of the rules determining effective permission in SQL Server within the scope of the site?

Mehdi CharifeWould the following question be within the scope of the site? I've been struggling to find a listing for the rules that determine the effective permissions of a user on a database object in SQL Server based on the GRANTs, REVOKEs, and DENYs, that are explicitely applied to the user or/and the ro...

May 3, 2023 16:18
0
Q: Middle Sidebar Advertising

RosieAs you all know, advertising is an important source of revenue for Stack Overflow and it helps us support all the sites across the Stack Exchange Network and the resources that go into maintaining and improving the experience on the platform. We are going to be introducing middle sidebar ads, whi...

Apr 28, 2023 12:38
0
Q: Why was the Spam flag declined when the user was blatantly recommending his software of the same name

Rohit GuptaWhat does a RED X on a database user mean? I can't see it anymore but I am sure that I had marked Esrim's reply as Spam because he/she was recommending software of the same name as his. I was obviously correct as the answer has been deleted.

Mar 27, 2023 11:52
0
Q: Why was a question about AWS RDS / Postgres permissions model closed?

Philip CoulingCan I get some feedback on how / why this one was off topic: What permissions are needed to prevent ERROR: permission denied for tablespace pg_global in RDS? It's not clear to me whether I've neglected to include some information that might otherwise make it on-topic, or somehow touched a nerve. ...

Mar 25, 2023 18:19
0
Q: Downvoter targeting questions so that they get removed by Roomba

Franck DernoncourtA downvoter has been targeting questions so that they get removed by Roomba. I don't know whether only my questions are targeted. Examples: History of the provisioned write capacity in DynamoDB beyond the last two weeks Column order in a DynamoDB table browsed through RazorSQL Maxing out the sha...

Feb 5, 2023 13:50
0
Q: What is the appropriate tag to use for "database"?

vfclistsI just asked a question What columns are needed to list the database, schema and table a record comes from? which asks about which database row comes from in a cross database/schema question and couldn't use database as a tag. What is the appropriate term for that?

Jan 31, 2023 11:03
0
Q: ChatGPT answers?

Ergest BashaI know that ChatGPT is banned on Stack Overflow. Lately, I saw an increase of answers by ChatGPT . Join twice on same table with different conditions and no PK / FK relations Get table data not in pivot table Are the answers generated by ChatGPT banned/allowed on Database Administrators ?

Jan 26, 2023 15:35
0
Q: 2022: a year in moderation

JNat As we say goodbye to the old year and welcome the new one, we have a tradition of sharing moderation stats for the preceding calendar year. As most of you here are aware, sites on the Stack Exchange network are moderated somewhat differently to other sites on the web: We designed the Stack Exch...

Jan 12, 2023 08:14
0
Q: How do I put hard returns/line breaks in my questions on this site?

JimboI've posted a few questions with code on this site. Each time I have written the code with appropriate line-breaks. But when I post the questions the line-breaks disappear, and all the code ends up on one line. Then someone usually comes along and needs to edit the code in my questions to add the...

Dec 30, 2022 22:17
0
Q: Possible up-vote abuse?

Mark StewartThe question I came across in New Question queue, looked so horrific I didn't dare rate it; I just put in my rash opinion as a comment. I glanced at it later, and it had 2 up-votes. Knowing a bit about folks perusing new questions, I'm kind of surprised it got up-voted twice in a day. Did the ...

Dec 22, 2022 04:38
0
Q: How can I improve my question?

dc-ddfeQuestion here. I did my best to follow Stack guidelines: The question is formatted nicely with code and tables in appropriate forms. Where possible, I pared these down to just the relevant information. With substitutions for file paths and database names, the code is functional. I tried solving ...

Oct 17, 2022 10:04
0
Q: Negative votes with unknown reason should be a thing?

lemonI'm a fairly regular Stack Overflow answering user and a new user for this specific community of Database Administrators. Yesterday I was scraping through the open issues and decided to attempt helping a guy having problems with a query, with a workaround to their schema design. Op's was satisfie...

Jul 25, 2022 16:21
0
Q: Canonical community QA for index usage troubleshooting

enharmonicIs there already a canonical QA for troubleshooting why an index might not be used, even though the index exists? If not, is there an appetite for one? Should it be per-DB flavor or generic? The reason I ask is that one of my indexes was not used because of a mismatched character set between the ...

Jun 8, 2022 04:09
0
Q: Please add a tag for griddb

Nooruddin LakhaniI am seeking help to create a tag for griddb. Please check ( Tag Info ) on SO. I have posted question on DBA.SE that would cover in griddb tag. Currently I have used query tag because that's the closest one available. I request to create the griddb tag so the question I have posted on DBA.SE woul...

May 19, 2022 17:02
0
Q: Is it healthy for the community to have the same user asking so many questions daily?

RonaldoRecently I've seen a user asking 13 questions (most of them with a negative score) in a row for a specific tag and that gives me the impression that the user is overflowing the queue leaving other users with little chance of receiving attention on their questions too. On a heavily used Stack Exch...

Apr 29, 2022 23:38
0
Q: How to decrypt zipped data in MSSQL table

DelphinusWe're trying to import (reverse engineer) some data from someone else's MS SQL database, without any vendor support. In the past the data has been stored in either plain text or RTF so easy to extract. But this database has some 'encrypted' looking content. Where data is in this format there is a...

Feb 14, 2022 07:31
1
Q: Should I vote to "move to Stackoverflow" on SQL questions?

Laurenz AlbeI often encounter questions that ask for help with writing SQL, and I usually vote to move them to Stackoverflow, because that is about programming in my book. But I have the feeling that mine is not a majority position here. I increasingly get the impression that people ask questions here instea...

Jan 30, 2022 18:22
0
Q: Are we on the same page with [pagination] and [paging]?

Erwin BrandstetterI just logged in a duplicate suggestion to make "pagination" a duplicate of "paging": "paging" has 53 use, "pagination" currently only 4. But then I felt, the term "pagination" would be the better fit for the subject of dividing results into discrete pages, and this just started off on the wrong ...

Jan 28, 2022 09:29
0
Q: Why isn't AWS's sponsoring being shown on Database Administrators Meta?

SnostorpHas this been just forgotten or is it intentional? My thoughts are that if you sponsor the site, then it should be shown on the Meta site as well. See more at: AWS will soon be sponsoring Database Administrators

Jan 12, 2022 15:29
0
Q: 2021: a year in moderation

JNat As we say goodbye to the old year and welcome the new one, we have a tradition of sharing moderation stats for the preceding calendar year. As most of you here are aware, sites on the Stack Exchange network are moderated somewhat differently to other sites on the web: We designed the Stack Exch...

Jan 2, 2022 18:32
0
Q: Should we add a new [Oracle-21c] tag?

User1973Does DBA SE need a new Oracle-21c tag? I see tags for older versions of Oracle. But I don't see one for version 21c.

Dec 17, 2021 18:25
1
Q: How does the Community bot close questions after just a single VTC?

mustaccioThis question was VTCd once as a duplicate, and then promptly closed by the Community bot. Ordinarily one would need four votes for the question to be closed. Alternatively, it would require the voter to possess a gold badge in the tag, which isn't the case here. What gives?