The Official Status Thread

blakeyrat

@Lorne_Kates said:

For any fellow Canuks, if you have a Princess Auto near you, they're awesome.http://princessauto.com/

I wouldn't go to an auto shop run by a person named "princess."

I'd go to a Dutch Auto. Assuming it was the nickname "Dutch" and not, you know, Holland.

FrostCat

@TimeBandit said:

If it's old and rusted, don't bother with the trouble. If you break a fuel line, it's gonna be hell.

It's submerged in the fuel tank--no way to tell without fishing it out. There's an access hatch in the floor.

Polygeekery

@blakeyrat said:

I'd go to a Dutch Auto. Assuming it was the nickname "Dutch" and not, you know, Holland.

http://imagesmtv-a.akamaihd.net/uri/mgid:file:http:shared:mtv.com/news/wp-content/uploads/2015/11/Dutch-Dooley-1448488690.gif

FrostCat

@Lorne_Kates said:

I still need to call about the warranty. The place I bought these winter tires from will swap them for free if they're on rims. (they are). Except you have to book, like, a month in advance and be willing to go Saturday at 9am an wait until 4pm, because everyone in Canada gets their tires changed at the same time.

Ah, so it's like your free, universal health care.

Discount Tire, you just walk in and maybe wait an hour or so if it's busy.

Polygeekery

@Lorne_Kates said:

Maybe a combination. I will see the message "The remote system administrator has disallowed the use of saved passwords" (paraphrase). But only on SOME RDPs, which implies it is a policy set server-side. But if I RDP to an XP machine, and then RDP from there into the same server, it lets me use saved passwords. So maybe it's:

I have a saved password I don't like saved passwords Fine, I'll tell the user to type it in instead

vs :pee:

(sends username and password through STDIN) "Welcome. Setting up your desktop"

Maybe, but if it is then it is a setting I am not familiar with. I am only familiar with the local setting, which cannot be changed by group policy.

Redirecting

Instead of whatever hostname they say in there, just put in a single asterisk. It works a treat, and I never see that on machines I have changed the setting on locally.

Polygeekery

@Lorne_Kates said:

Maybe it's the shocks then? I-- I kinda need to learn what things are called. Step 0.

A strut is like a shock, except that it also has the coil spring perches (that hold the coil spring in place) on them and they are also usually part of the front suspension linkage. They pivot with the front wheels and hold the tire in alignment.

That is a shitty explanation, but it is the best I can think of. Probably best to just check out the Wikipedia article. Point being, it is not as simple as changing shocks. Shocks are two bolts and they come out. Changing struts requires taking most of the suspension apart, including the very dangerous coil springs.

HardwareGeek

Status: Dinner. Made chicken and rice. Meat thermometer readings are inconsistent. Most indicate fully cooked, some are well into the shoe leather zone, but some are stuck solidly at salmonella. After a couple of bites of shoe leather chicken, I'm rather inclined to believe the salmonella readings. Back into the oven.

Lorne Kates

Will read link at work. If it helps, 10q.

Lorne Kates

@Polygeekery said:

Shocks are two bolts and they come out.

That must be it. Watched a youtube. Dismount tire, remove bolts, take off tube. Put on new tube, grease bolts, put them back, tire on.

dse

Yes! Now I have to set up a fresh install and test to prove myself I am not full of shit. I swear it did not work when the box was virgin, but now that it has the corporate name in it (as default highlighted) pasting works too. There is the option that I am a chubby bag full of shit too.

Luhmann

@RaceProUK said:

WinPhone

Found your problem.

Posted from my Android.

Luhmann

@Lorne_Kates said:

Princess Auto

Down side is you get it back all covered in glitter?

Arantor

Or perhaps in another castle?

Luhmann

If you are required to climb in through the top tower window using hair I'm out.

Arantor

I used to be compared to Shrek a lot, so I'd be going in the front door and running around yelling a lot.

Luhmann

Better out then in I always say.

Arantor

Appropriate for the Belch, I'd say ;)

Cursorkeys

Status: "I don't like those round things, it's not clear. Make it be the square one with the tick but only allow them to select one".

Nooooo

DogsB

@Cursorkeys said:

Status: "I don't like those round things, it's not clear. Make it be the square one with the tick but only allow them to select one".

Nooooo

Oh christ that is going to be an arseache and a half. Anyone taking bets on the next bit being :

This part of the ui is inconsistent with the rest of the ui. I want to be able to select more than one at once.
But they're mutually exclusive options.
Then use the one I selected.

cartman82

STATUS:

Just figured out a cool Markdown plugin for mail clients.

So much better than fucking WYSIWYG editor in Postbox! And I'm not even being sarcastic.

Can't wait to send an email to someone.

cartman82

@Cursorkeys said:

Status: "I don't like those round things, it's not clear. Make it be the square one with the tick but only allow them to select one".

DogsB

STATUS Everyone appears happy with my work and corrections. A major expansion to the feature is planned but we get to write a full suite of tests before hand! But I have to write tests :( We will have a safety net at last!

RaceProUK

Something's up with the hosting of that image:

DogsB

JazzyJosh

TimeBandit

@Lorne_Kates said:

Okay, they aren't bad as a shop, but I would never step foot into their garage.

I never said to go have your car fixed there. Of course that would be wrong, since the mechanic gets a commission on every parts he sells you. He's as much a salesman as a mechanic.

But when you need a specialized tool to fix your car, most can be borrowed for free from Canadian Tire if you buy your parts there.

Fox

@dcon said:

But since this is an exam question, it's "probably" "safe" to assume sizeof(int) == sizeof(int*)...

Yeah the table for filling in the memory has the "addresses" for each variable and they're all 32 bits in size.

Filed Under: 504 OK: Body is too similar

Tsaukpaetra

Status: Somehow they pushed an SSIS DTSX package to a SQL Server that doesn't (or, at least, shouldn't) have that activated. Now I know why the version doesn't match even closely what it's supposed to be...

Magus

Status: Trying to clarify whether or not the people above me really want me to undo a change, or if they really just didn't realize that it's done and would be more work at this point to remove. Joy.

Lorne Kates

@TimeBandit said:

But when you need a specialized tool to fix your car, most can be borrowed for free from Canadian Tire if you buy your parts there.

Or at the very least, Part Source, which is Canadian Tire's "car parts only" spin-off shop. They're pretty good, except chose the weirdest things to be out of stock of. Like lightbulbs.

Lorne Kates

status Livingstone H. McShitFucker, it's been one of those days.

Yesterday we got an support request from one of our partners in Italy. (The product has resellers in Europe). Turns out the navigation menu freaks out with 1000 categories. No shit. But 2 minute page response time isn't good. I looked at the code, and sure enough it's kinda dumb. Anything over 50 categories will make the treebuilder shit. O(N^2) dumbfuckery. Some tweaks, it's down to <500ms. Done, delivered. All the while I have Le Bossman asking for progress, because it's a big customer, and it is kinda a dumb error to have in the brand new version of the product. So that was half of my yesterday.

Today I come in to find the Italian partner implemented it in their test environment, and performance is still shit. So for the past several hours, I've been on a conference screenshare call to Italy.

Confirmed they actually imported the code 
Confirmed the project built instead of failing silently 
Made sure they copied the built code to the website instead of not 
SQL Profiler-- it isn't any data dumbfuckery, is it? Nope. 
Hey, since we have your dev machine open, can you run it locally and see if it works. The code works. Okay. 
Can you point your dev machine to the test database to make sure it isn't the data? It works. 
Here's the compiled code from MY dev environment that I know works. Install it? Still slow as poop. 
Give me YOUR code, and your compiled code. Both work fine on my machine. 
Why does Task Manager say IIS worker is spiking CPU to 100%? That isn't right. Let's make sure all IIS settings are correct. They are . 
Let's try spinning up a new website. It is still slow. 
Let's try spinning up a new instance of IIS on the DB server (bypassing the web server entirely). it is still slow. 

Hours. Meanwhile all the work I was supposed to get done yesterday and today are languishing. The customer relations manager is pulling out her hair because she's catching all the overflow of support emails. (We haven't replaced yet-- grrr). And in the end, all I can determine is that the ONLY difference between the working environment and the non-working one is-- the non-working one is on Azure. It isn't because it's virtual (so is my lab server). It isn't underpowered (it's provisioned to at least 4x the recommended specs for the site). It's Azure.

So I'm going to assume that since it's a Microsoft thing-- fucking Azure. Fuck you Azure. Fucking fuckity blue fuck.

royal_poet

Freezing my butt off at Brighton Station waiting.

blakeyrat

@Lorne_Kates said:

So I'm going to assume that since it's a Microsoft thing-- fucking Azure. Fuck you Azure. Fucking fuckity blue fuck.

It's "well-known" among people who use cloud database that Azure SQL is different-enough from SQL Server SQL that it requires totally different optimizations.

I frequently talk to a guy at Gibraltar Software who bitches about this constantly. He told me he's lost 2 customers due to shitty Azure SQL performance that happens despite their constant optimizations.

Anyway, long and short is: if you're going to support Azure SQL, you have to test it completely separate from your SQL Server QA. Because it's not the same. Not even slightly.

If you want I can ask him if he's willing to lend a hand. But without access to your source he might not be able to do much more than commiserate.

izzion

Doesn't seem useful, unless you're able to make a surprise play to Mornington Crescent.

Tsaukpaetra

Status: Zounds! Why are we keeping code that's been "removed" almost six years ago

royal_poet

Waking for @Arantor to get here. I think I've been stood up. Might have to give the flowers I got for him to someone else as a random act of kindness - before I decapitate them.

Lorne Kates

@blakeyrat said:

It's "well-known" among people who use cloud database that Azure SQL is different-enough from SQL Server SQL that it requires totally different optimizations.

Hmm.

@blakeyrat said:

Anyway, long and short is: if you're going to support Azure SQL, you have to test it completely separate from your SQL Server QA. Because it's not the same. Not even slightly.

I thought they were using MSSQL server install in Azure, but now I'm not sure. I didn't know "Azure SQL" was a thing.

@blakeyrat said:

If you want I can ask him if he's willing to lend a hand. But without access to your source he might not be able to do much more than commiserate.

Thanks. I'm expecting a report back from the partner over the weekend. I know a lot of our customers have been eyeing Azure because it's cheaper than buying/maintaining servers and licenses. If this does become an Azure issue, I'd probably raise the idea of paying for some consulting to review the source and talk about Azure best practices. If so I'll PM you.

blakeyrat

@Lorne_Kates said:

I thought they were using MSSQL server install in Azure, but now I'm not sure.

Oh; well nevermind then. That's totally different. There's Azure SQL, which is Azure's version of RDS (if you're familiar with Amazon cloud services), then there's just running a SQL Server instance in an Azure VM. Two totally different things.

The general point is: you need to figure out what environment they're using and test in the same environment. If you're not capable of it, the only response is, "we don't support that environment, sorry."

izzion

Also, we've had some experiences at my job with SQL in an Azure VM performing different (read: more poorly) than on prem SQL

Azure SQL is like the discourse mobile of database solutions. Except with better customer service, a better supporting ecosystem, and no Jeff.

blakeyrat

Azure SQL has uh... some "features" which makes me wonder why anybody would adopt it. For example, while Amazon gives you a service window of one hour, Azure SQL gives you a window of about 3 days. 3 BUSINESS days. At literally any moment, they could take down your DB in a period of 3 BUSINESS days.

That alone is enough to, in my mind at least, disqualify it for any business-sensitive uses. I mean, you can chug your daily analytics data on one I guess, but don't even think about using it to process payments.

izzion

I think Lorne hit the adoption driver on the head. People are already comfortable with the MSSQL stack, but aren't that enamored with its 2nd highest platform cost. So they see a "cloud" "Microsoft", "SQL" solution AND they can save monies, so damn the fine print and full speed ahead!!!!

IT by bottom line usually has predictable results, at least?

and that's why we're all here

Lorne Kates

@blakeyrat said:

The general point is: you need to figure out what environment they're using and test in the same environment. If you're not capable of it, the only response is, "we don't support that environment, sorry."

For sure. Their software guy is going to create a non-Azure server, install the same code and data, and see if it explodes. I suspect it won't. Then it's either "we don't support", or "oh shit enough of our customers use Azure we better figure it out". Kinda like how people used to say "lol Chrome whatever".

Eldelshell

Status: can't believe this worked out. So I'm working on project code name which currently is being a Node/Express backend and some client-side vanilla JS to sprinkle the rendered HTML

Cool thing is that for the client side code I'm using ES2016 and Webpack/Babel and I've been able to do this:

import _isNumber from 'lodash/isNumber';

class Stuff {
    static do() {
        console.log(_isNumber(1));
    }
}

With this folder structure:

├── app.js
├── client
│   ├── main.js
│   └── utils
├── node_modules
│   ├── lodash
│   │   ├── isNull.js
│   │   ├── isNumber.js
│   │   └── zipWith.js
│   ├── webpack
│   └── winston
├── package.json
├── public
│   └── javascripts
│       ├── app.js
│       └── app.js.map
└── webpack.config.js

Haha! No bower/grunt/gulp crap! yet :-s

Lorne Kates

http://i.imgur.com/ld3IYsX.png

Pledge Tolgnore is the name of my Swedish death metal band.

blakeyrat

JazzyJosh

Is that the blakeyrat family photo?

Cursorkeys

Status: My cat just got on my lap for a cuddle. I tickled his face and told him how much I loved him for always loving me unconditionally...He then farted heavily and it smells like a dead rat.

Anyone want a free cat?

JazzyJosh

Status: SourceTree allows you to stage hunks and individual lines with a button click. TIL.

That's magic.

Magus

@Magus said:

Status: Trying to clarify whether or not the people above me really want me to undo a change, or if they really just didn't realize that it's done and would be more work at this point to remove. Joy.

My company does not need an article here for this, as it turns out.

DogsB

Happy for you sad for us :(