The Heap™ – Consultancy ©® - 2014-04-25

« first day (1207 days earlier) ← previous day next day → last day (3662 days later) »

12:35 AM

Hm. Tmyk

2 hours later…

2:06 AM

@AaronBertrand c'mon B's ... beat detroilet

yeah... yeah...

1 hour later…

3:17 AM

nice goalie slash.

7 hours later…

10:04 AM

@swasheck NHL playoff refereeing ... aka "Whistle? I ain't got no whistle"

3 hours later…

1:08 PM

Go Wild!

Man. Screw you all. :). If it takes cheap shotting the top D man on your opponents team to win, then I guess you gotta do what you gotta do. I'd rather Cookes punishment have been that he has to play 50% ice time and Suter has to sit for as long as Barrie is out. He's a big loss for us and a huge part of the reason we couldn't get out of our own zone cleanly last night.

Weird, how did this all happen at one time?

user image

@AaronBertrand you hit 1k views on all of them at the same time?

Primarily opinion-based?

0

Q: user rights validation inside stored procedure?

You have an application with a Users table, and the Users table has various columns to indicate what rights a User has within the application. Ignoring for the purposes of this question what should be done in server-side app code to implement user rights authorization, I am wondering from a ...

sql-server stored-procedures application-design authorization

Oneboxing is borked for me (both images and urls)

Seems like it would belong on security.se

1:23 PM

@Kermit those badges are vote-related, not view-related. I think someone serial up-voted me an hour ago.

@AaronBertrand shame on them

1:45 PM

uh

21

Q: Sensitive flagger data is exposed via chat WebSockets (and possibly /events), allowing "private" flags to be publicly visible

So, after I figured out that I could see who starred a message (highly related), I figured I might be able to find out the flagger of a message too. So I tried. Here's some data from my logs: hichris is about to flag {"event_type"=>1, "time_stamp"=>1398388054, "content"=>"Flag now?", "id"=>2807...

bug chat privacy chat-flags

lol

This is even worse than heartbleed!!! :P (+1, nice find) — mhlester 12 hours ago

@Kermit And mods can also see email in some circumstances

Time to change my name and go off grid now I flagged that mod answer...

@AaronBertrand sad especially when that gets reversed

2:13 PM

@SimonRigharts it's fine that they didnt call it ... it's the playoffs. that comment was not meant for the heap, it was in an im to a friend who's a wild fan who was talking about how "goonish" the avs were last night. all i saw was a team trying to match their opponent's physical intensity and they did it poorly. stastny was called a goon for cross-checking suter, but it was retaliation for suter's nasty slash of varlamov

2:36 PM

@Zane are you dead?

ConcernedOfTunbridgeWells

@AaronBertrand It's certainly an 'it depends' answer. If you needed sproc behaviour to change based on user rights you may need it to look up permissions. If not then permissions might be better handled through DB access rights. You probably could write an answer to the question that would be useful to someone, but it wouldn't have a single correct answer.

WTF area51.stackexchange.com/proposals/68087/love/68106#68106

2:57 PM

LOL

> more appropriate here: biology.stackexchange.com – swasheck 5 mins ago

@swasheck what are you doing on that site

@AaronBertrand making fun of them

Ooh, good cover

wookin' pa nub in aww the wong pwaces

wtf is ExecuteSQL

0

Q: Learning ExecuteSQL in FMP12, a few questions

I have joined a new job where I am required to use FileMaker (and gradually transition systems to other databases). I have been a DB Admin of a MS SQL Server database for ~2 years, and I am very well versed in PL/SQL and T-SQL. I am trying to pan my SQL knowledge to FMP using the ExecuteSQL funct...

sql filemaker correlated-subquery

3:01 PM

filemaker?

25

Proposed Q&A site for this site is for any part of Trolling. For those who want to prevent trolling, design systems that discourage trolling, or for people who want to successfully troll others.

Currently in definition.

haahahahaha

ConcernedOfTunbridgeWells

@swasheck I did think of proposing a RTFM Area 51 site.

@ConcernedOfTunbridgeWells what would a typical question be? Why should I RTFM?

ConcernedOfTunbridgeWells

@AaronBertrand No. Primarily used as a destination for questions from other sites.

@AaronBertrand @ConcernedOfTunbridgeWells a site where every question is RTFM?

Ah I see

ConcernedOfTunbridgeWells

3:09 PM

Off topic - moved to RTFM.Stackexchange.com

Sounds more like a close reason. :-)

@ConcernedOfTunbridgeWells oohhhhhhhhhhhh

@AaronBertrand it's too unkind

ConcernedOfTunbridgeWells

@AaronBertrand That would be a good one: Closed - RTFM.

But like swasheck says - that hurts people's feewings

god forbid we ask people to do something they've been asked to do since at least 2nd grade

ConcernedOfTunbridgeWells

3:12 PM

"That hurts people's Feewings" - @AaronBertrand

3

You guys are much more fun to interact with than twitter.

6

ConcernedOfTunbridgeWells

'Lines you'd never expect @AaronBertrand to say.'

hey, @ConcernedOfTunbridgeWells I have a reporting question for you!

It's not technical though

LOL

gents, any reason why privileges would have discrepancy? show grants command shows one, but when executing says privilege denied?

3:19 PM

@rodling deny overrides grant

So if you only look at grants...

...you're not getting the whole story.

paper beats rock beats scissors beats paper

is there a way to view denied?

@rodling Is this related to your (MySQL) question?

Also not all privs are inherited directly - sometimes through role memberships (database role, server role, even AD role), and those roles could have deny (which also overrides any user-specific grants)

yea, it is

3:20 PM

Oh, are we not talking SQL Server? Then forget everything I said. I know a little about security in SQL Server. Negative in MySQL.

@AaronBertrand it is MySQL, i was thinking it is some sort of a scope issue but the table is a subset of a DB with wild card for any table... so bit confused

@rodling sorry, can't offer any help with MySQL

@rodling You can wait for someone to answer the question. If it is urgent, you may try the mySQL chat at SO or the iirc #mysql channel.

@AaronBertrand conceptually any idea?

@rodling i dont think so. not in this room

3:23 PM

@rodling I don't know where to look for deny explicitly in MySQL. Conceptually I think I've already suggested how this happens.

@ypercube justs eeing if anyone here has any suggestions, I would post the solution if i found it

looks like i'm going to have to break down and buy my own domain name. i'm in love with ghost

and dyn is taking away their free service :)

lazerwalker.com/literally

@ypercube i did not know there was such an evil place

@Kermit you mean both iirc and mysql ?

@ypercube yup

in MySQL and relational databases on Stack Overflow Chat, 9 secs ago, by Kermit

I shift + deleted my entire mysql folder, how can i undo?

3:43 PM

@Kermit Get on eBay and buy yourself a Delorean

@JNK that would be appropriate for a trolling SE

@ypercube That's like a mongoDB friendster page

4:05 PM

@JNK what's friendster, precious?

It was a very lackluster try at competing with facebook

The facebook idea with a myspace implementation

(e.g. technically not so good)

ah

the worst of both worlds

WITH security as (select * from security),
asset as (select * from asset)
update sec
set a=value1,b=value2 ...
from security sec
join asset a
on sec.id=a.secid

i feel a beatdown coming

I created 2 indexes this morning that have already had a combined 1.2 million seeks, with no further scans since the new indexes. That's a win, right?

@MaxVernon how many updates?

@swasheck the 2 new indexes themselves have had 0 updates. The clustered index on one table has had updates, but that is no different than before.

4:17 PM

@MaxVernon do you have a consistent write workload or does that occur overnight?

@swasheck its continuous - "UPDATE MostRecentUpdateTime WHERE ID = x;"

seems crazy to me, but hey that's how it works.

Rows are updated by devices in the field.

then yeah ... i'd say it's a win

cheers!

4:40 PM

@AaronBertrand oh no, shog answered our question

0

A: Why not just inherit the rep from the site where you have the highest rep?

So, if you have 110K on skeptics, and that is your highest rep in the network, you have 110K here. Except... No one has 110K rep on Skeptics. In fact, most sites don't have anyone with 110K rep, or even very many with 10K rep. Here's a breakdown of users with 10K by site: 10K Site Name 55...

bummer

yeah, bummer. I think it's ok though that privileges are weighted toward SO users. Just because that site has a ton of users doesn't mean any of those users got their rep by not learning the general SE mechanics or how the community works.

Will Meta.SE have its own Meta, I wonder?

@AaronBertrand yeah it's sort of like "being rich in NYC doesn't count because there are tons of rich people"

2

@AndriyM ha ha maybe so

4:47 PM

MetaMeta

Meta2

Meta²

i thought that the question had to do with having the same rep on the site-specific meta. so i'd have {{dba.se rep number}} on meta.dba.se

area51.stackexchange.com/proposals/68087/love/68106#68106

@swasheck you already do have that. meta.se is completely separate, and when you register there you have 101 rep - regardless of rep you have on any specific site. The proposal is that you get privileges you've earned on your own "best" site.

ehrmagerd ... just ehrmagerd

@AaronBertrand really? didnt think so

So if dba.se was your highest rep, that's the rep you'd have on meta

@swasheck didn't think what

4:56 PM

@swasheck it was a recent change. When meta.SO stopped being the network meta and now there is meta.SO and meta.SE

the first mirrors your rep in SO, the second has its own rep (the rep you had on meta.SO previously)

Right. Meta SO became stack overflow's per-site meta (just like meta.dba.se). The rep you have there is the same as your rep on stack overflow. Down-votes etc. don't cost you rep.

On Meta SE you have what you used to have on meta SO. Down-votes do cost you rep. I don't quite understand why that site has to be so different.

If I can vote to close a question about down-voting on my per-site meta, why shouldn't I be able to vote to close the exact same question when it gets migrated to meta SE?

yeah, weird

ah yes. sorry for my delay. i see it now

but I think that meta.SE users feel like they've "invested" too much to now lose that rep

@Lamak pissing and moaning about policy and such ... i understand the need to maintain that rep

5:01 PM

@Lamak they wouldn't. If meta is their highest rep site, then that would be their rep at the time of the change. Then it just wouldn't change after that. :-)

...until they surpassed that rep on another site.

How do bounties work on per-site metas?

Do they cost you rep? Honest question, I don't know.

I have no idea

remote controlled tazers in the seats of devs office chars .... that's what i need right now

@AaronBertrand true....then I think that they are not ready to give privileges to people that haven't invested as much time as them

@Lamak precious ivory tower

exactly

5:06 PM

that sounds familiar

except the ivory tower is actually just an elevated sewer

@swasheck I read and upvoted your comment.

@swasheck yes I chose that analogy on porpoise :-)

i dont know why meta bothers me so much.

Because the people with all the "answers" are smug, resistant to change, and think that - no matter what aspect of a site or the network we're talking about - the way they designed it is the best possible design

if we were debating the finer points actual information that benefits humanity in some way, then i'm all about constructive debate ... but pissing and moaning about site jurisdiction and spinning up flaming holy wars about stuff is just dumb and a waste of time. it's why i'll never accumulate a large amount of rep on meta ... because i care about information. when it comes to policy, polity, and jurisdiction ... IDGAF

5:14 PM

Must have really sucked for them to eat crow about little things like Too Localized

in die go a fire?

i dont give a ____

ah ok

very close to GDIAF

thought you may have been drunk-chatting again

it's only 1:15 here. On Fridays I don't open the whiskey until 2

user58869

i've found that it's often best to avoid drinking and chatting

@swasheck what do you mean by _____

@Kermit lot of money to political causes in southeast asia

5:19 PM

@JNK so "i dont give a lot of money to political causes in southeast asia"

makes sense

@Kermit I'm not really surprised, but it's surprising he felt the need to tell us

I always suspected it

anyone else seeing this in meta.SE?

> This site is currently in read-only mode; we’ll return with full functionality soon.

Yes they announced a brief network-wide read only blip (something about testing failover in a specific data center)

@AaronBertrand Doesn't mean they did either. In fact, there's very little reason to think most of them have; see also the previous proposals for giving folks cross-site privileges (editing, bounties) for that they've earned on one site.

5:30 PM

user image

@AaronBertrand thanks

@Shog9 I just think you folks are way too protective of what meta is, as opposed to what it should be: a place to openly and freely discuss the network. People with much experience on specific sites are afraid to even utter a bleep on meta; others, like me, are just turned more and more off of it every day.

@AaronBertrand Good.

I think there is way too much emphasis there on rep and what rep means. I'm not clear on why a down-vote on a suggestion I make on my own meta doesn't cost me rep, but if it gets migrated to meta.SE, it does.

@Shog9 why is that good? Why bother having a community where you are happy that people are afraid to participate there?

ConcernedOfTunbridgeWells

@JNK What is it?

5:34 PM

@AaronBertrand It costs you meta.SE rep. Still doesn't hurt your rep on a real site. If the fact that you have a number reminding you that folks do / don't care for your thoughts causes you to pause before expressing them... Well, you can always vet them on a per-site meta first.

@AaronBertrand meta.so is off to a good start, but way too many per-site metas are ghost-towns. Take a look at meta.dba...

@Shog9 that doesn't bother me. But you and I have talked before about how rep etc. is very important to a lot of users.

@Shog9 meta.dba is quiet because (a) our volume is low (b) the site tends to work rather well self-policing itself

This notion that every thought that crosses someone's mind must be shoved in front of the ever-growing population of the entire network isn't just misguided; it's actively harmful to attempts to actually accomplish anything there.

@Shog9 who is proposing that?

@AaronBertrand No one. They just go and do it. So I'm looking to discourage that.

Great. I'm out.

5:37 PM

@Shog9 I still don't see how that meta question is encouraging that behaviour

@Lamak it's tangential - @Aaron trotted out the "open and free discussion" notion, and I was responding to that. "Open and free discussion" falls apart once you have thousands of interested parties.

At some point, you have to break up the discussions, break out into smaller groups, or you never actually get anywhere.

@Shog9 then let's focus on that question instead. I think that what @AaronBertrand said has his own merits though, and I think that he wasn't talking about "say whatever you want" when he implied that

:shrug: pick a specific problem then. Always happy to talk about those.

@ConcernedOfTunbridgeWells I'm being tasked with researching alternatives to SSRS or addons for it

our main gripes seem to be with the way SSRS handles email

@Shog9 sorry, I'm bad at assigning the right mood to some comments, so not sure if that was snark or not

5:42 PM

are you aware of any add-on for SSRS that makes email a lot more intuitive, i.e. easier to manage subscriptions, support for SMTP authentication, etc?

@Lamak no, I'm serious.

you didn't seem happy, but ok

@Lamak I'm just distracted - on the phone

@Lamak that's his default state ;)

@Shog9 anyway, I thought that you came here to somehow discuss that meta Q, and I was involved in convincing @Kermit to post it, that's why I engage in the conversation

5:44 PM

Meta has always suffered mightily from a sort of... uh, preoccupation with consistency for consistency's sake. "Let's normalize all tags!" "Let's pick a single, proper format for titles and then edit everything!" "Let's make rep mean something!"

It's understandable, but... Unless/until there's an actual problem caused by inconsistency, it's just busywork.

So I tend to be somewhat dismissive until someone brings up a problem to go with their solution.

@Shog9 I could try to explain my specific motives for it

@Lamak cool!

well, I'll start by saying that I really really care about SE (even if I sometimes talk crap about SO questions), I hope that that's clear

yes

and I visit meta (both meta.SO and now meta.SE) as regularly as I visit SO, DBA.SE

5:47 PM

I suspect that's true for most of the active folks here

I try to read every worthy discussion there and be in touch with the politics and decisions

@Shog9 true

With the possible exception of @JNK, who sees this as a stepping-stone in his master plan for world domination

2

@Shog9 One site at a time....

@Shog9 has there been a suggestion to have an answer queue? what i mean by that is that users can submit answers to questions, but they won't be posted until after 5 minutes.

@Shog9 but.....and here comes the part where I speak for myself...I hate meta, the participants, the attitude, and I'll likely never participate there again

5:48 PM

@Kermit sounds like a meta Q to me

@Kermit yes

@Shog9 my search abilities are subpar

@Lamak everyone hates meta. It is a necessary evil.

@Shog9 but not everyone hates to bring discussions and ideas

and I do feel bad that I can't bring myself to post there

@Shog9 i can't seem to find this suggestion

5:49 PM

and that @AaronBertrand or @Kermit or someone else serves like a proxy

@Lamak meh. My dad used to say, "it's important that you know how to write well, so you can recognize when you shouldn't"

@Shog9 but I'd like to

@Lamak *hates to bring

@Lamak why?

@Kermit i'll look in a bit

@Shog9 tx

5:51 PM

@Shog9 and this comment might be true for a lot of newbies users, some very dissenting high rep users, but meta is mostly people that really loves meta and loves to give their opinion and belittle the rest

@Shog9 Because I care about SE, and I fell that some of my ideas/feature requests might be useful

@Lamak maybe. But - and I'm speaking from experience here - writing a good feature-request is really hard.

Not because of meta feedback. Because specs are hard.

Because identifying unintended consequences is hard.

Because even understanding a massively complex system well enough to see what changing it would accomplish is hard.

I signed on to meta (actually, UserVoice) for the first time because I was seeing changes made to SO that I strongly disagreed with, and I wanted to know if there was somewhere I could have said something that might've caused Jeff & Co to stop and think a bit more about what they were doing.

@Shog9 I get that. And I'm possitive that it would be harder for me. And granted, I don't have much experience actually asking questions, I have 0 questions in SO, 3 in meta and one in Android I believe

134

Q: Help the helpless with how-to-ask tag tips

After adding a particular tag, such as this super helpful assistant will pop-up to suggest what their question should contain: Since forcing users to get badges or asking them "what have you tried?" to improve question quality isn't working, this seems like a viable alternative. The nice...

feature-request tags asking-questions

What a terrible question

-27

Q: Are illegal drug names offensive?

I stumbled on to a user whose name is an illegal drug: Crystal Meth Is this "offensive" or otherwise unacceptable? My opinion is that this is not an acceptable username.

discussion usernames offensive

@Shog9 And I'm not special in any way. But why is the real reason that I can't have the same privileges in meta.SE that I have in SO?

@Kermit yeah, I like that suggestion

6:02 PM

@Shog9 you just like clippy

@Lamak have you helped anyone flesh out their ideas? Find answers to their questions about how SE works? Proposed an idea that captured the essence of the needs of many, previously unaddressed? IOW, have you done for folks learning about / working with SE what you've done for programmers?

Why should the system - or other users - trust you, if you haven't done anything to earn that trust?

@Shog9 Nope. But are you telling me that many of the comments in meta.SE do that?, or is just a circlejerk of "how it's done it's ok and that's all!!"?

no offense with "circlejerk", just lacking vocabulary

@Shog9 then why trust me in meta.SO at all?

@Lamak well, I'm biased. So, look at my answers & tell me which one I spend more time doing.

@Shog9 I'm of course not talking about you specifically (though you do come very terse to some users that really want to improve some aspect of SE, but you at least give facts)

@Lamak I think his point is that national/international government is a lot different than city council

Just because you were active in city council in your small town doesn't mean that your experience directly applies to a much larger scoped organization

6:07 PM

thanks for the translation ;-), I'll ask for your @Shog9-english dictionary sometime

@Lamak the notion there is that discussions will tend toward things that are more or less specific to what you're actually doing on the site. Note that the top two non-mandatory tags on MSO right now are [tag] and [retag-request] - things that require subject-matter expertise more than system expertise.

@Lamak Also the english word you want there is tautology I think :) It's a self-reinforcing idea (I am faster because I am better, and I am better because I am faster)

@JNK thanks again

@Shog9 by volume I bet a huge portion of the M.SO questions are "why was my question/this question I like closed?"

Anyway, I'm starting to hit a language barrier explaining my thoughts. I still find it weird that some motivation of meta is to alienate engaged users

(it might also be a barrier to just put my thoughts into words)

6:11 PM

@JNK well, they will be eventually. And again, that requires a subject-matter or at least site expert.

@Lamak Lemme see if I can explain this from a different perspective...

I think that I understand you perspective pretty well. But I can't really express mine

There are a lot of folks who struggle to use these sites for one reason or another. Folks who, like you, struggle to express themselves. Actually, most of them struggle a good deal more than you. So the same questions seem to float up over and over again. And as time wears on, the folks kind enough to answer them start to get burned out - particularly when the problem is something that they can't personally identify with.

So... These folks, the ones facing these problems, start to have a bad time.

@Shog9 that's why I started saying that I actually visit meta pretty often and read most discussions there (not really "most" but a lot)

I wouldn't just ask: "please enforce a comment when downvoting!!"

@Lamak you wouldn't. Because you know better: you've seen the past discussions along those lines.

Plenty of other people would and do though.

and mirroring some rep on a site won't stop them or encourage them either, I think

6:17 PM

@Lamak in most cases, rep is irrelevant to folks asking questions. On any site.

This is the essence of the "help vampire" problem. Which is unfortunately named; these folks aren't monsters, they're just oblivious: they have a problem, and think they've found a solution - they don't realize they're causing unwanted work for others.

and how would the "rep mirroring" affect this?

@Lamak directly? Not at all. Again, many/most of the folks asking don't care about rep in that context. Indirectly? It means you're not giving the privileges they need to the folks who are actually putting the time in to help. The folks posting answers, or setting up and maintaining FAQs, or editing titles and tags, so that these questions don't need to be answered 100 times every day.

You're ignoring the fact that the problems folks are facing are themselves a body of knowledge within which there are experts taking time to educate others.

@Shog9 I understand your motives, I just don't share them. And I also think that some of my views are very biased as a user that had some bad experiences there....but I think that many users there don't put time to help, just take the opportunity to...I don't know, give a hard time to users with less experience

It's the same argument for having rep on normal SE sites: in theory it's not necessary, you can produce all of the same value without it... But by having it, it offers the community a way to recognize those who are helpful, and build a system for maintaining and moderating this knowledge.

@Lamak so to go back to my example... This is where we ran into trouble with MSO when it was also MSE: we had effectively two separate but overlapping communities there, one who was there to kinda keep an eye on the direction of network tooling and policy development, and the other who was there to keep an eye on what was happening on SO. And... They were not well-separated at all.

So someone would hop on and post a question about something they were doing on SO, and they'd get folks jumping in to slap them down 'cause it was the 10th question on that topic this week, or giving them bad advice because what they were doing would have been really bad on Arqade or something.

And I'm looking at this, and just hating it.

I mean, I don't have a ton of sympathy for some of these folks, but when they're asking a straight-up question about something they ran into on the site, there's no reason not to give them an answer. Tearing into them just gives us all a bad name.

And meanwhile, I'm looking at what's happening on other meta sites, and I'm seeing folks much more willing to just step up and ask questions. Yeah, some of them still get criticized and down-voted, but straight-up support issues are generally handled reasonably well.

And it's not because of the voting, or rep-tying, it's because we're literally forcing two separate communities with separate interests to share the same space. Imagine if we crammed DBA and... Let's say, SharePoint into the same site: someone would suffer. Probably everyone.

6:34 PM

I get it. And as I said, I'm probably just biased anyway and resent some of the high rep users for the way they act/things they say/how they piled up

@Shog9 please don't

@Lamak I appreciate that. Look, I remember joining a new site many years ago, after kinda lurking there for a while and thinking I had a feel for what it was all about. So I jump in with my first post, a fairly irreverent write-up on something or other. And it gets slapped down immediately, with a very polite but brutally honest assessment of its quality or lack thereof.

I was wounded. It wasn't like plenty of other folks on the site weren't writing similar posts. Why couldn't I join in?

Oh, sorry, I'm not that petty to feel this way because of just my post. I resent mostly how many of them treat other users

Well, of course... They were also writing heaps of long, well-researched, useful posts.

@Lamak Sure. And like I said, I believe a big chunk of that is due to trying to force two separate groups with very different interests into the same venue.

maybe, you have much more information to correctly assess that

in fact, IIRC I don't really have a negative score post there (thanks The Heap!)

So yeah, I'm sorry if I'm coming off as dismissive of some of this stuff, but... MSE isn't gonna get any more tolerant of folks asking repetitious questions or making naive requests - they'd be silly to do so; their goal is to drive the development of the engine, of policies that have wide-ranging effects across many communities - they're supposed to be a bit conservative, or at least thorough.

That doesn't mean we can't provide places for folks to ask support questions or test the waters for new ideas though.

And that's what per-site metas are supposed to be for.

If you can get your problem resolved locally, by the folks you're interacting with every day already, then that distributes the support load much more efficiently and is less likely to cause stress for all involved.

If you can get a clearly positive response and useful feedback on your ideas from these same folks, then you stand a much better chance of achieving the same on MSE.

6:42 PM

But are there many high rep meta users that are not high rep in SO?, or that spend much time there and will still be repetitive questions anyway?

@Lamak nothing's ever perfect ;-)

There are - off the top of my head - something like 130 active users on MSE who have more rep there than they do anywhere else.

Note that that includes a fair number of SE employees

@Shog9 but they are most likely very active in meta.SO

or they will be

@Lamak eh... Maybe. MSE has a fairly diverse crowd, particularly when you get into the sub-group who spend a lot of time there.

SO dominates everything in raw numbers, but proportionally it's not that well represented on MSE.

I guess I don't have another option more than take your word for it

@Lamak I can give you numbers if you care. But I can't predict the future either - I'm basing most of this on gut feel and entirely too much experience; if I'm wrong, I'll be the 10th to admit it.

6:46 PM

@Shog9 you can't?, then what do you do?

@Lamak whistle a jaunty tune

So, when is SE gonna greenlight spanish SO??

I've waited too much ;-)

Which Spanish?

which?....ermmm....I mean the 100% commitment area51 proposal for Stackoverflow in spanish

I'll take that as a "never"

@Lamak no, I mean which dialect

6:54 PM

Is there a need for doing that?, I don't see an "England-English SO" or "US English SO"

@Lamak because it's US English

That's just assumed.

What else would someone mean when they said "English"

How folks from England talk? That's silly - you might as well expect a Portuguese site to use phrasing from folks in Portugal!

@Shog9 now I have the gut that you are not being completely serious ;-)

But Spanish, I'm not so sure. I mean, Cuban Spanish? Mexican Spanish?

@Lamak you catch on eventually ;-)

I'm chilean, so...let's go with that

good plan

6:58 PM

well, let me know if the beta site ever goes live

ya

ok everybody, you can come back

@Lamak: You've done a very good job of letting @Shog9 explain the issue thoroughly. I really appreciate that.

I was just rambling about why I dislike meta

@Lamak lol

7:15 PM

CHANGE REQUEST: DENIED
REASON: LEARN TO WRITE SQL

@swasheck Something that really happened or something that you wish you could do?

@AndriyM i just did it

i'm done effing around with braindead devs

@swasheck what was the change?

@swasheck dude, @Shog9 is still here

@JNK massive semijoin update with unnecessary writable CTEs

@Lamak @Shog9 and i go way back. he owes me for the whiskey rec

7:19 PM

@swasheck wife just found a place that sells Tin Cup. On her way home with it...

@swasheck fun

@Shog9 it's quite different but is worth it for being less than 1/2 the price of stranahans

@AaronBertrand tnsgingerale.files.wordpress.com/2013/06/…

lol

7:37 PM

@JNK just referenced you

14

A: Common Table Expression (CTE) benefits?

As a rule, a CTE will NEVER improve performance. A CTE is essentially a disposable view. There are no additional statistics stored, no indexes, etc. It functions as a shorthand for a subquery. In my opinion they can be EASILY overused (I see a lot of overuse in code in my job). Some good a...

What is Tor this question is talking about: meta.stackexchange.com/questions/230221/… ?

@AndriyM torproject.org

@Lamak Thanks.

it's really famous and used for a lot of "not very nice" things

it has legitimate uses too

@swasheck yay

7:42 PM

@Lamak Never heard of it before. After reading the question I first thought it was something made specifically for SE (something like a tool to circumvent bans).

@AndriyM it's like that for the whole internet

Michael J Swart

8:26 PM

So what's new people?

well....it's Friday

I have to work this weekend

to fail over our servers for an upgrade

@JNK i'm on call this weekend

@JNK did you ever find resolution to your problem?

8:43 PM

@swasheck yeah recreate replication

I actually spent a day or so testing the hell out of our replication scripts already so I think it will be fine

that's what i figured ... but good for you for testing

The DBA™ had major issues last time that we wanted to avoid

enjoy the upgrade experience

im not even doing it

just failing over, we use Rackspace for hosting and they are upgrading the cluster

well have fun trusting them.

though failing clusters and such seems like it should fall under the purview of The DBA™

« first day (1207 days earlier) ← previous day next day → last day (3662 days later) »

Transcript for

Apr '1425

The Heap™ – Consultancy ©®

General on- and off-site discussion for dba.stackexchange.com....

frogs mysql nosql oracle postgresql sqlite sql-server

join this room
about this room

00:00

06:00

12:00

18:00

all times are UTC

site design / logo © 2024 Stack Exchange Inc; legal

mobile