@NickChammas You could do the sort of nasty crap we used to do with VB6 where you catch and re-raise the error in the error handler of each procedure and tack stack trace information onto it with each step.
I have varchar data in Database table which stores date in DD-MM-YYYY format.
I want to select that varchar in MM-DD-YYYY format.
im using
select convert (varchar(30),(select CONVERT(datetime,'16-11-2011',103)),101)
IT gives 11/16/2011
Any simple query is possible for this?
Currently, if I flag a question as off-topic, I only have the option to recommend it goes to meta DB.
Will I ever be able to flag it as more appropriate for ServerFault or SO?
So @JackDouglas the migration targets list ... I can't find the actual history of migrations, they seem to have removed that from the data dump, and our information doesn't go back past 90 days (dumb thing to do)
I saw the above 'ANSI warning' message today when running a colleague's script (and I don't know which of the many statements caused the warning to be shown).
In the past I've ignored it: I avoid nulls myself and so anything that would eliminate them is a good thing in my book! However, today th...
@gbn - I thought it may be related to that setting, but it wouldn't explain why the warning says or other SET operation since that setting doesn't affect how the NULL is handled, only if the warning gets returned
onedaywhen knows a lot about relational theory
but I don't think he has a lot of experience with SQL Server operationally
he's one of those people who thinks NULL should never ever be allowed under any circumstances
I appreciate that the above should not be done ('Creating a New Database Across a Network with SQL Server 2008 R2') for all of the reasons outlined here but a client wants to know how to do this and cannot be told otherwise.
To setup and test this I have two laptops connected across a local are...
Did we ever discuss that whole BI proposal being merged with us? I know there was some discussion on meta, and we mods were going to make sure we had our ducks in a row first, but it needs to be a public discussion
I had a conversation a few days ago about merging the Business Intelligence proposal with this site. There are a few ongoing conversations about the direction of this site, so I'll add another item to the mix. Should the definition of this site be expanded to include Business Intelligence topic...
Most of the feedback I've had is positive, and I haven't really seen anyone come up with a cogent argument against that's not just handwringing about the 'dba' title.
I think most people here are in agreement that the site also includes a broder set of database topics than just database administration.
The B.I. merging question is about making it explicit in the terms of reference that B.I. questions - including development related ones - are on-topic for the dba site.
Slightly separate from the naming issue, but it will cause confusion to B.I. folks in the way it causes confusion to others.
@Aarthi trying to move this discussion along so we can figure out where we stand on this once and for all ;-)
It doesn't have to be had right now, just thought you might be interested that I had brought it up again (now that I'm not dealing with back issues and can concentrate)
There are two separate issues: (a) is the dba.se name causing a problem (b) do we want to have B.I. and data warehouse questions explicitly included in scope.
@ConcernedOfTunbridgeWells I see it as being more like (a) if we take on more questions than we already do, is the name going to be a turnoff for most of the people we really want here in the first place, and (b) does our scope allow for BI as well, or is that going to dilute things too far
I think the 'dba' name is kind of misleading, but I haven't seen a better option in the ones discussed so far. 'Advanced database topics' is technically correct but sounds a bit lame. Not convinced that it's actually a better name than dba.se
If the question is primarily about writing application code than it's a SO question.
You could, in theory write an application that consumed an OLAP cube as its data source. That would be an apps quesiton just as much as a question about ADO.NET usage woudl be an apps question.
Cube design, writing administrative utilities for cubes, tuning, queries and suchlike (i.e. actually implementing the back end) would be core B.I. and on-topic for dba.se. There will be a grey area but that's what mods are for.
Database Administrators - Stack Exchange is for database professionals needing expert answers on all advanced database-related topics concerning either traditional SQL RDBMS or NoSQL databases.
Why are database developers' Q&A migrated to DBAs site
Although the site is called 'Database Administrators' there is a substantial grey area between database administration and development. Database professionals are well qualified to answer questions on these topics and this type of question is encouraged on dba.se.
Why are database developers' Q&A migrated to DBAs site
My draft wording attempts to clearly state the line where application development questions belong on SO and core B.I. systems questions belong on dba.se.
@Aarthi So here's my thoughts on that: The guy who wanted the BI proposal initially (back when dba hadn't quite gotten launched, iirc) wants it merged, and it's got some traction on the commitment to merge, but not enough. We here are fine with it, but we need one more mod at least who is more familiar with BI because it's new territory for us and we can't accurately mod it yet.
I appreciate that the above should not be done ('Creating a New Database Across a Network with SQL Server 2008 R2') for all of the reasons outlined here but a client wants to know how to do this and cannot be told otherwise.
To setup and test this I have two laptops connected across a local are...
@jcolebrand That's the guts of the problem. I think everybody agrees that dba.se causes confusion but nobody can come up with a name that significantly improves on it.
There is a school of thought - which I have some sympathy for - that it's really a brand recognition issue and the problem with confusion will go away over time.
Data Technologies
datatech.stackexchange.com
If the concern is about the scope of the site being greater than just databases and database administrators, then why not place the focus on the technology, rather than the people. This may place a correct light on the types of questions to be submit...
@ConcernedOfTunbridgeWells names like that are not allowed for SE sites; Trilogy only, as a matter of history, can have names that do not obviously describe what they are about
"There is some long history on the naming stuff, currently no SE 2.0 site (except AskUbuntu) gets their own domain, and only very few a non-descriptive name."
@Aarthi, @jcolebrand the BI merge can't be allowed to depend on a name change: including BI questions will not change the character of the site sufficiently to justify a name change on it's own and much as I'd like a different name anyway, meta says no (despite efforts to persuade).
@JackDouglas Pretty much right. I think the B.I. remit would go further into questions that might be regarded as development than 'traditional' dba.se.
@MartinC Have you tried getting in touch with Simon Sabin. He's got contacts all over the shop and posts the odd contract job on his blog. He was looking for people for Wonga.com tail end of last year IIRC
@JackDouglas I think I agree with you here, but we already have an issue with "why does that belong on dba, I'm not a dba" so if we add BI, the name is going to contribute further.
@jcolebrand There are meta questions where people have gotten confused about it. It does cause some confusion, but I think that would probably go away with time as more people become aware of the site.
Every few weeks another sharp poster asks:
Why are you asking DBAs about source control?
Why are you asking DBAs about performance?
Why are you asking DBAs about database design or data warehousing?
As a regular DBA.SE patron your response might be: "Because all of those topics are welcome on...
On Stack Exchange site Epistemology
I'm going to make an argument that the current Stack Exchange sites are (a) too broad and (b) aligned in ways that may alienate significant communities of potential users. One can observe situations where Stack Overflow does a poor job of getting answers to l...
I do notice a similar phenomenon - often I'm asking quite obscure questions. Generally, I can find answers on the web for most things, so by the time I'm asking something on SO it's something that can't easily be found by searching on the web.
Obscure questions will suffer from the combination ...
@jcolebrand yah, lots of links on there to evidence of brand/image problem, with good counter by BBrocka and a survey proposal that I would like to see go somewhere
1) We'll entertain site name changes...so long as it's not just slapping on BI onto the current title, haha. 2) Adding the mod could probably wait until the next election, but we're not opposed to adding one pro-tem. Mostly, Word of God says that y'all are probably overthinking it :P 3) Let us know when you make it Officialness and we'll email all the people who followed/committed to the BI proposal. :D
@Aarthi I'm willing to bet that Robert is well appraised of this but I want to ask it anyways: He does realize that we're not happy with the site name to begin with, right?
> I'd suggest just doing the soft merge, then, and worry about the naming issue later. They should start with a featured meta post announcement and the appropriate FAQ changes. They'll want to make sure the FAQ doesn't "over sell" the change. FAQ authors have a tendency to do that: make the most reacent additions into the most prominent part of the site
I had a conversation a few days ago about merging the Business Intelligence proposal with this site. There are a few ongoing conversations about the direction of this site, so I'll add another item to the mix. Should the definition of this site be expanded to include Business Intelligence topic...
@jcolebrand The question is a bit confusing now. It's got my preamble with a rough set of questions about the wording and two drafts of the FAQ wording by myself and @JackDouglas. It might be worth tossing the blurb about draft wording from the question itself and putting in some links to sample wordings in the answers.
@ConcernedOfTunbridgeWells Are you able to do that? I just wanted to get some idea about where to go, and I can add the red tags (which you can't, so I wanted to do that). I like the idea of drawing people to the original discussion tho
I suppose you could do sometning like: 'Database architecture, management and analytics'
Although 'analytics' is probably not a great word to use in the title.
@jcolebrand OK. I'll edit the question.
I guess analytics does a fair job of encompasing reporting, OLAP and business intelligence systems in general. Quite a lot of people still use SAS for this stuff.
I guess it really depends how much pride-of-place you want to give business intelligence topics in the site.
the last two are owned by Yojimbo who you can usually reach by pinging, he and I share a common frequent feed in chat.stackoverflow.com/rooms/642/node-js so ...
I have varchar data in Database table which stores date in DD-MM-YYYY format.
I want to select that varchar in MM-DD-YYYY format.
im using
select convert (varchar(30),(select CONVERT(datetime,'16-11-2011',103)),101)
IT gives 11/16/2011
Any simple query is possible for this?
Currently, if I flag a question as off-topic, I only have the option to recommend it goes to meta DB.
Will I ever be able to flag it as more appropriate for ServerFault or SO?
I appreciate that the above should not be done ('Creating a New Database Across a Network with SQL Server 2008 R2') for all of the reasons outlined here but a client wants to know how to do this and cannot be told otherwise.
To setup and test this I have two laptops connected across a local are...
Data Technologies
datatech.stackexchange.com
If the concern is about the scope of the site being greater than just databases and database administrators, then why not place the focus on the technology, rather than the people. This may place a correct light on the types of questions to be submit...
Every few weeks another sharp poster asks:
Why are you asking DBAs about source control?
Why are you asking DBAs about performance?
Why are you asking DBAs about database design or data warehousing?
As a regular DBA.SE patron your response might be: "Because all of those topics are welcome on...
