skysight-inc/HackerNews huggingface dataset:
I do a lot of minor performance tuning in mssql, and while I am not any senior professional, I often see parameter sniffing or a cached plan that makes no sense causing an issue when the server thinks its too expensive to create a new plan, and as a result the cardinality estimates are all wrong, the operators are often wrong, and you can see a query that often runs in insignificant time take forever.

As far as I know, the small changes you made just invalidated the plan (as the code wasnt the same) and make the server recompile your query's plan. You can accomplish the same thing by using sp_recompile

Depending on the code, I have fixed this with a few different answers:
1. You can write code that is clearer and simpler for the optimizer, sargeable queries and all that.
2. You can actually (I think in 2012 or later) issue a plan guide so that the query always runs in the way you decide.
3. You can do more hacky things like deciding to recompile the plan each time you run the query, or do a similar thing by assigning all your parameters to local variables, the query optimizer then cant parameter sniff.

You want to learn a little bit about parameter sniffing, because an execution plan that is poor can often be caused by re-using old values to plan the query,
Educating Consumers on iBeacons and Other Location Aware Mobile Technology
You can't put anything in the SubjectAltName field, you can put anything that isn't a valid TLD (and not have to validate it).
Classic race condition... when I read about it being intermittent my first thought was something timing-related - interrupts are always a good guess.

The only remaining mystery is why nobody has ever seen the issue on a real BBC Master.

I think it would be possible on real hardware, but the probability of getting the exact conditions required to trigger it is so tiny that someone might've seen it once at most, and ignored it as a random glitch that never happened again. It's just by pure luck that the emulator's timing quite consistently matched the trigger conditions.

At least this type of race condition is still essentially within the digital abstraction of the machine and can be debugged at that level - those related to analogue timing are even more aggravating; here's one interesting example of that:

http://www.linusakesson.net/scene/safevsp/
I'm hoping they just lucked out and came up with a backronym for it. I don't really know much about tor so I don't know how feasible bruteforcing is
Combining two wikipedia articles,

http://en.wikipedia.org/wiki/List_of_countries_by_number_of_...

and

http://en.wikipedia.org/wiki/List_of_countries_by_number_of_...

there are 87 million broadband subscriptions (likely shared) vs 117 million households. So thats at least 30 million permanently un-TVed households. Which would probably be good for the nation.

My mother in law got a smart TV about three years ago. No internet access for her. At the time I couldn't figure it out, but it makes more sense now.

One interesting problem is there are a lot of TV models out there and none of the software will ever be upgraded in practice, its like Android phones, its unlikely it'll ever be upgraded from what it shipped with. Its likely the "smart" features of her TV are already unusable due to API changes over the years.
I would assume that DigiCert checked each and every one of those.
Yes because people that do not fit into social norms are helped by government all the time....

If you believe that I have some nice beach property I think you would be interested in.

Government through out history has been the engine of discrimination. The only legal way to abuse and harm a social group you do not like is by regulatory capture. Government for hundreds of years has been used to socially engineer society they way those in power desire it to be. From Marriage laws, to who qualifies for welfare.

It is the epitome of ignorance to state that government is the best method to help those that "do not fit well into community norms"
Nothing, and it's interesting that they have enough computational power to do that for a relatively trivial project.

Meanwhile, whilst I applaud Facebook going above and beyond here, this doesn't set a good precedent.

Firstly, Onion service are very slow. There is no need to pay this cost for a service whose ownership is not actually hidden. If the Tor project made it easier to reliably identify traffic from Tor exit nodes, Facebook could apply whatever rules they wanted to Tor traffic without needing to slow things down for everyone.

Secondly, by doing this, there's now a risk that other firms who want to be on the cutting edge of privacy will try to copycat this approach, even though it makes no sense and is very complex and expensive to set up. Worse, users might think it's some kind of "gold standard".

Thirdly, it doesn't actually solve any of the reasons why Tor traffic is routinely discriminated against and harassed: Tor is effectively a "bulletproof ISP" that shields a lot of abuse and hacking. Merely making a Tor hidden service specifically for Facebook doesn't solve that, at all.
The big Snapdeal screw up: Man orders smartphone, gets bar of soap instead
Then taken from an objective view government has harmed far far far far far far far more people that it has ever helped
Ask HN: How to address female coworkers getting paid less
Hi HN,

I accidentally discovered the hourly wage that some of my newly hired female coworkers make (offer letter left in the open). The trouble is, they have been hired in at the exact same job and experience level (programmer, right out of college) that I was a couple years ago, but they are being paid less than I was at that time.

The pay difference is pretty small, about $1.00, but our company also claims that our salaries are pretty algorithmic based on experience level.

I don't believe that anyone at our company would consciously pay women less for the same work, but it looks like maybe its happening unconsciously.

I feel a little uncomfortable talking to either the relevant coworkers or my supervisor about it because I'm not sure it's my place to comment on what they are getting paid, but it also feels like I am contributing to the problem if I don't say something.

What should I do HN?
Was it Enron company? that was in business with electric power and would shutdown power factories from time to time just to make shortage of power and rise the price of electricity? How bad did it end?
I'm not very current on the Scala tooling - is there a reasonable lint tool which enforces these types of suggestions?
You could probably apply that reasoning to 99% or so of all text messages and facebook status updates.
An internet tax? That sounds like something that the Australian government would conjure up [1].

[1] http://www.smh.com.au/federal-politics/political-news/secret...
Ahh the classic "Who will build the roads" Fallacy

To think government was the reason for any of things you site it ignorant is best.

You really need to study history more.
First, what comes closest to Orwellian total surveillance today is the NSA mass surveillance program which was created by government, not the free market.

Second, I wouldn't personally feel OK with that outcome but I would also recognize that most people do (given your premise) and that I have no authority over their personal choices.
That doesn't make a lot of sense unless there was some news released during the period of the tax which they wanted to bury. The denial of entry of a few people to the US doesn't really seem like it would qualify.

Maybe they signed TTIP and I didn't notice...
I'm not so sure what to think of Scala as a language, but I think the naming and formatting recommendations in this document have merit beyond a single language.

There are only two hard things in Computer Science: cache invalidation and naming things.

Truer words were seldom written. Just compare the naming culture in Common Lisp with that of OCaml, for example. Worlds of difference.

And don't even get me started on the “standard” way of formatting in C family languages...
I'll add a better example, thanks for the feedback.
Was going to say the same thing, saw that both on my iPhone and on my desktop (with a half screen width browser). Way to piss users off.
El Restaurante Zaranda- Castell Son Claret de Fernando Pérez Arellano
It's not that easy though. 'Marriage' has stopped meaning 'a lifelong union for the goal of producing and raising children, breakable only under certain very constrained circumstances, and therefore upon which spouses, children and society may rely as a foundation' and has started meaning 'legal recognition of the fact that two people currently enjoy one another's company and wanted to have a big party.'

Due to this change in society, it is difficult and becoming more so to marry in the older sense. The more people who adopt the latter meaning, the fewer will retain the older. And even those who think they do are inevitably influenced by the rest.

I don't care much more about two homosexuals claiming to have married one another than I do about someone claiming to be a prophet or the reincarnation of Galileo; what worries me is the continued removal of any meaning from marriage.
I think it's commonly called your brain.
They got their money; I doubt they cared.
That's not an internet tax as much as full surveillance over the internet. I'd take a tax over that any day.
Bill Gates Offers Young Thug $9M Cash to Stop Making Music
> How do you know that perfect equality presents as perfectly equal percentages of any given profession?

It almost certainly does not present as "perfectly equal percentages", but such radically unequal percentages are at least suspicious, especially because the professions you listed pay unusually poorly compared to jobs of similar skill and education levels.
Solving the world's plastic problem
Toronto - http://bootcamper.io/t/location/toronto

Vancouver - http://bootcamper.io/t/location/vancouver
Generally, information that has absolutely no merit in a court case isn't allowed in the courtroom because (I presume) it can subconsciously alter a person's judgement of the proceedings.

Assuming a retweet is the full extent of their "friendship", this is the real-world equivalent of dismissing an expert witness because the defendant quoted them in a paper once.
It's actually both - surveillance and we will have to pay for it
I'm Hungarian and I can assure that this move is a beautiful temporization from our government. They proposed this tax to herd the attention from the 'banning scandal'.[1] And now from one moment to the other, they are heroes.
[1] http://www.reuters.com/article/2014/10/20/us-usa-hungary-idU...
"The reason to have income tax is to have people who can afford it contribute to society."

I don't think this is why we have income tax. All taxes are artificial. They're artificial rules inserted into the natural market, like how we put a bit into a horse's mouth so we can influence it's behaviour. I think the better question for any tax is: are we putting the bit into the horse's ass? It seems to me this proposal to tax bandwidth was more like that; it's just bad policy.
Psychedelics are immensely powerful tools.

Like a plane, like an ocean liner, like a battleship, you can have fun with them, but you can also blow your head apart. They should be given the utmost respect, since they can, as you found out, radically change your life and outlook on the world.

If you are after their psychotherapeutic effects, you would be wise to only take them under the supervision of a trained and experienced therapist who you respect and trust.
Fuck Nike, fuck Apple, and fuck every other soulless corporation.
Start Up. Drop Out. Welcome to the Garage
This is kind of cool as well: https://bugs.launchpad.net/ubuntu/+source/cupsys/+bug/255161...
17 Social Media Etiquette Rules to Never Break
Yes, phones do this too. But the massive difference is that you have to consciously bring up Siri and you know when it's listening and when it's not. The TV appears to be constantly listening for audio commands and is sending whatever it hears upstream for processing. Someone in these comments said that you can turn the TV on through a voice command, which means that it is listening even when it is off and merely plugged in.
Shimomura was successfully prosecuted?
If you’re reading this post, you’re probably familiar with the variety of social networks available online. While you might be familiar with platforms such as Facebook and Twitter, you might not know the rules of using each network effectively for your business.
> It was simply how the cards fell for that class due to most girls in the school NOT being interested in electronics.

It seems likely that the fact that so few girls expressed an interest in electronics is a result of differences in the way society treats men and women. Whether or not this is inherently a bad thing is something I think can be reasonably debated (and at great length), but ultimately I think it is.
Well, that's interesting and weird.

It was very strange for this to use the term "directive" for the core instructions used in the language.

In actual assembly, the term (http://en.wikipedia.org/wiki/Assembly_language#Assembly_dire...) is used for meta information, i.e. the directives are to the assembler (the tool converting your source to a program), not part of the resulting program as such. This created a huge disconnect for me, and I stopped reading.
Cooking Food from Anime Curry of Life
As a single 36 year old man with no desire to have kids,I could care less if other people have kids and feel it is their responsibility not mine to pay for their life choice of having children
> Firstly, Onion service are very slow. There is no need to pay this cost for a service whose ownership is not actually hidden.

As long as you don't have to use it, I don't see why offering users a choice is a problem.

>If the Tor project made it easier to reliably identify traffic from Tor exit nodes, Facebook could apply whatever rules they wanted to Tor traffic without needing to slow things down for everyone.

ExoneraTor does this quite well in my opinion, and I don't follow how/why you think this will slow things down for everyone. Surely you're not referring to the entire Tor network?

The main value in using this, in my opinion, is reducing the potential attack surface associated with MITM attacks--including CDNs--after your traffic exits Tor. Attacks on Facebook users involving Akamai have been documented by NSA, for example; Facebook is a PRISM partner, but this would arguably still stack the deck in favor of "going through the front door" to access Facebook user data.
Hello @brudgers,

The intent of this list isn't to scare people or to make them follow my conventions.

When working within larger teams, regardless of language, you need a list of do's and don'ts. And powerful or unfamiliar languages are especially problematic for rookies - because they need to make choices (e.g. what abstraction should I use to model this or that and before anybody mentions Python's philosophy - as an ex-Python developer I must say that it has led to horrible non-orthogonal choices).

I do not believe in imposed choices - mimicking what other people's are doing without understanding the reasoning behind it can lead to really awful hairballs, as anybody that worked within an enterprise-ish team can attest to. For example in this rule I'm trying to undo the damage done by another "best practice" that people are mindlessly following - https://github.com/alexandru/scala-best-practices/blob/maste...

Also many rules in that list are not necessarily related to Scala - does a language protect you from horrible, convoluted and big functions that do too many things? Of course not. Does a language keep from storing dates without timezone info? Of course not.

It's a work in progress though, feedback appreciated.
> I think it’s fair for Apple writers to complain about the fact that a lot of people who have no clue about how Apple’s business works make crazy pronouncements about what Apple should do. But I do think that they should measure their own expertise by the same yardstick.

John Gruber is very guilty of this. He understands Apple very well, knows how they work, and how they think. But every time he discusses Nintendo, I see the same mistaken thinking about the company that, were a similar mistake made about Apple, would earn a "filed for future claim chowder". Like Apple, Nintendo does things differently than its competitors. But that doesn't mean that they do things similarly; nor do they face the same challenges.
As much as I agree that the internet should be as free as possible, all technology has negative externalities that we should not ignore, and good policy can solve. Do we want pedophiles unencumbered access to the internet? Nope, but we also don't want the effort to block them to block the things we want.
> Just the way white people saw native Indians as Savages it is easy for western eyes to perceive India as a very bad land

While I somewhat agree with the gist of your post, you might want to reconsider this broad brush with which you're painting both modern "western eyes", and particular bunches of white people who genocided nearly an entire continent a few centuries ago.

Substitute nazis/jews/"German eyes" if you don't get what I mean (going to assume I'm excused from Godwin's law when the implied atrocity was in fact larger than the Holocaust).
Wow, I'd be scared too. Like Mr. Finch used to say, “only the paranoid survive”.
"I consider being gay among the greatest gifts God has given me."

I don't like that statement.

Replace gay with one of white, male or straight and see how it sounds.
Microsoft- Cloud Based Universal Phone Number
Show HN: Sift – A lightweight and easy-to-use tool for accessing your clouds
YogaGlo Patent Dropped
That's harsh, it's more versatile than that - there's a beautiful person in their 20s checking the stock price while on a yacht, there's a beautiful person in their 20s out running, a beautiful person in their 20s making a note of an idea while in an amazing office.

There really is no limit to what beautiful people in their 20s can do with this sort of product.
Somehow this misses the point
Just curious, how could they do this? Is there a reasonable possibility of integrating a cell antenna into a TV? I find that implausible...
The State has no business being involved in morality, so outlawing homosexual activity is outside the State's remit.

The moral argument against homosexual pseudomarriage is that it represents a fundamental misunderstanding about marriage. Marriage is not about a couple's (or a group's) feelings about one another. It's not a way that society shows approval. It is, rather, the formation of the most basic unit _of_ society (I'd argue that the individual is not really a unit of society), and is the means by which children are produced and brought up.

(And yes, there's plenty of heterosexual pseudomarriage too)

But, given that these are all moral arguments, my preference is for the State to absent itself entirely rather for it to take a side and do further damage to an almost destroyed institution.
> [quoted comment was deleted]

How do you differentiate between this and account takeovers though? If someone constantly lives in from California, and then someone elsegets their Gmail password and logs in through Tor, can you know it's actually a compromised account and not the registrant just deciding to use Tor?
Yeah sure I agree. But this is a problem. Pretending like it isn't is basically cognitive dissonance. Why? These companies consistently refuse to secure their sevices to maximize profit.

The problem is they live in a completely self centered world where profit must be maximized. This is why this results in less secure devices by design. This is why you need regulation.

You leave it to the companies, they will almost always decide based on profit. Even if it results in a totally insecure product. See:http://iss.oy.ne.ro/Aether
Brian McKenna's Wart Remover[1] is an excellent tool for capturing silent (but deadly) errors at compile time.

Can also turn on various scalac -X flags to, for example, turn warnings into compile time errors. Invoke scala REPL with -X to see available flags.

[1] https://github.com/typelevel/wartremover
The most interesting part of this (to me) is that they brute-forced the .onion address (which is normally the SHA-1 hash of a public key).

Good thread on StackExchange about how to do that: http://security.stackexchange.com/questions/29772/how-do-you...
Indeed, that might be why, but I didn't think he was particularly worried about public opinion at this stage. Maybe it's next year's election looming? Still, I'm concerned about how that's going to go.

I have family members over there. I've Heard Stories about Viktor Orbán. I've made sure they have an emergency exit strategy if things go any further south.
I once was like most of your colleagues. I am an software engineer and I worked in startups for couple of years. In the end I worked my ass off for nothing. But I guess I can only blame myself. The problem was that I didn't have a clear vision of where I wanted to be in the future.
In the times before computers existed, I probably wouldn't have a choice (poor family + I'm not that intelligent = menial labor).
wrong unity

https://launchpad.net/ubuntu/+source/unity
Just keep in mind that it's an opinionated list. I routinely and intentionally violate several of these rules and have no intention of stopping that.

Much of it will depend on your application domain and needs. For example, if you're dealing with matrices, avoiding destructive updates will only give you a performance hit without an increase in maintainability.
Well. . . . What if we find the attack vectors, notify the companies then when they dont remotely patch(or cant/ignore as i assume is the most plausable option), publicly release.

I have a "smart" tv my wifw purchased while i was away on business, but theres no way thats being connected.
It is absolutely not your problem to comment on this matter. It's actually none of your business.

Also, admitting that you were looking at offer letters when you should have known straight away from first glance that it was none of your business could bring some heat on you and your career that you certainly won't appreciate.

Mind your own business.
Parallel construction. Become friends with the relevant coworker, casually ask one day how much they make, and that's a great opportunity to point out that you were making more when you were that experienced so maybe they should ask for a raise.

I would personally be pretty offended if you read my offer letter even accidentally, despite being very happy to tell you how much I make.
Have you looked into screens marketed as monitors? You might be able to find one of sufficient size with sufficient inputs, and they tend not to be infected with the "smart" garbage.
It's not nice to lie. There is nothing wrong in trying to get the best package possible. You just should not be doing it with lying.
The Non-Techie Guide to Source Control
I stopped by the local store after work: All three sizes were sold out. I was able to try on their demo units and pick my size -- on the online store medium was available in December, but small and large were still in stock (at that time).

I'd say they have a hit.
I think your first statement is 100% true. Most people have no idea how much waste there is.

But some people still try to say it's huge, without any proof other than what they've heard on talk radio.
That's very true. It's the freedom vs. chaos dichotomy that all societies have to struggle with at one time or another. As for pedophiles, I believe this is the domain of real world social services. Abuse doesn't occur in a vacuum and there are always signs to look for, both in schools, with friends and the local neighborhood.

Of course, competent workers in social services and an adequate budget in this field are other troublesome subjects, but I do believe no crime takes place online without a real world component. Therefore, there should be real world clues to follow.